ALSO....with ADO recordcount will always return -1 if its a server
cursor.....
You need then ,to make a client side server. (this also needs to be a static
one, NOT a forward only).
Jeremy
Jeremy Coulter
Application Developer
Application Development Centre
Compaq Computer New Zealand Ltd.
Phone: 64 3 371 5724
Fax: 64 3 371 5724
Mobile: 64 0212533214
E-mail: [EMAIL PROTECTED]
Personal Email: [EMAIL PROTECTED]
-----Original Message-----
From: Mike Mueller [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 12, 2000 11:50 AM
To: Multiple recipients of list delphi
Subject: Re: [DUG]: MAJOR ADO PROBLEMS - Please try this code and let me
know if you get the same results
I thought RecordCount was something that was only safe to use with Paradox.
Have you tried using Query.isEmpty to determine if anything was returned?
Or perhaps Query.First, and then check Query.Eof?
----- Original Message -----
From: Chris Crowe <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: Wednesday, January 12, 2000 11:03 AM
Subject: RE: [DUG]: MAJOR ADO PROBLEMS - Please try this code and let me
know if you get the same results
> Recordcount will be 0 if there are no records returned, but it will be 1
if
> there is 1 - X records returned. I only want to know if there is a record
> returned or not.
>
> In my code I included (previous message) if you put a delay before the
> Query.Open statement you do get a record returned, on my machine a delay
of
> 410 ms return a record count of 0, whereas a delay of 411 ms returned a
> record count of 1. Why should I have to have a delay after I post a record
> to be able to query that record?
>
> This is only one of the problems with these ADO components which have
caused
> me nothing but problems in the 2 days of using them.
>
> Chris
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Grant Black
> Sent: Wednesday, 12 January 2000 10:24
> To: Multiple recipients of list delphi
> Subject: RE: [DUG]: MAJOR ADO PROBLEMS - Please try this code and let me
> know if you get the same results
>
>
> BTW - I wouldn't use RecordCount for Access (or any other database than
> Paradox).
>
> Better to use:
> if .First = .Last
>
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
