[Lazarus] Problem with zeos and sqlite-3

[Michael Van Canneyt]

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.