RE: [sqr-users] Dynamic sql field problem on UNIX server

["Bambach, Tom" <TBambach@genchemcorp.com>]

Don,

Thanks - Neither removing the spaces or moving the dynamic field so it
was not last on the list worked, but Thai's suggestion of removing the
join with PS_VENDOR and calling a procedure to get that data (where
that new procedure had the [$wthdx]... dynamic field logic) worked.

Tom

> -----Original Message-----
> From: Don Mellen [SMTP:donm@ontko.com]
> Sent: Wednesday, November 13, 2002 10:30 AM
> To:   sqr-users@sqrug.org
> Subject:      RE: [sqr-users] Dynamic sql field problem on UNIX server
> 
> On Wed, 13 Nov 2002, Bambach, Tom wrote:
>  ...
> > This program is substituting for a field name in the select list and
> works
> > fine on the client but bombs on the (UNIX) server;  I also have other
> > programs that substitute for a field name that work on both the client
> > and UNIX server, so I don't understand why this program is having a
> > problem.
>  ...
> > > > if $db_name <> 'EPPROD'
> > > >  let $wthdx = 'V1.WTHD_SW '
> > > > else
> > > >  let $wthdx = 'V1.M1099_SW '
> > > > end-if
>  ...
> 
> Just a couple of random thoughts....
> 
> Have you tried getting rid of the spaces at the end of the strings you're
> defining?
> 
> Have you tried moving the dynamic in the select so the last selected 
> column is "real" instead of dynamic?
> 
> HTH,
> -----------------------------------------------------------------------
> Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
> donm@ontko.com |  "In the beginning, there was nothing, which exploded"
> 
> 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users