Again, you can use a single table temp editable view for the dbgrid. while the form displayed, whatever mechanism you use to change your order by or select criteria, you
Example code from one of my forms; SELECT COUNT (*) INTO vcount IND vin0 FROM sys_tables WHERE + sys_table_name = 'tvwApChecks' IF vcount > 0 THEN PROPERTY table tvwapchecks 'CLOSE' DROP VIEW tvwapchecks CREATE TEMP VIEW tvwapchecks AS SELECT rcheckno,cono,cid, + transdate,amt,reconciled,dupecheck,refno FROM agcheckreg + WHERE cono = .vcono AND cid = .vcid ORDER BY rcheckno PROPERTY table tvwapchecks 'OPEN' PROPERTY table tvwapchecks 'REFRESH' ENDIF On Monday, July 1, 2019 at 3:24:51 PM UTC-4, Jim Belisle wrote: > > Thank Jan for pointing me to the PROPERTY commands. I had looked at that > one but did not realize it would bring up the box. > > Did the trick. > > > > James Belisle > > > > *Making Information Systems People Friendly Since 1990* > > [image: cid:[email protected]] > > > > *From:* [email protected] <javascript:> [mailto: > [email protected] <javascript:>] *On Behalf Of *jan johansen > *Sent:* Monday, July 1, 2019 11:25 AM > *To:* [email protected] <javascript:> > *Subject:* Re: [RBASE-L] - multiple sorting of db grid > > > > Jim, > > > > I don't use DB grids all often but should be able to use an "order by" > before bringing up the form. > > Also there appears to be a PROPERTY command to bring up a sort called > SHOWSORTDIALOG > > > > Jan > > > > > > > > From: Jim Belisle <[email protected] <javascript:>> > To: "[email protected] <javascript:>" <[email protected] > <javascript:>> > Date: Thu, 27 Jun 2019 15:09:47 +0000 > Subject: [RBASE-L] - multiple sorting of db grid > > > Is there a way to have multiple sorting of an enhanced DB grid form? > > > > James Belisle > > > > *Making Information Systems People Friendly Since 1990* > > [image: cid:[email protected]] > > > > > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] <javascript:>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/DM6PR02MB453930DF5ACF2DA9BE45D064A0FD0%40DM6PR02MB4539.namprd02.prod.outlook.com > > <https://groups.google.com/d/msgid/rbase-l/DM6PR02MB453930DF5ACF2DA9BE45D064A0FD0%40DM6PR02MB4539.namprd02.prod.outlook.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/f8ee3b6b-3ab8-4664-9831-a4fa2a2e12d9%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
