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]
pic01731.pcx