Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdapter refresh from stored procedure
Message
From
25/04/2005 06:33:34
 
 
To
23/04/2005 04:04:09
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01007506
Message ID:
01007994
Views:
11
Hi Aleksey,

Thank you very much for your enlightments !


>However, there are other ways to refresh field(s) during TABLEUPDATE:
1. You can bind fields to output parameters and/or to the result of stored procedure (an example is below).

This seems to be a very fine way to do it. Unfortunately, I could not make it work yet because I am working with a VFP back-end and I didn't find the syntax with which I could bind a VFP variable to the result of the stored procedure. Up to now, I have always retrieved that result by using the call syntax "EXEC #test_ins_2()" and analyzing the returned RecordSet. The syntax "EXEC ?@test.f1 = #test_ins_2" doesn't seem to be the right one against a VFP database. Do you know which one I should use ?

I also thought about the other methods you gave, but if that one worked with a VFP database it would be my preferred.

Greetings,

David
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform