Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select field size
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Select field size
Miscellaneous
Thread ID:
00804853
Message ID:
00804853
Views:
50
Why won't the results of:
SELECT ALLTRIM(send_lname AS Lastname ;
	FROM pocontact ;
	INTO ARRAY aHold ;
	WHERE memoid=6 ;
	ORDER BY send_lname
OR
SELECT PADR(send_lname,LEN(ALLTRIM(send_lname))," ") as lastname ;
	FROM pocontact ;
	into cursor hold ;
	WHERE memoid=6 ;
	ORDER BY send_lname
give me the exact width of the trim field instead of the
original field width? this hapens on single or combined fields.

original field width = 20
actual width = 8
result width = 20
Extreme Programming = Plan -> Design -> Code -> Test
Next
Reply
Map
View

Click here to load this message in the networking platform