Nerissa,
you may also try to play with LIST TABLES as
USE your_table
lcDBF = LOWER(DBF())
lcFile = SYS(2015)
OPEN DATABASE DataToAsk
LIST TABLES to FILE (lcFile) NOCONSOLE
lcTables = FILETOSTR(lcFile)
DELETE FILE (lcFile)
IF lcDBFf$lcTables THEN
?'Table found!
ENDIF
Normaly ther must be something better, but this works
Agnes
>Aside from opening a database to know the tables it contains, is there a VFP command that I can use to determine if a table belongs to a certain database or if it is a free table? I tried using AFIELDS to examine column 12 (long table name from DBC). Is this column always empty for a free table and has a value when a table is in a database?
>
>Thank you very much.
>
>Nerissa Dela Rosa
>McFadden's
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]