Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stored Procedures
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Stored Procedures
Miscellaneous
Thread ID:
00254252
Message ID:
00254252
Views:
53
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
Map
View

Click here to load this message in the networking platform