Agnes,
This returns the empty string if it is a free table and is the safest bet
use SomeTable alias AnotherTable
?cursorGetProp('Database', 'AnotherTable')
for indbc() you need the tablename, the alias won't do
use SomeTable alias AnotherTable
?indbc(CursorGetProp('SourceName', 'AnotherTable'), 'Table')
>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
Gregory