I have a SELECT SQL statement as follows:

vTempStr="sku as fSkuOur,desc as fDesc,price as fPrice,vend_id as fSkuVend,"+ ;
           "qty as fQtyIn,recno() as fRecno,'' as fPrnQty,price as fPrnPrice "+ ;
           "from product into cursor cTemp "
select &vTempStr

Everything appears to be working fine except for something I stumbled on by accident today....

The PRODUCT.QTY field is a numeric

the CTEMP.FQTYIN field is being set as character length 1

Not sure why or how this is happening, and in most cases it is working fine EXCEPT when I have qty amounts larger than 9 (1 single digit)... then of course the extra digits are being dropped.

I need to figure out why, and how to correct it... I need those larger figures.