Some database providers implementation always return -1 no matter the amount of records is returned. That happens to ADO too for certain cursors. The best way to go to count records is Count(*), prepare a query like Select count(MyField) from MyTable Where ... and then get the value.
I hope it helps. Good Luck! --- Peter Stöcker <[EMAIL PROTECTED]> wrote: > 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 > ______________________________________________________________________________ > FreeMail in der Premiumversion! Mit mehr Speicher, > mehr Leistung, mehr > Erlebnis und mehr Pramie. Jetzt unter > http://club.web.de/?mc=021105 > > > --------------------------------------------------------------------- > 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 > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php