Please note that the resulting column width cannot be longer than 254 (maximum width of a character field). The statement should be:
#define n 254 && or a number smaller than 255 that meets your need
SELECT Padr(bb, n) as dd from a1 INTO CURSOR c1
> No matter in which version, using Transform() and Trim() for creating a column in a SQL command is problematic, or wrong, since the column width will be determined by the data width of first output record. Information will be lost if data in subsequent records are longer. You may consider rewriting your statement as:
> #define n 500 && or a number meets your need
> SELECT Padr(bb, n) as dd from a1 INTO CURSOR c1
Précédent
Suivant
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