When I get theis problem it is usually because my first expression was blank and the where clause began with "AND". You may want to step through your code to determine the values of a1 a2 etc.
You may also need to place the "&" before each variable. I think construct &a1.a2.a3 will expand a1 but not a2 and a3. But I have not verified this.
>I need to build SQL-statement and the problem is that I have too many conditions in WHERE-clause. I try to store them in some variables and then use the "&a1.a2.a3..." expression to append conditions in a query. But it generates error message during execution. Maybe anybody knows the way to solve this problem ?
Ken Wardwell