Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Stored proc triggers read only error
Message
De
23/07/2008 15:01:54
 
 
À
23/07/2008 14:56:00
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Database:
Visual FoxPro
Divers
Thread ID:
01333481
Message ID:
01333518
Vues:
10
>Yes, I actually have defaults in the full DBC. However, my concern is that if someone INSERT INTO FROM MEMVAR or SET CARRY ON and APPEND BLANK. I don't want the old date. Also, I want the change date to be automatic when the records is changed. The unfortunate thing is that we do a bunch of things from the command line, such as update tables like this. I supposed I could/should make an update form that handles these bits, but I haven't had time.
>
>David
In this case what you can in your trigger for the insert and update is to check if the value is updated like.
IF ChangeDate<>DATE()
   =MessageBox("Please make sure....")
   return .f.
ENDIF
This way at least you might get the attention of someone that does an update/insert.
The form of course would be better.

Yelena
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform