Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to pass 2 SQL commands
Message
From
20/03/2003 12:58:49
Fabio Lunardon
Lunacom
Marostica, Italy
 
 
To
20/03/2003 12:00:15
Esparta Palma
PortalFox
Acapulco, Mexico
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: How to pass 2 SQL commands
Miscellaneous
Thread ID:
00764600
Message ID:
00768193
Views:
27
Hi Esparta,

VFP execute local build of cursor!

On VFP
Simple examples:

BEGIN TRAN; SELECT .... -- ok

IF ..... SELECT .... -- ok

SET ... ; SELECT ... -- ok

DECLARE @X INT; SET @X=1; select @X -- NONE CURSOR IS BUILD

UPDATE/INSERT/DELETE ... ; SELECT @@IDENTITY -- NONE CURSOR IS BUILD

-- BATCH MODE =.T.

DECLARE @X INT; SELECT @@IDENTITY X; SET @X=1; SELECT @@IDENTITY Y
-- 1 CURSOR AND 1 ERROR

Fabio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform