Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create Table from DBC info
Message
From
02/02/2004 20:50:57
 
 
To
02/02/2004 20:21:27
Joel Hokanson
Services Integration Group
Bellaire, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00873217
Message ID:
00873223
Views:
17
Is roll-your-own an option?
LPARAMETERS cExtendedStru,cOutFile
lcCreateCmd = []

SELECT (cExtendedStru)
SCAN
	IF EMPTY(lcCreateCmd)
		lcCreateCmd = lcCreateCmd + [Create Table ] + cOutFile + [ (]
	ELSE
		lcCreateCmd = lcCreateCmd + ','
	ENDIF 
	lcCreateCmd = lcCreateCmd + ALLTRIM(Field_Name) + [ ] + ;
		Field_Type + [(] + TRANSFORM(Field_Len) + IIF(Field_Dec>0,TRANSFORM(Field_Dec),'') + [)]
ENDSCAN 
lcCreateCmd = lcCreateCmd + [)]
WAIT WINDOW lcCreateCmd
&lcCreateCmd
Aloha,

James
>Can I create a VFP table from the information in the DBC about that table?
>
>
>If I have the Structure extended in a table I can Create table2 from table1 &&table1 being the strru extended, but I can not make this work with long field names like in a dbc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform