Re: Delphi 5.0 ADO with d5adoupdate2 fail with findNext ?
- From: "g" <jukka.raisio@xxxxxxxxxxxxxxx>
- Date: Mon, 26 Jun 2006 18:38:53 +0300
What I try to do: Use old code with ado with minimum change ;)
Do the TQuery have build in cursor?
Old BDE allow structure just like in this excample
(for simple TQuery "select * from table test")
-------------
with qryTmp do
begin
... query init
if active and findfirst then
repeat
... code
until not findNext;
end;
--------------
Ado gives BOF / EOF, with TADOQuery
I realize that first,next... with "while not EOF do" checking works just fine.
Since I didn't find any document that findNext may cause problems,
I'm just curious. BDE let me write simpler code, ADO seems to require
more. no requestlive and "param" handling is different, must close before SQL.Clear;
-jukka
"Dennis Passmore" <dennis_passmore@xxxxxxxxxxxxxxxx> kirjoitti viestissä news:eniv92pmms5f1uum4hem096k5j1sd7jq2e@xxxxxxxxxx
What are you doing to override the system FindFirst and FindNext functions? Windows FindFirst and
FindNext are boolean functions that require varible information being pasts into them in order to
work. You must have some kind of overrides in your code. The exceptions you are getting in you
ADODB.pas file is simply because the Cursor (_Recordset) is not assigned and checking BOF or EOF
will always raise a exception.
Dennis Passmore
"If you cannot conceive the idea you
will never achieve the desired results"
.
- References:
- Delphi 5.0 ADO with d5adoupdate2 fail with findNext ?
- From: Nyssi
- Re: Delphi 5.0 ADO with d5adoupdate2 fail with findNext ?
- From: Dennis Passmore
- Delphi 5.0 ADO with d5adoupdate2 fail with findNext ?
- Prev by Date: Re: Delphi 5.0 ADO with d5adoupdate2 fail with findNext ?
- Next by Date: Re: Refresh DB
- Previous by thread: Re: Delphi 5.0 ADO with d5adoupdate2 fail with findNext ?
- Next by thread: Refresh DB
- Index(es):
Relevant Pages
|
