Re: 4GL Dynamic "USING" format clause
Posted in 1995
Topics: Stored Procedures & SPL, Connectivity: ESQL/C, 4GL & Embedded SQL
In article <johnca-200495155628@47.201.1.65>, johnca@bnr.ca (John Campbell) wrote: > If I define a variable as a char value and assign it a valid format string > in > 4GL Version 4.00.UH2 it displays the correct result. > The following program gives an example of what I mean. > > Main > > Define a decimal > Define b char(25) > define c char(25) > > let a = 1.0 > let b = "-----&&" > > let c = a using b clipped > display "'",c clipped,"'" > > end main > > When run using Version 4.00.UH2 it displays as: ' 01' > In version 4.12.UE2 it displays as: '1.00' > > If anyone has any insight into this problem please feel free to respond. > > Thanks > > John Campbell > johnca@bnr.ca John, I have encountered a problem similar to yours. Its seems there is an Informix bug that has not been corrected in HP UX. Code the assignment statement this way: let c = (a using b) clipped This will give you the anticipated results Regards, Chris