Base it on a single table view, then you can disconnect the recordset, change the view definition, and reconnect on the fly..
----- Original Message ----- From: "Dennis McGrath" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Thursday, September 13, 2012 12:44 PM Subject: [RBASE-L] - RE: DB Grid That would probably work if I used an arrange clause when starting the form. What I want to do is change the sort order in code and then refresh. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Thursday, September 13, 2012 11:21 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: DB Grid Dennis, Have you tried a PROPERTY REFRESH command? From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Dennis McGrath Sent: Thursday, September 13, 2012 8:50 AM To: RBASE-L Mailing List Subject: [RBASE-L] - DB Grid Is there a command that will resort a displayed DB Grid? Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected]<mailto:[email protected]> --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================

