[fpc-pascal] EDatabaseError on SELECT

Stephen Chrzanowski pontiac76 at gmail.com
Wed Feb 10 16:38:01 CET 2016


Nevermind... Ninja'd.

On Wed, Feb 10, 2016 at 10:36 AM, Stephen Chrzanowski <pontiac76 at gmail.com>
wrote:

> Did you output the iSQL string to a console or a text file or even a
> message box to verify that what you're passing in is actually what you
> expect?
>
> If the engine is coming back with a problem "Near Select" then there is
> something wrong either before the string, or after Select.  GetTableName
> may be returning something the query isn't expecting.
>
> On Wed, Feb 10, 2016 at 10:00 AM, Felipe Monteiro de Carvalho <
> felipemonteiro.carvalho at gmail.com> wrote:
>
>> Result in sqlite3 console:
>>
>> sqlite> SELECT * FROM "Header_0" WHERE ID=0;
>> 0|0|0|0|18|
>>
>> --
>> Felipe Monteiro de Carvalho
>> _______________________________________________
>> fpc-pascal maillist  -  fpc-pascal at lists.freepascal.org
>> http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freepascal.org/pipermail/fpc-pascal/attachments/20160210/16d235a1/attachment.html>


More information about the fpc-pascal mailing list