I'll defer to somebody who really knows, but if sybase lets you
insert/update a view (somehow I remember that it doesn't, but it's been a
long time since I messed with sybase), probably ND does, too. I think ND's
multisql hangup is when the multisql covers more than one db object, from
ND's point of view. Just guessing that ND data objects don't really know
which columns go with which table buffers.
-- Curt Springer, Team ND
At 02:07 PM 6/21/99 -0700, Levine, Peter wrote:
>Hi,
>
>What if the MultiSQL object is actually a view (I'm using SYBASE, and views
>are DB constructions that effectively combine tables.)
>
>
>Peter
>
>
>-----Original Message-----
>From: Curt Springer [mailto:[EMAIL PROTECTED]]
>Sent: Friday, June 18, 1999 1:42 PM
>To: [EMAIL PROTECTED]
>Subject: Re: [ND] MultiSQL and computed columns
>
>
>However you do it, for a multi-table join you will need one data object for
>the select, and one data object per table for insert, update, delete.
>
>My pages don't know what data objects are. They get a reference to a an
>object called a RowContainer, which contains Row objects.
>
>The page calls getRows() on the RowContainer to get rows, which might be
>existing rows or to-be-inserted rows created on another page in the same
>session, or getNewRow() to initialize a new row. If the RowContainer is
>empty, it will retrieve table rows and build Row objects, but this is
>transparent to the page.
>
>The page calls setValue, getValue on the Row to set/get column values. It
>can test row status via isNew(), isAltered(), isDeleted(). The page calls
>update() on one Row or on the RowContainer, which passes the update to all
>Rows. A Row can include rows from different tables. The delete() command
>ahead of the update() will cause the Row to be deleted on update. Each
>table row in a Row is evaluated separately. In the case of an outer join,
>you might start with a row from table A, and nothing from table B, and an
>update to the Row might cause an update to table A and an insert to table B.
>
>
>Under the hood, it is what I said in the first sentence above, in most
>cases.
>
>-- Curt Springer, Team ND
>
>At 01:03 PM 6/18/99 -0800, [EMAIL PROTECTED] wrote:
>>
>>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]
>>
>_________________________________________________________________________
>
>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]
