>I am giving following line to transfer the output in cursor
>
>select qty from delivery into cursor temp
>
>the problem is first few records of delivery are having 0 in qty field, so by default it is taking 1 as the length of qty field in cursor, which is causing "*" to be displayed in the next rows.
>
>Any suggestions ??
Firstly, this sysntax should work Ok. The problem you mentioned happens for command like:
Select qty AS quantity From delivery into Cursor temp
This case Foxpro really allocate field length by first record. To fix it, you should change command to:
Select qty+0000000 AS quantity From delivery into Cursor temp
Edward Pikman
Independent Consultant