User Tools

Site Tools


fScan Reference Manual, Chapter 2 (CmdLineOptions): table_delete

Table delete -- Deleting a table or table entries

Usage: -table delete TBLNAME FLAG COL [VALUE1] [VALUE2]

If TBLNAME is the only argument, the entire table will be deleted.

With other arguments this will perform a QUERY as described above and only delete those rows that satisfy the query.

FLAG: Option flags (combine by adding):
* 4 - VALUE1 is a row number
* 32 - only delete first instance
* 64 - VALUE2 is a binary mask to use for COL value
* 128 - inverse query; search for COL values that don't match; this is automatic if VALUE1 is preceded by '!'
* 256 - don't display error message on query failure
* 512 - find COL with missing value (assumed if VALUE1 = 'NULL')
* 1024 - do not convert 'NULL' in VALUE1 to missing value

See Also:

fScan Home,
fScan Manual,
Manual Help

jvs/fscan/manual/chapter2/tabledelete.txt · Last modified: 2014/08/04 16:03 (external edit)