Jerry,
Is that the exact code being used? What if you declare the memvars private instead of local?
If you have local variables and you are actually calling a SQLObject method or a SQLExec() wrapper function the variables will not be in scope when SQLExec() is called and VFP will prompt you to supply the values.
>The code that Cetin used is the same that I used. I see that he removed the extra commas. I had several other fields in my code that I removed when I copied it into my message here but left in extra commas. I also tried concatenating as you suggest but it is still prompting me for the values.