Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Adding table validation rule
Message
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 9 SP1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01406956
Message ID:
01406992
Vues:
35
>>>Hi everybody,
>>>
>>>What would be the way to add a table validation rule and a trigger?
>>>
>>>Thanks.
>>
>>Create the function in separate PRG and check APPEND PROCEDURE and CREATE TRIGGER in Help :-)
>
>Doesn't work - I just tried
>
>TEXT TO lcProcedure NOSHOW
>       PROCEDURE delCustomersTrigger
>          INSERT INTO Customers_Tombstone(pk, dtDeleted) VALUES (CustomerPK, DATETIME())
>       ENDPROC   
>     ENDTEXT
>     
>     APPEND PROCEDURES FROM (STRTOFILE(lcProcedure,'temp.txt')) && Produced not a character expression.
>
>
>BTW, I could not find how to add TABLE validation rule.

Prepare a simple DB with all procedures you wan. Then use GENDBC and check what code it generates :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform