Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Run After Delete Trigger from VFP without deleting the r
Message
From
06/01/2007 15:30:10
Dorin Vasilescu
ALL Trans Romania
Arad, Romania
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Re: Run After Delete Trigger from VFP without deleting the r
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
Firebird
Miscellaneous
Thread ID:
01181049
Message ID:
01183181
Views:
26
This message has been marked as a message which has helped to the initial question of the thread.
Hi
This should work

lnRetVal = SQLEXEC(lnCon, "EXECUTE PROCEDURE DelUStock(?liID)", "crs_result")
lnSPRetVal1 = crs_result.SPRetVal1

* or, this work for sure
lnRetVal = SQLEXEC(lnCon, "select SPRetVal1 from DelUStock(?liID)", "crs_result")
lnSPRetVal1 = crs_result.SPRetVal1


I assume that SPRetVal1 is the return parameter in procedure DelUStock
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform