Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Return error execute method ADO connection
Message
From
24/05/2006 12:32:50
Ariel Müller
Müller & Asociados S.R.L.
Córdoba, Argentina
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Network:
Windows NT
Database:
MS SQL Server
Miscellaneous
Thread ID:
01124532
Message ID:
01124564
Views:
10
ADO collection errors

For example, my procedure is as follows:
CREATE PROCEDURE dbo.mystoredprocedure
WITH ENCRYPTION
AS
  sentences...

  IF <condition>
       RAISERROR (message, 16, 1)
And the ADO code is as follows:
oConnection = createobject("adodb.connection")
oConnection.open(cStringConnection)
oConnection.isolationlevel = ADXACTSERIALIZABLE

oConnection.BeginTrans

cStoreProc = "mystoredprocedure"
oConnection.execute(cStoreProc)

if alen(oConnection.Errors) > 0
   for each oError in oConnection.Errors
       ...Error handle
   endfor
   oConnection.RollbackTrans
else
   oConnection.CommitTrans
endif
Previous
Reply
Map
View

Click here to load this message in the networking platform