>>>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'))
>
>
>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.