Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create table syntax
Message
From
29/06/2000 23:19:22
 
 
To
29/06/2000 21:37:04
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00386897
Message ID:
00386922
Views:
14
Eric,

Did you cut and paste the exact lines from your program into this message, or did you type them in? Could you please check the original lines again, to be sure they are the same?

Also, please put this line before the CREATE TABLE, and see what the value is:
WAIT WINDOW ALLTRIM(Thisform.txtFileName.Value)
Then, try the commands at the Command Window, substituting that value into the first line, to see if they work properly there.

>cFileName = CURDIR()+"DATA\"+ALLTRIM(Thisform.txtFileName.Value)
>CREATE TABLE &cFileName (Field1 N(2), Field2 C(8))
>
>- OR -
>
>cFileName = CURDIR()+"DATA\"+ALLTRIM(Thisform.txtFileName.Value)
>CREATE TABLE (cFileName) (Field1 N(2), Field2 C(8))
>
>returns an error message "Field name is a duplicate or invalid."
>
>What could possibly be wrong?
David Stevenson, MCSD, 2-time VFP MVP / St. Petersburg, FL USA / david@topstrategies.com
Previous
Reply
Map
View

Click here to load this message in the networking platform