Thanks, Mike. I'll use the NULL in the real table for other columns,
hadn't thought about that.
The comma actually works as a placeholder. I don't think it inserts a null
in the table, I think it just skips the column altogether, and the columns
vs values count comes out even. Using the NULL will be lots easier to
compare columns with values, that's for sure.
It didn't help in the example though. I need a variable in the values list
cause it can be null or have a value.
My best solution so far is to load a dummy value 'x' when the column should
actually be null then go back with update and set them all to null. Not
elegant.
>The one thing I noticed is you have 11 columns and 10 variables. I noticed
>the extra comma after .vprereqs and that may add a null automatically. I
>nevered tried it that way. I always used the word NULL if I want a null
>added. This also allows me to count easier so that no columns are missed.
>Actually I would just leave out the column name and the comma entirely.
>Maybe this will make a difference for you.
>Best regards,
>Mike Young
Paul Patrick [EMAIL PROTECTED]
University of Central Oklahoma
Edmond, OK 73034
(405) 974-2336 fax (405) 341-4964
