>#1- How do I check if "mytable" exists in active database?
>#2- How do I check how many tables are in active database?
>
>I have tried the DISPLAY TABLES command for the first one and the CURSORGETPROP() function for the second one but I'd like to know if there is any easier way.
>
>Thank you in advance.
See adbobjects() in VFP help. This will return an array of tables, views, connections or relations. You can then ASCAN() the array to see if the table exists in the DBC.
Mark McCasland
Midlothian, TX USA