Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stored Procedures
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00254252
Message ID:
00254364
Views:
22
Hi Jim,

Thank you for your help.

I've simplified my problem by removing the view entirely. Now I'm doing everything directly with the table that resides in bfnvfp. However, I tried what you suggested and I still get the error "cannot update the cursor". I'm sure it's my approach. Here's what I do.

close all
clear all
open data bfnvfp shared
use ccoffer shared
=cursorsetprop("buffering",5)
browse && change any field other than lastupdate
? tableupdate(.t.,.t.)

The table ccoffer has an update trigger called DateInitials( "CCOffer" ). The DateInitials is in the SP of the bfnvfp DBC. The code is:

*
* AUTHOR: Benjamin P. Burnham
* CREATED: Aug 16, 1999
* PURPOSE: save the datetime and userid to the specified table
*
PROCEDURE DateInitials
LPARAMETERS m.tcTable

wait window m.tcTable && confirm that this code actually runs

REPLACE LastUpdate WITH DATETIME() IN m.tcTable

RETURN

Maybe by issuing the REPLACE command during a TABLEUPDATE causes the table to get confused but I'd think there would be need for such a simple operation. It's important that the LastUpdate field only get changed when the TABLEUPDATE command is fired.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform