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