Syntax for the DELETE and DELETE WHERE CURRENT commands is unchanged
for use with LONG
columns. It is limited for the DELETE command in that a LONG column
cannot be used in the WHERE clause.
In the following example, any rows in PartsTable with the PartName of
hammer are deleted.
DELETE FROM PartsTable WHERE PartName = 'hammer'
|
When LONG column data is deleted, the space it occupied in the
DBEnvironment is
released when your transaction ends.
But any data file selected earlier still exists on the operating system.
You may want to design
a "cleanup" strategy for such files that are no longer needed.