>Craig;
>
>Well, you definitely need to be VERY careful with RECNO - I always use the alias name to specify WHICH recno I want. Most folks have forgotten that optional parameter exists.

That may or may not work as SQL may open the table again with a different alias. I would not rely on it.

>
>I found that using a different alias name solves the problem (which acted the same way in VFP6). It must be a reserved word in SQL, 'cause I didn't see it in the VFP reserved words.
>
>Well, I got it working, anyway. Thanks for the response.

I've seen weird things like that before. Glad you got it working.