ADOQuery in thread hangs
- From: "Mikael Lenfors" <mikael@xxxxxxxxxx>
- Date: Tue, 21 Nov 2006 23:00:55 +0100
Hello!
Having a real nightmare problem at the moment. In my main program I have a
ADOConnection and several associated ADOQuerys. They are all connected to an
Access file.
Then I have a TThread containing it's own ADOQuery, connecting to the same
Access file doing some selects. I can run the thread as many times as I want
without any problem. If I then do an Insert statement in the main program a
strange thing happenes. The next time I'm running the thread it DIES at the
first line where I do ADOQuery.SQL.Add...
ADOQuery.Close;
ADOQuery.SQL.Clear;
ADOQuery.SQL.Add('Select * From Units Where UnitID = ' +
IntToStr(UnitRecord.UnitID));
ADOQuery.Open;
The above is sample code from the thread, if I trace it and press F8 at the
Add line it just dies there, no exceptions what so ever.
Running Win XP Pro and Delphi Studio 2006
Please any ideas?
.
- Follow-Ups:
- Re: ADOQuery in thread hangs, Solved !!!!!!!!!
- From: Mikael Lenfors
- Re: ADOQuery in thread hangs
- From: Guillem
- Re: ADOQuery in thread hangs
- From: Brian Bushay TeamB
- Re: ADOQuery in thread hangs, Solved !!!!!!!!!
- Prev by Date: Re: TADODataSet Filter
- Next by Date: Re: ADOX set-up
- Previous by thread: TADODataSet Filter
- Next by thread: Re: ADOQuery in thread hangs
- Index(es):
Relevant Pages
|
