Zeoslib Portal

both CAST and ::integer returns "False" in this query
I don't know what the reason ...

But CASE is good idea ... I guess i take it thanks

ok ... I resolve the problem.
It must by "field"::::integer from any reason.
But now query return value "False" without conversion.
I need integer value ....

I use ZEOS component in Builder C++ with PostgreSQL 8.2
I've got strange error with query

select "field"::integer from "table"

syntax error at or near ":"

type of "field" is boolean
what can it be?

Ok, I've found a way to do that [code] void func(void * p,int n,char ** pp) { } IZSQLiteConnection * sqliteConn = NULL; ZConnection1->DbcConnection->QueryInterface(&sqliteConn); sqliteConn>GetPlainDriver()>CreateFunction(sqliteConn>GetConnectionHandle(),"IDENT_CURRENT",1,func,NULL); sq...

How can I create my own function with ZEOS and Builder C++?
I mean how to access sqlite function "sqlite3_create_function"? I need sqlite handle for it ...