>>
>>You can build any or all of the query in code then macro expand it.
>>
>>lcFields = " People.*, Firm.company, Firm.sortcomp ;
>>FROM firm, people, ok ;
>> WHERE people.firmid = firm.firmid and ;
>> people.id > 0 and ;
>> people.id = ok.id and ;
>> ok.selected = .t. ;
>> &gcExecFlex. ;
>> ORDER BY People.last, ;
>> People.first
>
>I knew that I could do that. I actually use that all the time. It makes it possible to create incredibly long SQL statements without hitting that command string limit thing.
>
>But once I've run the SQL statement, can I make the resulting cursor updateable the same way that a view can be updateable? If so, what command? Cursorsetprop?
>
>paul
SELECT Blah...blah INTO CURSOR cReadOnly
USE (DBF("cReadOnly")) AGAIN IN 0 ALIAS ReadWrite
USE IN cReadOnly
SELECT ReadWrite
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer