Message
De
03/08/2003 22:24:59
À
03/08/2003 21:29:43
Divers
Thread ID:
00816294
Message ID:
00816366
Vues:
19
David,
As Jim pointed out, all SQL commands DO respect the SET DELETED setting. In addition passing alias to any VFP function, that could have alias as a parameter, may yield incorrect/unexpected results because SELECT doesn't use already open tables but opens them with the equivalent of USE ... AGAIN. Those functions even w/o alias specified might return unexpected results in multi-table queries.
>Mike,
>
>If you use any SQL commands on the table after you have deleted, but not packed a table, remember that the SQL SELECT statement ignores the SET DELETED setting. You therefore should index the table on DELETED(), and include NOT DELETED('tablealias') in the WHERE clause of any SQL command.
>
As Jim pointed out, all SQL commands DO respect the SET DELETED setting. In addition passing alias to any VFP function, that could have alias as a parameter, may yield incorrect/unexpected results because SELECT doesn't use already open tables but opens them with the equivalent of USE ... AGAIN. Those functions even w/o alias specified might return unexpected results in multi-table queries.
>Mike,
>
>If you use any SQL commands on the table after you have deleted, but not packed a table, remember that the SQL SELECT statement ignores the SET DELETED setting. You therefore should index the table on DELETED(), and include NOT DELETED('tablealias') in the WHERE clause of any SQL command.
>
--sb--