General information
Category:
Coding, syntax & commands
>
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only