Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2000 Server
Thanks - works great!
>>SELECT invno, IIF(usesr2,salesrep2,'') FROM invpost
>>
>>The above select returns only the first character of the salesrep2 field. I think that is because the usesr2 is a Logical field. How can I return the full length of the salesrep2 field?
>>
>>Randy Wessels
>
>Within a SELECT statement, you should only use fixed-length expression, for example, iif(usesr2, salesrep2, space(10)) (assuming 10 is the length of the field), or padr(iif(usesr2, salesrep2, ''), 10)
>
>Otherwise, in your example, the first record that VFP encounters might very well be a record that does NOT fulfill the iif()-condition, so VFP decides that 1 character is enough to accomodate the result.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement