![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
![]() |
Fri, Nov 30 2007 6:44 AM | Permanent Link |
Praveen | 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 |
Fri, Nov 30 2007 7:27 AM | Permanent Link |
Eryk Bottomley | 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 |
Fri, Nov 30 2007 8:08 AM | Permanent Link |
Praveen | Thanks Eryk
![]() |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |