Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select field width restricted
Message
De
22/04/2003 15:21:46
 
 
À
22/04/2003 15:17:46
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00780295
Message ID:
00780298
Vues:
13
i do not see this behavior (running Vfp6.0 Sp5), comes up just the way it is supposed to be. the cursor contains the fields with a length equal to the source table.

>Frequently I find that my select statements have truncated the length of a field.
>
>For instance, I may have a table with a field customer.fname
>
>and it will have "first name" records such as:
>BO
>GREG
>TIMOTHY
>
>Note the first record is only 2 characters long.
>
>IF I
>
Select * from customer into cursor ccustomer
>
>My cursor will contain records like:
>BO
>GR
>TI
>
>Because the first record defined the length for the entire table.
>
>I work around this by using:
>
Select padr(fname,20,' ') as f_name  from customer into cursor ccustomer
>
>but this becomes really tedious, not being able to use the wildcard * and having to refer back to the field lengths, especailly for tables with lots of fields. Is there a better way?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform