Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL column too narrow
Message
 
To
10/07/2012 06:46:04
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows 7
Network:
Windows 2000 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01547895
Message ID:
01547992
Views:
31
>>Hi. One of my sql result columns is only 1 character wide (numeric). I am thinking that it is because the first group value (for this field--a calculated one) is 0. How would I force the width of this field. Keep in mind that I am in Fox 7.
>>
>>Thanks, Randy
>use cast(0 as I) or cast "" as c(25))
>
>
>Peter

Not in VFP7 :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform