Subject Re: [IBO] Trouble with Insert Into
Author Thomas Steinmaurer
Hi Dave,

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

ACTIVE is a reserved word, thus you have to enclose it with
double-quotes to use it as an identifier.

> 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")

Use single quotes for specifying strings.

With regards,

Thomas Steinmaurer
Upscene Productions

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!