Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding table validation rule
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01406956
Message ID:
01406992
Views:
36
>>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform