Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
PADR problem
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Divers
Thread ID:
01289966
Message ID:
01289967
Vues:
14
Can you explain what exactly is strange about result? How do you display it? Are none-prportional fonts involved?

What
SELECT LEN(ALLTRIM(BlockDetails)) FROM ResultCursor
returns for each row?

>Hi all, when I run the query shown below I get a strange result set ( I expect the rows to be all 50 chars long )
>
>
>Select PADR(allt(Mytable.blkd_desc),50,'*');
>As BlockDetails;
>From Multiblk;
>Inner Join Blockpay;
>On Multiblk.block = BlockPay.block
>
>
>The results I get are similar to the ones shown below
>
>
>My first record***********************************
>Second***************************************
>Third********************************************
>And so on*********************************
>
>anyone know what gives here ?
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform