SQL Server Performance Forum – Threads Archive

TDBGRID(TADOTable) end View MS SQL

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

---

Any error and how about the DSN used to connect SQL server. Satya SKJ

---

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.

---

]]>