Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
INSERT statement failing in ElevateDB Manager |
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 My mistake, the same statement works in DBISAM.
|
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |