C/ODBC & Null values

Hi! I have such problem. I can’t Insert records into Navision database by INSERT statement. I get errormessage: “You tryed to assign the Null value to a variable thas is not a variant data type.” When i fill all fields with something, it works. But in real life lot of fields are empty. It must be marked, that SELECT, UPDATE, DELETE work very well. I tried out it in ACCESS database and VBscript. INSERT doesn’t work in both. With regards, Maris