I made the typing error here, in my message. There is no error in the SP because I have code before and after the APPEND BLANK and those lines work.

I just did another test where I tried to REPLACE a value in a field with some dummy value and then get the value in the field immediately after the REPLACE. And the value in the field is still old value. As if something prevents the fields to be updated and records to be added to my application tables. Note that I test the code by creating "dummy" test.dbf table and inserting records into this table in certain places of my code. And the dummy test.dbf gets all the new records and all values.

>Do 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.
>>
>>>Any errors? Could you post your code?
>>>
>>>
>>>
>>>
>>>>I am having problem where the VFP Stored Procedure (called from .NET application) does not update .DBF tables. I inserted a test code in the Stored Procedure that creates a TEST table and inserts dummy value, and that part works. But none of the application tables are updated.
>>>>
>>>>The version of VFP Ole DB driver used for .NET application to call store procedure is 9.0.00.3504.
>>>>
>>>>I have been running all kind of tests but to no avail.
>>>>
>>>>Any suggestions of what I can do to pinpoint the cause of the problem?
>>>>
>>>>Any suggestions would be appreciated.