>>>
>>>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

Nope. I want to write back to the original table. Like I would if I were using a view. The "people" table in the above example. ???

paul