Hi,
I was assuming that in creating a data object that joins multiple rows in
the same table, there would be some issue in being able to refer to
individual columns by a unique name. So, yes, it seemed that there would
be no ambiguity in using:
CSpValue getValue (int rowIndex, int dataFieldPosition)
since that would guarantee unambiguous references to fields joined from
different rows in the same table.
-- Curt, Team ND
No point. No click. No nonsense. :-)
At 06:37 PM 5/21/99 -0400, [EMAIL PROTECTED] wrote:
>
>
>
>Thanks Curt, are you saying use one complex DO with manual binding?
>
>Hmnn, I can barely code without my point & click! I'm looking thru the
help and
>forum archives (tech notes are such a bother assuming we still need a pwd to
>access them!) is this how you'd access the values via position....from the
>Javadoc:
>
> Example:
>CSpSelect dobGetOrders = (CSpSelect) CSpider.getDataObject ("dobGetOrders");
>
>dobGetOrders.execute ();
>if (dobGetOrders.succeeded())
>{
> int numOfRows = dobGetOrders.getNumOfRows ();
> for (int i = 0; i < numOfRows; i++)
> {
> CSpValue currOrderId = dobGetOrders.getValue (i, "dtfOrderId");
> : : : :
> }
>}
>
>or do you like something better about this getValue method:
> CSpValue getValue (int rowIndex, int dataFieldPosition)
>
>Thanks,
>Spoiled P&C Jan!
>
>
>
>
> (Embedded
> image moved Curt Springer <[EMAIL PROTECTED]>
> to file: 05/21/99 05:48 PM
> pic01731.pcx)
>
>
>
>
>To: [EMAIL PROTECTED]
>cc: [EMAIL PROTECTED] (bcc: Janet
> Traub/IS/SSC/THD)
>Subject: Re: [ND] manually binding Data fields
>
>
>
>
>I'd vote for option #1, with manual binding, and I would access the values
>by position rather than by name.
>
>That is, if I ever wrote code at the application level that touched a data
>object, which I don't! :-)
>
>-- Curt, Team ND
>
>At 05:17 PM 5/21/99 -0400, [EMAIL PROTECTED] wrote:
>>
>>
>>
>>My question in a nutshell:
>>What's better...3 simpler DOs with point & click binding. vs. 1 complex
>DO with
>>manual binding?
>>
>>Cracking it open:
>>I have a page that displays a Repeated. 3 columns in the repeated have the
>same
>>domain. Therefore, the SQL for the Rpt requires joining to the same table
>three
>>times. To pick the same table more than once in the FROM clause, I
believe I
>>have to use the SQL tab in the Properties dialog and override the default
>SQL.
>>No problem, but then how can I bind the 3 columns to the corresponding
>display
>>fields in the Repeated? i.e. how do I access the 3 columns via code to use
>them
>>to do a setValue?
>>
>>Maybe the better way is to create 3DOs (each one does one join to the common
>>table) via point & click, and then bind their data field to the
corresponding
>>display field on the Rpt.
>>
>>Advice from a performance perspective is also welcome.
>>
>>Thanks!
>>Janet
>>
>>
>>_________________________________________________________________________
>>
>>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]
