Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
C/S Newbie Q: Sending Batch of Statements
Message
From
03/05/2000 12:46:54
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
C/S Newbie Q: Sending Batch of Statements
Miscellaneous
Thread ID:
00365636
Message ID:
00365636
Views:
62
Please excuse the C/S newbie Q but how do I send all of this below from VFP to SQL Server. Is there a way to make it all go through one SQLEXEC command? I'm familiar only with using SQLEXEC to send one commnand at a time.

IF EXISTS (SELECT * FROM sysobjects WHERE name='cust' and type='U')
DROP TABLE cust
go

CREATE TABLE dbo.Cust ( cust char (8) NOT NULL ,
baname char (10) NULL ,
custdesc char (35) NULL ,
subref char (3) NULL ,
respdept char (5) NULL )
go
Next
Reply
Map
View

Click here to load this message in the networking platform