Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 4 of 4 total |
Error creating tabe handleb |
Fri, Jun 6 2008 12:38 AM | Permanent Link |
"John Postnikoff" | 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 |
Fri, Jun 6 2008 3:27 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | John
Can you post your sql. Roy Lambert [Team Elevate] |
Tue, Jun 10 2008 1:17 AM | Permanent Link |
"John Postnikoff" | 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] > |
Tue, Jun 10 2008 3:34 AM | Permanent Link |
Roy Lambert NLH Associates 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] |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |