VFP OLE DB provider does not support parameters in a form '%loansytd%'
>I am not at that system right now but I think we tried that. Or we got going in another direction just before we tried that. Its all so fuzzy now...:)
>I will try that tomorrow morning and let you know. I do have the feeling that the OLE DB driver evaluates the variable prior to inserting it into the command string. The return error message shows part of the command like this:
>UPDATE client SET nLoansYTD = IIF(ISNULL() ... too few arguments
>The command is UPDATE client SET nLoansYTD = IIF(ISNULL(%loansytd%) where ...
>
--sb--