Dynamic column type

[IBT from Office <adclay@IBT.COM.AU>]

 

In regards to this query back in May; did/has anyone managed to get a variable to dynamically assign NUMBER or CHAR to the dynamic column definition?

ie:    let $ctype = 'NUMBER'

 

 

begin-select

[$A1]       &A1=$ctype

.......

 

We cant get a clean compile using $ctype this way.

 

TIA

 

 

Adrian Clayfield

• Subject: Re: Dynamic SQL Headscratcher
• From: Steve Bollinger <c_sbolli@QUALCOMM.COM>
• Date: Wed, 20 May 1998 09:15:36 -0700

Have you tried a variable as coltype? ie. let $ctype = 'char' or 'number'at the
time you define $scope1.  then[$SCOPE1]       &SCOPE1=$ctype ...................

Steve Bollinger

 

 

At 08:43 AM 5/20/98 -0600, you wrote:>I'm working
on a report that allows the users to include three of ten (orso) columns as an
option (ie: they can pick 1, 2, or 3 columns to includein the std report.)>
>To further complicate the issue, these columns can be numeric or character
type.>>The following code works (but only when they have all three columns
selected and when all three are of numeric type):>>...>avg_total_cash
>[$SCOPE1]       &SCOPE1=NUMBER>[$SCOPE2]       &SCOPE2=NUMBER
>[$SCOPE3]       &SCOPE3=NUMBER>  do PRINT_DETAIL>  from ....>
>Any ideas on how to accomplish this?>>The only thing I've been able to
think of is having one programdynamically write another program based on the
user preferences....>>Thanks.>Salim.

 

 

 

 

 

 

========================================================================
Integrated Business Technologies Pty Ltd
Level 11   55 Hunter St Sydney  2000
Mobile: 0413 115580    Fax: 61 2 9223 4384
Email:  adclay@ibt.com.au
========================================================================