Hi,

I keep getting an error
"Token unknown - Line 1, Column 27
ACTIVE"
which is the "A" in Active in this line...

INSERT INTO tbl_Accounts (Active,Code,Name,Data0,Data1,Data2,Data3,Data4,Data5,Data6,Data7) VALUES("Y","9","Test","1","2","3","4","5","6","7","8")

When I use IBConsole or IBExpert they both show a valid Char for ACTIVE with a length = 1

Where am I going wrong?

I tried breaking it up into several lines and Add to the SQL StringList but that made no difference.

Thanks

Dave