>>>>
>>>>*And so forth
>>>>
>>>>
>>>>There's about another page and a half of code like this.
>>>
>>>
>>>If the html values get to the m.lcField variable OK, I don't know
>>
>>Is any of the columns nullable? Also, I don't like using macros here.
>
>Almost all of the columns can be null, and that logic is taken care of in the 'And so forth' part of the code snippet. As far as the macro use, breathe through the pain.
This IF NOT &lcField == &lcMemVar
>> REPLACE &lcField WITH &lcMemVar
>> ENDIF
doesn't work for nulls.
If it's not broken, fix it until it is.
My Blog