Re: RecordCount

First, you need to check some options of the MySQL behaviour at the DSN
Setup. The options you need to check are:

Return Matching Rows
Allow Big Results

If you can use ADO with Delphi (I don't know if it's possible, 'cause i
don't program in Delphi), you can use the RecordCount property.

Regards,
Ramiro



----- Original Message -----
From: "Steve Edberg" <sbedberg@xxxxxxxxxxx>
To: <peter_stoecker@xxxxxx>; <mysql@xxxxxxxxxxxxxxx>
Sent: Friday, June 28, 2002 1:49 PM
Subject: RE: RecordCount


> I assume you are using ODBC to access MySQL; I have had this problem
> before (sorry, don't remember the details...it was several years
> ago). Some ODBC drivers don't return the record count - they return
> -1 instead. You might need to update your driver. The myodbc mailing
> list might be of more help...
>
> -steve
>
>
> At 4:04 PM +0200 6/28/02, "Wouter van Vliet" <wouter@xxxxxxxxxx> wrote:
> >Maybe you can give us the querie and create table statement for the
table(s)
> >where the error occurs?
> >
> >Wouter
> >
> >-----Oorspronkelijk bericht-----
> >Van: Peter Stöcker [mailto:peter_stoecker@xxxxxx]
> >Verzonden: June 24, 2002 16:37
> >Aan: mysql@xxxxxxxxxxxxxxx
> >Onderwerp: RecordCount
> >
> >
> >Hi there!
> >
> >I'm using MySQL with Delphi 5.
> >
> >After running a query i get a recordcount of -1. But when I check the
result
> >there are records.
> >
> >Can anybody help me?
> >
> >
> >Thanks,
> >peter
>
>
> --
> +------------------------------------------------------------------------+
> | Steve Edberg                                      sbedberg@xxxxxxxxxxx |
> | University of California, Davis                          (530)754-9127 |
> | Programming/Database/SysAdmin               http://pgfsun.ucdavis.edu/ |
> +------------------------------------------------------------------------+
> | "If only life would imitate toys."                                     |
> |                  - Ted Raimi, March 2002                               |
> |                  - http://www.whoosh.org/issue67/friends67a.html#raimi |
> +------------------------------------------------------------------------+
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread113329@xxxxxxxxxxxxxxx>
> To unsubscribe, e-mail
<mysql-unsubscribe-ramiro=powerline.com.br@xxxxxxxxxxxxxxx>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread113364@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail 
<mysql-unsubscribe-gcdmg-mysql=m.gmane.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php