![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » Search Forums » Search Results » View Thread |
Messages 1 to 1 of 1 total |
![]() |
Tue, Jun 18 2019 10:50 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | I was writing code to geneate sql to create a temporary table and then index it. I received this error message --------------------------- Debugger Exception Notification --------------------------- Project MOA.exe raised exception class EEDBException with message 'ElevateDB Error #700 An error was found in the statement at line 2 and column 1 (Missing ))'. --------------------------- Break Continue Help --------------------------- The bit of code where the sql is executed went like this dm.DB.Execute(sl.Text); <<<<<<<<<<<<<<< sl is a TStringList with a wadge of lines sl.Free; dm.DB.Execute('CREATE INDEX Code ON "IRD" (_ACode'); I finally spotted the place where the error is but "line 2" really mislead me for quite a while into trying to figure out why when I captured the content of sl it executed perfectly in EDBManager - didn't think to look at the ONE line statement (sorry for shouting) Roy Lambert |
This web page was last updated on Saturday, June 22, 2024 at 05:51 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |