Update SQL data, Please Help.

[3000]

I have MSACCESS database and in one of the filed i forgot to a add 0, now i have 65,000 records it will take me log time to go and add 0 to fields which are NULL. Therefore i decided to write a function that would add 0 to record which are NULL.

int nill = 0;

try
{
for ( recset.open;recset.EOF();recset.MoveNext())
{

if (recset.m_SPrice =" &quot
{
recset.m_SPrice = nill;
recset.Updata();
}
}
}

I am getting TWO error due to the fact that m_SPrice is decal. as COLeCurrance, 1) in the IF statement and 2) setting the value of m_SPrice. its a conversion problem..

can someone pls tell me what i am doing wrong.

 

[Zyrenthian]

why not create the query in access?

"UPDATE SET

.NewField = 0 WHERE <clause>&quot; or no where clause...

It would look something like that BUT

BACKUP THE DATABASE FIRST!!!!

Matt