Okay, this is what I suspected. However, I am still unclear on the wording of your
reply.
Are you saying that I use one object that has references to two DO's for select/
update functionality. If so could you clarify as to what object this would be.
Or are you saying that I use two dataobjects for the page?
Thanks a lot,
Bryant Brabson
Curt Springer <[EMAIL PROTECTED]> wrote:
>Unfortunately, you can't update against a multi-table MultiSQL DO, only
>against a single-table one.
>
>We get around this with an object that has a reference to a multi-table DO
>(either CSpSelect or CSpMultiSQL, which extends CSpSelect) that is used for
>'select' only, and, for each table in the join, a single-table CSpMultiSQL
>DO for insert,update,delete. We send 'select' or 'update' to the object.
>In the case of 'update', it tracks status and value changes to the contents
>since the 'select', and then sends 'insert', 'update' or 'delete' (or
>nothing) to the CSpMultiSQL DO(s), as needed. There is also a provision
>for temporary/computed values, a buffer that does not map to a table (or DO).
>
>-- Curt Springer, Team ND
>
>
>At 09:49 AM 6/18/99 -0800, [EMAIL PROTECTED] wrote:
>>First off, please bear with me if my terminology is a little off-
>>I just inherited the NetDynamics responsibilities around here
>>recently!
>>I have a MultiSQL data object that I have modified to use
>>computed columns via using the whole override SQL option.
>>I have done this as I needed to do a join between 2 tables and then sort
>the results based on one of the computed columns.
>>This page has an update feature based on the value of a checkbox.
>>Now that I have added the computed columns, update doesn't work.
>>I remember hearing about this somewhere, and am wondering if I can make
>this work or if I need to pursue a different strategy. Also, is there
>anyway to construct a MultiSQL do that uses 2 tables?
>>
>>Thanks,
>>Bryant Brabson
>>_________________________________________________________________________
>>
>>For help in using, subscribing, and unsubscribing to the discussion
>>forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
>>
>>For dire need help, email: [EMAIL PROTECTED]
>>
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
