General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>VFP keeps track of what are new and what are current records (to decide whether to INSERT or UPDATE) with the Fieldstate of the view. When checking GETFLDSTATE-1) on oyur view before tableupdating, does it show 2s or 4s?
I changed one field in a visible record and GetFldState says:
34444444444444444443
Then I click my button to fire the tableupdate() and VFP does not complain that the record didn't get updated. But it definitely didn't happen.
In the view designer. Update criteria on the remote view of VFP table is "send sql updates" and all fields are checked under the pencil and the primary key has a check under it. SQL Where clause includes "Key Fields Only". Update using "SQL Update".
In the table designer. Table has a primary index.
In the form designer. Form's data properity buffermode=2(optimistic). Private data session.
In the data environment, only the view is present (ie underlying VFP table is not in there). BufferModeOverride=5. Readonly is .f.
In click event of my favorite button, there is:
select CustUpdate
tableupdate(1,.t.,alias())
*use FarDBC1!CustUpdate nodata
*ThisForm.Refresh
Previous
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