[sqlite] Re: Null-ifying the columns

[Igor Tandetnik]

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]
-----------------------------------------------------------------------------