Agnes, thanks for the reply.

>>But this for native views.

For your problem it seems that the &lcWhere is send to the remote source without expansion, what will cause the error. IOW I read the error message like: VFP will not expand the macro for remote views.>>

That is my experience so far. Can anyone else confirm that macro parameter expansion is not possible for remote views, or is there a way around this problem?

>>The only thing I have heard of are store procedures on the remote side. But I have never done things like this.>>
Me neither, and I don't want to get into these things at this stage. I would rather concentrate on front-end development and leave the SQL stuff to the DBA staff.

Regards,
Alan