Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
PADR problem
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01289966
Message ID:
01289967
Views:
13
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform