Hello everyone,

VFP8 SP1.

I am having a little bit of trouble. The following SQL select is always including a deleted record.

SELECT jid.DeliveryKey;
	FROM v_JobIteDel jid;
	JOIN v_JobItems ite ON jid.JobIteKey = ite.JobIteKey;
	WHERE jid.DeliveryKey = v_delivery.DeliveryKey;
	INTO ARRAY aTemp

The value of SET DELETED is ON. The above statement is joining two updateable SQL passthrough cursors that have a buffer mode of 5. The deleted record has not been committed at the time the Select statement is executed.

I get the feeling this is something to do with VFP ignoring buffered data in SQL select statements. If this is the case, how can I process similar to the above? Even though I have asked for a single column, I am only actually interest in the _TALLY ie., zero and there is no match, anything greater than zero, matches exist.

Thank you all!

Regards,

Angie.