Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement