>>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.
>
>>

Now, That's an EXCELLENT point! Must be Rusmore! Thanks!

>>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.