General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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?
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