Hello Everyone, Please note that i've encountered the following problem: I'm currently using MS SQL 2000 and Delphi 7. Could you let me know why, while using database whit TDBGrid(whit TADOTable.table := View1), when I insert a new record the trigger of the View(on Database) is not executed, where as through TADOCommand i can execute the command SQL INSERT on the same View the trigger is executed? Please let me know [:0]how i should solve this problem. thanks
Some of the delphi components (particularly the data aware ones) are remarkably shoddy once you look under the hood. I recommend you run a trace and see what actual SQL is being executed, when using the table based on the view. If this doesnt shed any light, I would then attempt to trap the creation of the new record via an event handler, and perform the insertion yourself using an ADOCommand.