Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create Table Confusion?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00456897
Message ID:
00456898
Views:
24
>
>? cTableName                      && Shows PRM1-6A28CBADAB4C11DFFA883999
>create table eval(cTableName) ;
>( ;
>nEmpID 		n(10,0) , ;
>cLastname 	c(64) , ;
>cFirstName	c(64) , ;
>tHireDate	t(8) , ;
>cIsTerm		c(32) , ;
>cNTName 	c(32) ;
>)
>
>
>I made a random table name using a GUID, and am now trying to create a table with that name (I have a DBC created and open).
>
>I am getting a syntax error whether I use eval or macro substituion or name expression.
>
>What is the proper way to format this so I always get a random table name?
>
>Thanks.

Take the eval off... you just want

create table (cTableName)...
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform