Hi Janet, Curt has given you a perfect solution, still if you are lazy you may try this: While creating the DataObject, you can add a comupted column myCC and the expression can be just ' '. If you use this name in your select statement, I mean, Select .., .. , .., (A+B*C) "myCC" ND is not likely to get upset. Regards, Aby > -----Original Message----- > From: Curt Springer [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, April 21, 1999 9:53 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: [ND] binding a Computed Column via the Wizard when > Overriding SQL > > Can you get the value out of the results set by column number? > > If so, then you could do things manually in onBeforeRowDisplayEvent: > -- get reference to results set (getLastResults) > -- get rowIndex from the event argument > -- use rowIndex and column position as arguments to get the value from the > results set > -- set value into field via setValue or setDisplayFieldValue > > -- Curt Springer, Team ND > > > At 09:28 PM 4/21/99 -0400, [EMAIL PROTECTED] wrote: > > > > > > > >We overrode the SQL in our DataObject to add a UNION; that worked fine. > Then we > >added a computed column (cc) to the SELECT statements. To make this cc > appear on > >our page, we have to "bind" it to a StaticText visual. But to do the > binding via > >the wizard we need to have the cc available in the "Data field" column. > Since > >we're overriding the SQL, the wizard won't show this cc is the available > "Data > >field" list. > > > >Does anyone know a way to do this binding via the wizard? If it's not > possible, > >can you tell me how to do this binding via code? > > > >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]
