Can do - possibly not till tomorrow though - have pulled my program
apart (again) and need to get it stable to test
understand about the Dt & Tm - customer wants them this way for older
program pulling data from file - cant (or wont) reformat to suit up the line
(what can you do, they pay the bills - indirectly)
Joost van der Sluis wrote:
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
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
