Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table Existence
Message
 
To
03/05/2001 11:45:14
David Brunelle
Université de Sherbrooke
Sherbrooke, Quebec, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00503085
Message ID:
00503093
Views:
21
>Now that I know if a certain field exist.. I need to know if a certain table already exist so that I won't create it twice...

if adir(laTbl, "path\tablename.dbf") > 0 then
    use path\tablename.dbf in 0
    select tablename
    =afields(laFld)
    if ascan(laFld, "fieldname") > 0 then
       *!* Field exists in table.
    endif
endif
HTH,
- Erik Niese-Petersen

Crazy Dane in USA.
Previous
Reply
Map
View

Click here to load this message in the networking platform