Open the local view, and go to "update criteria". The following conditions have to be met:
Under "field name", you have to check which fields you want to have updatable (under the pencil icon). Fields not marked as updatable will, simply, not be updated.
The key field or fields (key icon) has to be set correctly: you have to mark a field, or fields, that uniquely identify each record. Otherwise, you will change one record in the view, and update several records in the table!
On the bottom left is the "master switch", labelled "Send SQL Updates". Leaving this off will not send any updates, no matter what other options you have selected.
>I have the following code. But once I condcut a =requery(), nothing shows up in the table. When I look at the raw data, the records are not being updated.
>
>SELE v_FedEx &&This is a local view. the base table is FEDEX.dbf
>
>llsuccess = TABLEUPDATE(.T.)
>
>IF !llsuccess
> aerror(aSQLError)
> msg = "Data was not saved -- call a programmer"
> messagebox(msg, 0+16+0, "Data Update Failure")
> list memory like aSQLError noconsole to print
> =TABLEREVERT(.t., .t.)
> =REQUERY()
>ELSE
> brow && At this point, everything looks okay
> =REQUERY()
> brow && At this point, nothing appears in the local view of the table
>ENDIF
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
