Maybe there is another solution
If the temporary view is based upon a single table it is still editable. Maybe you are able to change the order by clause dynamically by using something like 'order by &V_sort' after having changed the value of &V_sort in an eep If have implemented this feature in a where clause and it works wonderful I think you better use a temp view, because then it is unique for each user Tony From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: donderdag 13 september 2012 21:18 To: RBASE-L Mailing List Subject: [RBASE-L] - RE: DB Grid Already is one. I can make a workaround, but was hoping for a simpler solution. I guess I could have a sort column and update that and refresh. I'm thinking it would work well if I have an ARRANGE BY clause. The other alternative is to drop the table and repopulate in the new order. 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 Alastair Burr Sent: Thursday, September 13, 2012 2:13 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: DB Grid Use a temp table? Regards, Alastair. From: Dennis McGrath <mailto:[email protected]> Sent: Thursday, September 13, 2012 6:40 PM To: RBASE-L Mailing List <mailto:[email protected]> Subject: [RBASE-L] - RE: DB Grid That would be a possibility but would make the data uneditable (sorted view) Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Mike Byerley Sent: Thursday, September 13, 2012 12:03 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: DB Grid 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]%3cmailto:[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]%3cmailto:[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. ================================================
