Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL-View
Message
 
 
To
20/10/1998 16:08:29
Senna Dwipayana
Indo Rebel Apparel Cv
Bandung, Indonesia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00148630
Message ID:
00148688
Views:
19
Senna,

Another thing you should avoid is ALLTRIM() on SQL fields. SQL will size the field based on the first result row it generates and that can easily wind up making the field width too small to hold the subsequent row values.

>ALLT(TRANSFORM(QuotePrx.prx,'9,999,999.99'))+'/'+ALLT(QuotePrx.Unit);
>+'='+ALLT(TRANSFORM(QuotePrx.content,'999,999,999'))+' '+;
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform