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:
00456899
Views:
30
>>
>>? 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)...

Not sure, you can use "minus" as a legal character in table name. Use underscore instead, e.g.
#DEFINE SYMBOLS "?!+-'%^&~()$"  && Better not use these symbols in TableName
lcTableName=strtran(chtran(lcTableName,SYMBOLS,replicate("~",12)),"~","")
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform