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