I have created a form to read some edit boxes and do some SQL statements.
When I execute the statement the first time it works. When I try to execute
the same again, or issue another SQL command I get "Error creating table
handle".  I then have to close the application. Any ideas or tips will be
appreciated.


John

John
Can you post your sql.

Roy Lambert [Team Elevate]

Hi Roy,

Here is my code and statement:

UpdateQuery.Active :=true;
UpdateQuery.SQL.Clear;
UpdateQuery.SQL.Add('Update orders set route = route
='+Quotedstr(edit1.text)+'where route ='+QuotedStr(edit2.text));
UpdateQuery.ExecSQL;
UpdateQuery.Active.false;
UpdateSource.Refresh;


John



"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:65DC8ED1-317B-45CE-93BC-5EEEC2DA3EF0@news.elevatesoft.com...
> John
> Can you post your sql.
>
> Roy Lambert [Team Elevate]
>

John


The SQL looks OK, but the UpdateQuery.Active lines baffle me. If this is cut'n'pasted then its wrong. Try this

UpdateQuery.Close;
UpdateQuery.SQL.Clear;
UpdateQuery.SQL.Add('Update orders set route = route
='+Quotedstr(edit1.text)+'where route ='+QuotedStr(edit2.text));
UpdateQuery.ExecSQL;
UpdateQuery.Close;
UpdateSource.Refresh;

Roy Lambert [Team Elevate]