Hi Dave,

> I keep getting an error
> "Token unknown - Line 1, Column 27
> ACTIVE"
> 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
http://www.upscene.com
http://blog.upscene.com/thomas/

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