SQL Server Performance

TDBGRID(TADOTable) end View MS SQL

Discussion in 'General DBA Questions' started by Cristian76, Dec 17, 2002.

  1. Cristian76 New Member

    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
  2. satya Moderator

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

    Satya SKJ
  3. Chappy New Member

    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.

Share This Page