>I have a DBC with VFP tables. I have another DBC with nothing but views that look at the DBC of VFP tables. I would like to place a few update triggers in the VFP DBC. For example a datetime field once a record is updated. I placed the following call in the table's update trigger:
>
>=GetDate( "CCOffer" )
>
>and the following code in the SP of the VFP DBC:
>
>PROCEDURE GetDate
>LPARAMETERS m.tcTable
>
>REPLACE LastUpdate WITH DATETIME()
>
>RETURN
>
>I run the following in the command window:
>
>close all
>clear all
>open data bfnvfp shared
>open data bfnview shared
>use vccoffer_keyno && this is a view
>? cursorsetprop( "Buffering",5 )
>browse && change a field value
>? tableupdate(.t.,.t.)
>
>I get the error Cannot update the cursor when I attempt the tableupdate.
>
>Any ideas?

You have to use the record validation rule. You cannot update the table within the triggers.