Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Automatically generating a 'create table' command
Message
From
21/10/2004 11:01:42
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00953298
Message ID:
00953319
Views:
16
Here is a sample
IF NOT FILE("scaleMessages.dbf")

	CREATE dbf scaleMessages ( ;
	  msgcode c(40),  ;
	  msg c(254), ;
	  action n(1,0), ;
	  scrnmsg n(1,0), ;
	  tickmsg n(1,0), ;
	  applyshipm n(1,0), ;
	  shownow L(1), ;
	  timelogged t(8), ;
	  ticket i(4), ;
	  source c(3), ;
	  truckno c(5) ;
	)
	USE IN scaleMessages 

ENDIF 
>Thanks, but I was hoping to start building the tables programmatically rather than have one living. We distribute this application and I need to create this table on each work station.
Previous
Reply
Map
View

Click here to load this message in the networking platform