VFP properties editor cannot assign strings longer 255 characters to properties. You require to assign longer SQL statements by code (in run-time), for example, in the Init event of CursorAdapter.
>About 400 characters.
>I was using the DE builder and pasted the select string into its SelectCommand box. When I look at the SelectCommand property in the new CursorAdapter's property sheet there are only about 250 characters there.
>
>
>>Hi!
>>
>>Well, how long it is really? How you assign it? Any code sample?
>>
>>>My SELECT string is too long to fit in the CursorAdaptor's SelectCmd property. Is there some easy way around this problem/Will it dealt with in
>>>the finalized version of VFP8?
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.