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?