Oops. ND doesn't even care about the fieldnames when you override the SQL.
It just goes by the order of the fields. Which means if you change the order
of the fields in Select, you get junk!
> -----Original Message-----
> From: Mathew, Aby [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, April 22, 1999 12:20 PM
> To: '[EMAIL PROTECTED]';
> [EMAIL PROTECTED]
> Subject: Re: [ND] binding a Computed Column via the Wizard when
> Overriding SQL
>
> 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
>
>
_________________________________________________________________________
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]
