Actually, I'd like to amend that a bit. IF you are using a database engine which supports update-able views, and your view meets the constraints the engine places on such views (like all fields present and a one-to-one relationship between the view and all the constituent tables, for example), then you *may* be able to accomplish it with one insert without using the trigger trick.
Now, whether Delphi 2010 supports that via its database components, I am not sure (I don't own 2010, so can't speak to it). However, it is a pointless exercise if your database engine doesn't support it.
Edit: Just as a sample, here are MySQL's restrictions on update-able views
Reply With Quote
Bookmarks