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:
01132072
Views:
20
>>
>>OK, try this:
>>
>>LOCAL lcOldPath
>>lcOldPath = SET([PATH])
>>SET PATH TO
>>WAIT WINDOW FILE([MyTable.DBF]) && Just to make sure you open table in m.DataFolder
>>TRY
>>   USE (m.DataFolder + "mytable") IN 0 ALIAS MYTABLE AGAIN SHARED
>>   INSERT INTO MyTable (MyField) VALUES ([ABC])
>>CATCH TO oExcpt
>>   MessageBox([Error happened ]+oExcpt.Message)
>>ENDTRY
>>USE IN MyTable
>>SET PATH TO (lcOldPath)
>>
>
>Your code works well when I call it from VFP. When I comment out the TRY CATCH ENDTRY and call it via the Ole Db, the table is not updated.

Is the DBC on the Network? Could it be rights issue?

Can you try a test with database on your local drive?
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