Re: ADO and subquery
- From: "Kevin Frevert" <kevin@xxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 19 Jan 2007 10:34:54 -0600
"treok" <h.k.j.keesmaat@xxxxxxxxx> wrote in message
news:45b0d0c9@xxxxxxxxxxxxxxxxxxxxxxxxx
If I use subquerys within a query in a ADOdataset I get very often a
EAccessviolation in module 'ntdll.dll' or module 'msvcrt.dll'.
When I check these query in SQL Query Analyzer it runs without a problem.
Is this a ADO problem?
Yes. On my machine, sometimes I get an error, other times Delphi (Delphi 6)
just disappears (no error or anything). Funny thing is/was that some of our
other developers here have no problems with sub-queries in an ADO dataset.
The only way I found around the problem is to put the code in a View or
build the SQL dynamically.
Good luck,
krf
.
- Prev by Date: Re: Sql Insert Error
- Next by Date: Re: ADO and subquery
- Previous by thread: How to handle disconnect
- Next by thread: Re: ADO and subquery
- Index(es):
