Setting a cell to empty -
10-18-2006
, 05:43 PM
Can you set a cell to an empty/null value? I tried using some old OLEDB code
to set the Value property of a cell to null and I get "The cell writeback
operation cannot update a cell to a NULL value." Right now I'm operating
under the assumption that I'll have to use a background process of some kind
to do a SQL DELETE operation on fact rows where the measure=0.
Is this correct or is there a better way? |