Subject Re: Dynamic SQL Error: need help understanding
Author homerjones1941
> TO must be FOR:

Well, how dumb was that? I certainly appreciate the extra par if eyes. I don't know how many places I looked up that syntax, and still got it wrong. Thank you so much.

> BTW, you can omit the parentheses around :VPOS - 1.
> Also, the colons prefixing the variable names are only necessary if you use them inside an SQL statement
> (e.g. "select this from that where mypos > :vpos").

Thanks again. As you can tell, I'm still learning. I really do appreciate your tips. I think I put the parentheses around that phrase because I couldn't understand what @1 was. Just trying anything except the right thing. :-)