General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Table locked when memo field is modified
Create a simple form add a edit box make sure the control source is blank.
In the INIT of the form type
BEGIN TRANSACTION
Add a table with a memofield in data environment.
Set buffermodeoverride to 5 for the cursor in the data environment
Place a cmd button(replace) and in click event type:-
REPLACE table.memofield WITH thisform.edtreplace.value
You may add an exit cmd button.
Do the form within your foxpro environment(vfp 5 or 6). When the form loads click on the replace cmd button.
Load another foxpro environment(2nd vfp application) do the form in this new enviroment and voila you get the message "record not available" scrolling on the status bar.
My question is why does this happen only with memo fields and not other fields.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only