tag:blogger.com,1999:blog-8449039.post2226815693203874984..comments2024-03-28T05:59:36.577-04:00Comments on Scott Spendolini's Blog: A Better MethodScotthttp://www.blogger.com/profile/01187435106015051061noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-8449039.post-12116775686957833262010-11-15T18:47:41.402-05:002010-11-15T18:47:41.402-05:00Ino,
If you pass all parameters back to the API, ...Ino,<br /><br />If you pass all parameters back to the API, then they should all be updated. If you NULL some of all of them out, well, then your data will also reflect that.<br /><br />Keep in mind that the example that I used is just one example; you could likely build an API generator that is more robust and suits your specific needs in no time at all.<br /><br />I am not a huge fan of Instead of Triggers, as there is no way to rollback anything, should something fail. For example: how would you handle lost update detection?<br /><br />Thanks,<br /><br />- Scott -Scotthttps://www.blogger.com/profile/01187435106015051061noreply@blogger.comtag:blogger.com,1999:blog-8449039.post-25957421121464445662010-11-15T12:36:31.751-05:002010-11-15T12:36:31.751-05:00Scott
I saw your ODTUG webcast about this subject...Scott<br /><br />I saw your ODTUG webcast about this subject, and tried it out myself. I think that this API is really too simple to use. E.g. for an update it doesn't take into account the columns you actually want to change, so the others may turn up as NULL after the update.<br /><br />Also, the API cannot (easily) be used in a tabular form. <br /><br />One of the suggestions in the webinar was to use views with instead of triggers. That could be a better solution.<br /><br />InoInohttps://www.blogger.com/profile/05100729748140066283noreply@blogger.comtag:blogger.com,1999:blog-8449039.post-26445045024601725272010-09-16T06:20:00.305-04:002010-09-16T06:20:00.305-04:00I stand corrected.
Thanks, Joel.
- Scott -I stand corrected.<br /><br />Thanks, Joel.<br /><br />- Scott -Scotthttps://www.blogger.com/profile/01187435106015051061noreply@blogger.comtag:blogger.com,1999:blog-8449039.post-12010146903782184992010-09-16T04:27:34.240-04:002010-09-16T04:27:34.240-04:00>> I do remember now that this feature was b...>> I do remember now that this feature was built WITH Dan's TapiGen APIs. Dan - if you're watching - can you confirm?<br /><br />Really? That's odd. The date on Dan's code is 2008, the APEX TABLE API generator was written in February 2003. And the code between them is completely dissimilar. Dan's is way more sophisticated.<br /><br />Sorry, but I don't think that statement is accurate at all.Joel R. Kallmanhttps://www.blogger.com/profile/01915290758512999160noreply@blogger.comtag:blogger.com,1999:blog-8449039.post-30803901831066519052010-09-15T09:28:49.724-04:002010-09-15T09:28:49.724-04:00I do remember now that this feature was built WITH...I do remember now that this feature was built WITH Dan's TapiGen APIs. Dan - if you're watching - can you confirm?<br /><br />- Scott -Scotthttps://www.blogger.com/profile/01187435106015051061noreply@blogger.comtag:blogger.com,1999:blog-8449039.post-85179370305645042010-09-14T12:22:41.574-04:002010-09-14T12:22:41.574-04:00Thanks for the tip Scott I have had questions fro...Thanks for the tip Scott I have had questions from people on this type of setup for some time, and no really good answers. Now this one bears a little experimentation. :")Jason D. Aughenbaughhttps://www.blogger.com/profile/01450406075284825577noreply@blogger.comtag:blogger.com,1999:blog-8449039.post-89126474795076343232010-09-14T09:05:16.943-04:002010-09-14T09:05:16.943-04:00also forgot his source code website too..
http://s...also forgot his source code website too..<br />http://sourceforge.net/projects/tapigen/Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8449039.post-60909568171932207982010-09-14T09:03:14.488-04:002010-09-14T09:03:14.488-04:00Also someone did a long time ago but never...
http...Also someone did a long time ago but never...<br />http://www.danielmcghan.us/2008/07/tapigen-demo-app.htmlAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8449039.post-69638843164659178112010-09-14T02:31:44.686-04:002010-09-14T02:31:44.686-04:00Maybe you could check out the QDA (Quest Developme...Maybe you could check out the QDA (Quest Development Architecture) available in QCGU (Quest CodeGen Utility) at http://codegen.inside.quest.com/index.jspaPatrick Barelhttp://blog.bar-solutions.comnoreply@blogger.com