Thanks, Bernard. I am glad to hear the VFP9 takes care of this problem. I have one very simple way to share with anyone that has the same issue there and I am not sure if it works from all espects.

You still use VFP corsoradapt builder to do whatever you want to do regardless of 255 char limitation in cursorschema box. When builder popup the error message about 255 char limitation, you go back to the Data Access tab and highlight the while schema box and press Ctrl+X to cut the schema out, and then click OK button of the builder to save the settings. When you come back to the cursoradapter window, open the code window and go to Init event and enter the following code block right before "text to This.SelectCmd noshow" line:

text to This.CursorSchema noshow
[paste the schema here]
endtext

and paste the copied schema between the lines. That's it. It works!

Hugh