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