DDT generated CRUD sproc question


Author
Message
Keith Chisarik
Keith Chisarik
StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)StrataFrame VIP (2.4K reputation)
Group: StrataFrame Users
Posts: 939, Visits: 40K
The DDT auto-generated sprocs, UPDATE specifically, expect all fields in the table to be passed as parameters and blow out if the BO's fill method that you call BO.save() against (causing an UPDATE) doesnt pull all the fields. I have some fields that I never want updated as they are only updated via triggers on the table itself defined on the SQL Server. Should I just override the definition of the SPROCS to not include these fields? or it is better to leave them and fill() all the fields even though they will never be updated or modified (which seems silly especially for a large table).

I see the collection of FieldstoExcludeFromUpdate on the BO's, I suspect these only work when NOT using CRUD sprocs, correct?

Still learning about using sprocs, appreciate the answers.

Keith Chisarik

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search