Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is this table Free or a Memeber of a DBC?
Message
From
23/03/1998 10:38:45
 
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00086396
Message ID:
00086405
Views:
33
>Is there a function to tell where a table is a member of a DBC or a free table. I have an open DBC and before I open a table I need to know if it belongs in the DBC or is a free table. I open the files with different parameters depending on the source.

Yes. Assume that the database name is BIGAPP and the table name is ORDERS...

OPEN DATABASE bigapp
nArrayCnt=ADBOBJECTS(laTables,"TABLE") && laTables contains list of DB tables
nFound=ASCAN(laTables,"ORDERS")
IF nFound # 0
**** Yes it is in DBC
ELSE
**** No it isnt
ENDIF
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Reply
Map
View

Click here to load this message in the networking platform