Hi Guys,

I'm facing a problem with the ElevateDB 1.06 B1 Manager (non-Unicode).
I can't execute this Insert statement.

INSERT INTO GEN_TABLE_FIELD VALUES ("REF_TIME_PERIOD","offset_from_today_ind",71,"E","Period Offset","I",0,"0","Y","N","N",0,null,"",null);

Error- ElevateDB Error #700 An error was found in the statement at line 1 and column 37 (Expected column name but instead found "REF_TIME_PERIOD")

What's the bug ?

Thanks

Praveen,

> INSERT INTO GEN_TABLE_FIELD VALUES ("REF_TIME_PERIOD","offset_from_today_ind",71,"E","Period Offset","I",0,"0","Y","N","N",0,null,"",null);
>
> Error- ElevateDB Error #700 An error was found in the statement at line 1 and column 37 (Expected column name but instead found "REF_TIME_PERIOD")
>
> What's the bug ?


The bug is that you are using double quote characters (") for string
literals. You use double quotes for quoted identifiers (table names,
column names etc.) and single quotes for string literals.

Eryk

Thanks Eryk My mistake, the same statement works in DBISAM.