Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem updating tables from Stored Procedure
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01132012
Message ID:
01132020
Views:
17
Did you post just a sample? Because here you have a typo in USE command.

Could it be that your SP produces an error, which is not shown? Are you sure your SP has full rights? You may need to add SHARED keyword in USE command, since you may not know all environment settings.

>No error message. The code in Stored Procedure is very simple:
>
>
>user ("DataFolder" + "mytable") in 0 alias MYTABLE
>append blank in MYTABLE
>replace myfield with "ABC" in MYTABLE
>
>
>But no record gets inserted to the MYTABLE.
>
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform