Steve: Very good point about a transaction.
Reading Chuck's posting, I got the impression that this would be done on an "as needed" basis. To me, Truncate table is sort of the "Holy Hand Grenade", sort of like in the 4D Server betas when Array to selection would delete records. -- Douglas von Roeder 949-336-2902 On Tue, Apr 4, 2017 at 11:19 AM, Stephen J. Orth via 4D_Tech < [email protected]> wrote: > Tim, > > It appears to be back up again, but it was down for a bit, along with the > 4D website. > > > Steve > > -----Original Message----- > From: 4D_Tech [mailto:[email protected]] On Behalf Of Timothy > Penner via 4D_Tech > Sent: Tuesday, April 04, 2017 1:16 PM > To: 4D iNug Technical <[email protected]> > Cc: Timothy Penner <[email protected]> > Subject: RE: delete or truncate > > > I like the TRUNCATE TABLE command, but I'm thinking this cannot be used > within a transaction. > > " No transaction must be underway in the process executing TRUNCATE TABLE. > If this if the case, the command does nothing and the OK system variable is > set to 0" > > > 4D's documentation website is down, otherwise I would have confirmed > this first. > > Doc Center is up: > http://doc.4d.com/4Dv16/4D/16/TRUNCATE-TABLE.301-3037064.en.html > > -Tim > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** > ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
