Are you sure that the row in other has been committed? It sounds like your GO TOP is causing that to happen.

>I just found something weird that I am looking to get some additional information on. It is in regards to a UNION clause where, being executed from the command prompt works, but, when being executed from the code, if the cursor of the UNION table is at EOF(), does not grab the related record.
>
>For example:
>
>

>SELECT Member.FName,Member.LName,Member.Numero FROM Reservation;
> INNER JOIN Member ON Reservation.NoMember=Member.Numero;
> UNION;
>SELECT Member.FName,Member.LName,Member.Numero FROM Other;
> INNER JOIN Member ON Other.NoMember=Member.Numero;
> ORDER BY LName INTO CURSOR Temp
>

>
>if executed from the code, doesn't grab the specific record from the Other table. However, doing this will make it work:
>
>

>SELECT Other
>GO TOP
>SELECT Member.FName,Member.LName,Member.Numero FROM Reservation;
> INNER JOIN Member ON Reservation.NoMember=Member.Numero;
> UNION;
>SELECT Member.FName,Member.LName,Member.Numero FROM Other;
> INNER JOIN Member ON Other.NoMember=Member.Numero;
> ORDER BY LName INTO CURSOR Temp
>

>
>What is causing such reaction?