Tech Tip: New behavior for TRUNCATE TABLE command

PRODUCT: 4D | VERSION: 11.3 | PLATFORM: Mac & Win

Published On: December 10, 2008

As of 4D v11 SQL Release 3 (11.3) the TRUNCATE TABLE has new behavior regarding the OK variable.

For the following example: TRUNCATE TABLE (aTable)

If aTable is already empty, TRUNCATE TABLE does nothing and sets the OK variable to 1.

If aTable is in read-only, TRUNCATE TABLE does nothing and sets the OK variable to 0.