Hi Don,
I agree with Andy, that SQL Select doesn't change format of the columnms pulled directly from a table. Something else is affecting result. What if you run following code.
SELECT Transact
LIST STRU
SELECT ;
Account ;
FROM Transact ;
INTO CURSOR test NOFILTER
LIST STRU
BROWSE NOWAIT
Do you still see truncation?
Do you've SP1 installed?
BTW, you can use < pre > and < /pre > tags (w/o spaces) to preserve code formatting and make it more readable.
>Sorry about the confusion, I had copied the data set for testing instead of using the original. In the query I had renamed some of the elements. The naming is corrected below.
>
>I have run this over a dozen times checking all elements as described in the primary msg.
>I have confirmed that the query is selecting from the designated table each time, but is still truncating the third digit of the decimal value.
>
>A query ALWAYS brings in the Account column as N(10,2)
>The specified column is NOT undergoing any manipulations.
>Some of the records have values in the decimals at position 3.
>
>Source data looks like: 2300.001
>Result data looks like: 2300.00
>
>Query:
> SELECT ;
> Client, ;
> Account AS AcctNumb, ;
> SUM( Amount ) AS SubTotl ;
> FROM Transact ;
> WHERE Client = 1 ;
> AND BETWEEN( TranDate, {01/01/80}, DATE() ) ;
> AND TranCred > 0 ;
> GROUP BY Client, AcctNumb ;
> ORDER BY AcctNumb
--sb--