>>I am creating a readwrite cursor and trying to replace .NULL. values in a column with zeroes, but the changes are not taking place. Here is my code:
>>
>>

>>SELECT P_productname, O_orddte, O_qty, ;
>Sum_rd_qtyrec, O_unitprice, O_checkmark, O_tmp_qtyrec, ;
>O_tmp_daterec, O_tmp_amt, O_orderid, ;
>O_p_productid from lv_order_by_dte_completed ;
>INTO CURSOR crs_grid readwrite
>>SELECT crs_grid
>>UPDATE crs_grid SET crs_grid.Sum_rd_qtyrec = 0 ;
>WHERE EMPTY(crs_grid.Sum_rd_qtyrec)
>>
>>UPDATE crs_grid SET crs_grid.Sum_rd_qtyrec = 0 ;
>WHERE crs_grid.Sum_rd_qtyrec = null
>>

>>
>>I have tried it with empty and null in the where clause. Any insight into handling this problems. Thanks in advance.
>>
>>Nick
>
>You can use NVL function in SELECT or use

WHERE crs_grid.Sum_rd_qtyrec IS null

>
>NVL function is for VFP back-end. In SQL Server you would use ISNULL function.
>
>WHERE FIELD IS NULL is the same in VFP/SQL Server.

thanks guys