StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » DDT generated CRUD sproc question

DDT generated CRUD sproc question

Keith Chisarik — Fri, 06 Jun 2008 08:40:15 GMT

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.

RE: DDT generated CRUD sproc question

Keith Chisarik — Fri, 06 Jun 2008 08:40:15 GMT

That is what I thought I just wanted confirmation that it was "ok" since I hadnt run across it before.

Thanks

RE: DDT generated CRUD sproc question

Trent L. Taylor — Fri, 06 Jun 2008 08:34:19 GMT

In this case you may want to copy over the sproc that was generated for you, make the changes and then deploy that sproc. Then, use the FieldsToExcludeFromUpdate so that the BO doesn't send those fields over when updating. That might be what you are wanting to do if I understand you correctly.

RE: DDT generated CRUD sproc question

Ivan George Borges — Thu, 05 Jun 2008 14:38:51 GMT

Hey Keith!

This one might help you:

http://forum.strataframe.net/FindPost7234.aspx