chetana bhargav <bhargav_chetana-/[EMAIL PROTECTED]> wrote:
Want to know is there any easy way to make all the columns in a particular row to NULL other than specifying column name and NULL value, no delete as that would change the row-id
Well, you could remember the ROWID, then delete the row and insert the new blank one with the old ROWID. Realize that you can explicitly specify a ROWID in the INSERT statement: insert into tableName(rowid) values(123)
Igor Tandetnik
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------