Could you try it again with ParseSQL := False? If that works it's still a bug, but then I know where to look at it.
Ow, and could you try to remove the TimeIn (12:55) ? And the DateIn (22/02/2006) ? On Wed, 2006-02-22 at 13:29 +1000, SteveG wrote: > Drat - spoke (or typed) too soon > can you tell me whats wrong with this line (works ok using the Interbase > unit) > INSERT INTO NLISTest (RecIdent, DateIn, TimeIn, Agent, Lot, Paint, > HeadCount,TagCount, ClientPIC, ClientNVD, ClientNAME, BeastPIC) VALUES ( > '1370984712', '22/02/2006', '12:55', 'A1', '0', 'P1', '0', '0', > 'XXX-03', 'XXX-03', 'XXX-03', '' ) > > fails with the following err: > PREPARESTATEMENT: [LF] -DYNAMIC SQL ERROR[LF] -SQL ERROR CODE = > -104[LF] -TOKEN UNKNOWN - LINE 1, CHAR 176[LF] -A1 > > Thanks > > SteveG wrote: > > > Thanks Joost - working find now > > does SqLite work using SqlDB, or is it seperate ? > > > > Joost van der Sluis wrote: > > > >> On Tue, 2006-02-21 at 09:26 +1000, SteveG wrote: > >> > >> > >>> Now I know I haven't a clue :) > >>> If I remove the Interbase unit, Laz can no longer find the > >>> TIBDatabase / query / trans > >>> So I assume from your examples I need IbConnection in the uses as well? > >>> When I compile the alisttables.pp example, I get the error > >>> 'SqldbExampleUnit.pp(80,72) Warning: Constructing a class > >>> "TIBConnection" with ab > >>> stract methods' - which brings me back to where I began to have > >>> problems > >>> > >> > > _________________________________________________________________ > To unsubscribe: mail [EMAIL PROTECTED] with > "unsubscribe" as the Subject > archives at http://www.lazarus.freepascal.org/mailarchives > -- Met vriendelijke groeten, Joost van der Sluis CNOC Informatiesystemen en Netwerken http://www.cnoc.nl _________________________________________________________________ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
