Products: BCB 4 professional MySQL latest MyODBC latest Here's the code I'm using bool AnAuthor::CheckIfExists(int p_ID) { TQuery *CheckAuthor = new TQuery(NULL); AnsiString strQuery; bool retVal; strQuery = "SELECT COUNT(*) AS AUTHORCOUNT FROM AUTHORS WHERE AUTHOR_ID=" + AnsiString(p_ID); CheckAuthor->DatabaseName = "bookcollection"; CheckAuthor->SQL->Add(strQuery); CheckAuthor->Open(); if (CheckAuthor->FieldByName("AUTHORCOUNT")->AsInteger >= 1) { retVal = true; } else { retVal = false; } delete CheckAuthor; return retVal; } This way, it retrieves the recordcount exactly, but if I use CheckAuthor->RecordCount instead of: CheckAuthor->FieldByName("AUTHORCOUNT").AsInteger I get a nonsense answer. John Meyer [EMAIL PROTECTED] Programmer If we didn't have Microsoft, we'd have to blame ourselves for all of our programs crashing --------------------------------------------------------------------- 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