I have a Sharepoint form that has number fields. These are treated as text fields in Sharepoint. When saving the form values I am attempting to UPDATE the VFP tables. If the user clears the text field of a number then saves the form's data, the variable seems to be evaluated before it gets to the OLEDB UPDATE. The cleared field evaluates to a NULL value. I cannot get the OLB DB statement to work with NULL values because, it seems, that the cleared variable is evaluated PRIOR to the UPDATE command.

Has any one come across this? Am I missing something? I'm trying to stay away from scripts in the Sharepoint form.

OLDDB chokes on each of the following:

UPDATE client SET nLoansYTD = %loansytd%
UPDATE client SET nLoansYTD = IIF(%loansytd%=.NULL., 0, %loansytd%)
UPDATE client SET nLoansYTD = IIF(ISNULL(%loansytd%),0, %loansytd%)


Thanks in Advance,
-Gil