Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Statement truncates results
Message
From
19/12/2000 09:25:28
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00454936
Message ID:
00455006
Views:
24
>I figure VFP takes the result of one result to calculate the width of the result table, and additional rows are just a lot longer than that.

Mike,

You're right - it is standard SQL to take the width of the first value it sees to determine the width of the result. The PADR() is good advice.
Previous
Reply
Map
View

Click here to load this message in the networking platform