For adding records, I sometimes have the following problem: adding a record with Ctrl-Y will create an empty, and therefore invalid, record. This may be due to a rule that says, field x should not be empty. Or perhaps, referential integrity. With the command "View | Append mode", validation will be postponed until you have the opportunity to add valid data.
For the delete case, you have to check why the trigger fails. There may be corresponding data in other tables, for example - in other words, referential integrity. Or, the auditing function itself may fail. To find out what is going on, try to disable the auditing function, to see if this is it.
To debug the auditing function, or an RI-function, or any other trigger function, you can (temporarily) put SET STEP ON as one of the first commands, in the stored procedure.
HTH,
Hilmar.
>Hi All,
>i am using trigger for IUD for auditing ( meanwhile for the myaudit() codes many thanks to Hillmar... ) in my tables. at desing time for eg. in browse screen ctrl+y or ctrl+y gives error , or in command windows delete vs codes i cannot execute . is there any solution to use this feature without delete IUD triggger codes from table for execute these commands ?
>
>TIA
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)