🚀 go-pugleaf

>Firstly, thanks a LOT for this snippet! It works like a charm!
This thank if for Vladimir Stefanovic.

>Hmm, the only difference I can notice between the 2 bits of code is the 
>2nd doesn't use RecordCount. Is this the "unoptimised, slow and buggy" bit?

Yes. It will work on client-side cursor, but on server-side cursor 
RecordCount may be, and usually is, very expensive (time, resources) 
operation (specially in case of complex joins).

Also, when you scroll dataset, another user may add or delete rows to/from 
table, depending on settings this may be reflected on dataset, i.e. when you 
start scroll RecordCount is one number, but when you finish it may differ. 
Check for EOF is more reliable in this case.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + 
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"George Nakos" <gnakos@metronco.gr> �������/�������� � �������� ���������: 
news:op.swc1m3q7qf2fxd@promitheas.metron.internal...
> "Vladimir Stefanovic" <antivari@po.sbb.co.yu> OIIAYEI/OIIAYEIA ? II?IOONE
> OIAAOAYAA: news:4314651e@newsgroups.borland.com...
>> Something like this /UNTESTED!!!/
>>
>>   ADOQuery1->Open();
>>
>>   for ( int i=0; i<ADOQuery1->RecordCount; i++ )
>>   {
>>       AnsiString ROW = ADOQuery1->FieldValues["Field1"] + ", " +
>> ADOQuery1->FieldValues["Field2"];
>>       SomeStringList->Add( ROW );
>>       ADOQuery1->Next();
>>    }

Firstly, thanks a LOT for this snippet! It works like a charm!

> Usually it is very not optimized, in some cases may be slow and in some
> cases buggy. Better way is:
>
> ADOQuery1->Open();
> while (!ADOQuery->EOF)
> {
>   .....
>   ADOQuery1->Next();
> }
>

Hmm, the only difference I can notice between the 2 bits of code is the
2nd doesn't use RecordCount. Is this the "unoptimised, slow and buggy" bit?

Regards,
George Nakos

-- 
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/