>>>What is DataFolder?
>>>variable or hardcoded path to Data?
>>
>>It is a variable and I test it within the SP which points to the right folder. In fact, I can read the values from the tables all right. So the table must be opening in the right folder. The problem is that no values are not being written to the table and no new records are inserted. And no error message. Although error message is a moot point since it is hard to trap error in a stored procedure.
>
>OK, try this:
>
>LOCAL lcOldPath
>lcOldPath = SET([PATH])
>SET PATH TO
>WAIT WINDOW FILE([MyTable.DBF])
>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)
>
Unfortunately you cannot use TRY/CATCH/ENDTRY in VFP Stored Procedure.
Thank you for your suggestion and code.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
