Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CREATE TABLE doesn't work in a program file.
Message
 
 
To
25/10/1999 12:18:16
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00280418
Message ID:
00281229
Views:
12
>Hi John.
>
>>cElement="Checks"
>>CREATE TABLE TempFile (&cElement C(35), Group L)
>>
>>VFP creates a table called tempfile with the two fields in it.
>>
>>When this set of commands is issued from within a program file, I get the error "Feature is not supported for non-.DBC tables. (1580)"
>
>Are you sure cElement is "Checks"? I tested this and it works OK, but if you use "Check" instead, it doesn't. The reason: CHECK is a keyword that defines field and table rules, and they aren't allowed for free tables (hence the error message).
>
>Doug

For that matter, GROUP is a reserved, also. Since it is a clause in a SQL, I would avoid it as a field name.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform