The Single Table View (editable) is what I normally use.
----- Original Message ----- From: "Tony IJntema" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Thursday, September 13, 2012 3:51 PM Subject: [RBASE-L] - RE: DB Grid : 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. : ================================================ : :
