Sonny

Use SET DELETED OFF. Never use DELETED() in an SQL command. You're opening yourself up to problems if you extend the DELETED() by adding an alias with multiple open tables.

>Hi Naomi,
>
>Im using VFP version 9 SP1. The table's (CVdtl) main index is CVnoacct.
>
>The reasons i've asked about those 3 options are:
>1. I have 2 tables, 1 header and 1 detail tables
>2. Header tables re computes total amount based on details table as follows:
> 2.1. When user add, edit/modifies or deleted records/content in the detail tables
> 2.2. when user edit or delete from detail table, i want the cursor/record pointed to stay in that record after recomputing the header table's total. if i use select-sql for recomputing the totals, it does just like that since it computes using the temporary cursor and not the actual detail table. but when i use the do while or scan while using the detail table, the record pointer goes to the last record.
>
>So base on your views and as well from Boris, Tamar and Robert, I guess i would use the select-sql without the group by (optimize) in this case
>
>Thanks for all the reply. And Naomi, im a (gentle)man... :)
>
>Sonny