Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with select to cursor
Message
De
15/05/1997 11:21:51
 
 
À
15/05/1997 11:17:05
Vinod Parwani
United Creations L.L.C.
Ad-Dulayl, Jordanie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00032428
Message ID:
00032433
Vues:
36
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform