Update Table

[KingSlick]

Hi,

I have created a form that reads in the memo fields of a VFP table so that it may be updated. I compile/build the project that contains the form into an .exe file, and run the exe. The exe loads, however, when I try to update the table I get the following error...

Cannot update the cursor TEMP_DATA_FILE, since it is read-only.

TEMP_DATA_FILE is the name of the table that I am trying to update. I am using "REPLACE" on the table to update. I have included exclusive when using the table.

USE temp_data_file EXCLUSIVE

Then on the "click" procedure I have ...

lcTitle = ALLTRIM(thisform.edit1.Value)
lcMemo = ALLTRIM(thisform.edit2.Value)

REPLACE title WITH lcTitle
REPLACE abstract WITH lcMemo

SKIP
lcTitle = ALLTRIM(temp_data_file.title)
lcMemo = ALLTRIM(temp_data_file.abstract)
thisform.edit1.value = lcTitle
thisform.edit2.value = lcMemo

How can I get this to update just by using the "command1" button?

Thanks in advance
-Scott

 

[jimstarr]

Hi Scott,

Tables that are included in an exe can not be updated at run time. Perhaps you need to exclude the table when you build the exe.


Jim

 

[KingSlick]

Thanks very much.

That is working great!!!

 

[Olaf Doschke]

Use the controlsource property of the editboxes and set them to the memo fields, then you don't need to replace the memo field contents.

Bye, Olaf.