I have a feeling (more like a vague recollection of the limitation) that you're right. The SQL statement can only be 255 characters long. There are a couple of options.
1. declare an alias for the table names
... FROM prodprov p... and then use p. instead of prodprov.
2. use a view
3. build and execute the SQL (to a cursor) in the load event and base the grid on the cursor.
Cheers,
Andrew
If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?
From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."
All my FoxTalk and other articles are available on my
web site.
Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.