Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with select to cursor
Message
From
15/05/1997 11:21:51
 
 
To
15/05/1997 11:17:05
Vinod Parwani
United Creations L.L.C.
Ad-Dulayl, Jordan
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00032428
Message ID:
00032433
Views:
34
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform