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]
