On Fri, 15 Feb 2013, zeljko wrote:
On Friday 15 of February 2013 13:43:21 Michael Van Canneyt wrote:
On Fri, 15 Feb 2013, zeljko wrote:
On Friday 15 of February 2013 09:57:11 Martin Schreiber wrote:
On Friday 15 February 2013 09:36:47 zeljko wrote:
On Friday 15 of February 2013 00:29:01 luiz americo pereira camara
wrote:
I just tested with sqlite3ds and works fine. See test below. You may
look at its source and see if the approach used can be adapted for
zeos
There's no problem with such approach, but as I already said it's not
solution for me since there's hundreds of dynamic queries and I have to
rewrite all of them to get it work in that way (and that queries are
used by pgsql too).
Just in case, I added a check of sqlite3_column_type() if there is no
existing fielddef. Seems to work for sum() statements. git master
81d976c8372a6654a3a2962e12d57c53eaac0176.
Thanks for the idea, sqlite3_column_type does the job, but now I have
another error ... seem that step() doesn't know anything about some
column types, even if I call sqlite3_column_type inside step() call I
get empty column type result.eg. in one CREATE VIEW someview(blabla
fields,CAST(0 AS INTEGER) AS myintfield, etc etc. ...)
When I call that view I can see 0 in sqlite3 utility, but zeos returns it
as empty string ....ahhhhhhh whatta mess.
You should use a real database instead of sqlite.
sqlite is good only for storing strings.
O yes ? Is there any other database on android phones/tablets except sqlite3
? :) ... I'm using pgsql but need local database on Android devices (those who
does not connect to pgsql or similar).
http://wiki.freepascal.org/ZMSQL
Michael.
--
_______________________________________________
Lazarus mailing list
[email protected]
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
