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

Reply via email to