Note that if you use private datasessions, the form uses its own setting for SET DELETED (and a bunch of other SETtings). Make sure that SET DELETED is ON
for the form you are using the SELECT command in (if it is in a form).
>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)