Hello Listers, Here's a problem with Pro's (v8.0) SQL implementation that I had not noticed before. I've just been developing a MB program which includes a SELECT statement ordered by two fields (a 200 string field and an integer field). However, the results are not what I expected as the integer field does not sort correctly. On the hunch that Pro has a limit to the total field size for the ORDER BY clause, I reduced the string field to 150 characters (big enough for my data anyway) and magically it now works. So, lister beware than ORDER BY's (and maybe even GROUP BY's) are limited by field sizes.
Regards, Warren Vick Europa Technologies Ltd. http://www.europa-tech.com --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 18530
