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@stripped> 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@stripped]
>Verzonden: June 24, 2002 16:37
>Aan: mysql@stripped
>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@stripped |
| 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 |
+------------------------------------------------------------------------+
