Using CitectSCADA > Using Devices > Formatting Data in the Device > Deleting records using a database device

Deleting records using a database device

You can delete dBASE records with the DevDelete() function. The following Cicode function deletes records from a dBASE device:

FUNCTION DeleteRecords(INT hDev)
WHILE NOT DevEOF(hDev) DO
DevDelete(hDev);
DevNext(hDev);
END
END

To delete every record from a dBASE database, use the DevZap() function:

FUNCTION DeleteRecords(INT hDev)
DevZap(hDev);
END

To delete records from an SQL database, use the Cicode SQL functions.