Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Stored Procedures
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00254252
Message ID:
00254364
Vues:
23
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
Fil
Voir

Click here to load this message in the networking platform