I like to project a table using the where clause of the command I would use to delete. That way I can append it or the necessary rows back to the original table if I need to. I use a name like Back[tablename].
It gives you a way to practice without amputating parts you need. I also backup or unload my database regularly, after working on it or adding data, and before doing a significant [read critical or dangerous] operation. I have never been disappointed I had another [recent!] backup. If your key columns are indexed, there may not be much performance benefit from removing outdated rows. All the best, Randy Peterson Sent from my iPhone > On Feb 3, 2021, at 8:53 PM, Bruce Chitiea <[email protected]> wrote: > > > Patrick: > > R:BASE has the perfect command for this: > > DELETE ROWS FROM <tablename> WHERE <condition(s)> > > The <condition(s)> may very well be what Jim Belisle suggested earlier: a > date; before which date, you have twenty years worth of rows to delete. > > If <tableName> is "oldStuff" and <condition(s)> mean any date in the > "stuffDate" column before December 31, 2019, the code would look like: > > DELETE ROWS FROM oldstuff WHERE stuffDate <= 12/31/2019 > > This example presumes that your DATE FORMAT is set as: > > SET DATE MM/DD/YYYY > > This is not the only way to do this, and not, in fact the safest; but the > alternative is for another email. > > **CAUTION/CUIDADO** There ARE other considerations. Are there rows in other > tables which depend upon the data in the rows you want to delete? Have you > considered how you wish to deal with that related data? Will you break > historical reports? With archive drive space being so inexpensive, is this > the best approach? > > Your question may require a closer look at your situation, and a more > detailed approach to a solution; so by all means, provide more detail if you > like. > > Best, Bruce > > Bruce A. Chitiea > SafeSectors, Inc. > ----------------------------------- > 112 Harvard Ave #272 > Claremont CA 91711-4716 > USA > ----------------------------------- > [email protected] > ----------------------------------- > +011 (909) 238-9012 c > +011 (909) 912-8678 f > > > > > ------ Original Message ------ > From: "IT Man" <[email protected]> > To: [email protected] > Sent: 2/3/2021 2:19:32 PM > Subject: ***SPAM*** [RBASE-L] - Table browsing > >> Is there a way to select multiple rows in a table and delete or do I have to >> delete one at a time? I have 20 years of data that is not needed and needs >> deleted >> >> >> >> Thank You >> >> Patrick Schlauch >> >> Trexler Rubber >> >> >> > > -- > 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/007201d6fa7a%24a64481f0%24f2cd85d0%24%40trexlerrubber.com. > -- > 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/em3e3a7b35-46a0-445a-8665-8a50886d4aa9%40pathfinder. -- 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/714B4B68-F041-4DC4-A98D-3E6D8C0F44ED%40ctags.com.
