H
Håvard Danielsen
Guest
You do not need to use a logic procedure to add a temp-table. You define a temp-table in the SDO in the same dialog that you added the buffer. This is also documented in the Dynamics documentation. See "Building SmartDataObjects against temp-tables" in the "Building Advanced Business Logic" section. -- The difficult part is to figure out where and how to populate the temp-table. This may vary depending on the requirements as well as the environment. The documentation shows this in the main block, which only makes sense with very static data. I do not remember much about the SDO temp-table support, but I would probably try to override the openQuery function and add the code to create the temp-table record before the call to super. You should also make sure you empty the temp-table before you populate it. When you override an SDO procedure or function you should pay attention to the DB-Required flag, which is settable in the Add Function/Procedure wizards and the drop down menu in the Outline View in PDS and as a check-box in the section editor in the standalone AppBuilder. In this case you want this to be checked to make sure this logic is only executed on the server side. Do this even if you do not run on an Appserver just in case there is "client side" logic that calls openQuery to open the client Rowobject query.
Continue reading...
Continue reading...