BIG PROBLEM with NULL and Prepared Statements

If i have a sentence like this

INSERT INTO TABLE1 (FIELD1, FIELD3, FIELD3) VALUES (:FIELD1, :FIELD2, :FIELD3) i do the followind:

parse
bind
for i = 0 to ...

    load variables
    execute
next

If the FIELD1 is of double type, and the value to insert is NULL, how i pass the value?.

i do the binding :FIELD1 with the variable dField1, for example. If the first iteration dField1 = 10, works ok, but if next are NULL, what must have dField1?.

thanks. Received on Tue Jul 06 1999 - 11:38:53 CDT