|
-
Feb 11th, 2001, 06:46 PM
#1
Hi, I am in the process of buildig an interface for MySql. I have no problems returning a list of databases, the tables in each, and the description of each table. However, I am forced to use the Command object in doing this. I need to return the number of records that is populating a table explanation. I am unable to use the .RecordCount property due to the type of recordset that the command object returns. Perhaps a nested SQL statement? e.g. : select count(*) from 'explain table_whatever' haven't tried this... thanks for your help!! Any ideas of other ways to get the record count? Note that this is NOT a normal recordset, this recordset is a description of a table (fields, data types, keys, etc) so select count(*) by itself will not work. Thanks for your help!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|