> To everyone,
>
> I wonder why my statement 'Update' below does not affect the OrigTable? If I make some changes to the data in the CurTable and use 'Update' command to make changes to OrigTable, it works. But If I delete a record from the CurTable and use 'Update' command to update the contents of the OrigTable, it won't work.
>
> Why is that? Thank you very much in advance.
>
>
> Create Table OrigTable (acctno c(10), custname c(30))
> Insert Into OrigTable Values ('0000000001','MERINISSA')
> Insert Into OrigTable Values ('0000000002','MERCEDITA')
>
> Select * From OrigTable Into Cursor CurTable ReadWrite
>
> Delete For CurTable.acctno = '0000000002'
>
> Update OrigTable Set OrigTable.custname = CurTable.custname Where ;
> Alltrim(OrigTable.acctno) = Alltrim(CurTable.acctno)
>
>
> Merinissa Galapon
>
Discontent is the first step in progress. The update SQL does just that, it
updates the contents of a table .
If you want to affect the OrigTable in the way that you want to delete the same record as you did in the cursor you need the
DELETE FROM SQL statement.
Boudewijn Lutge®ink
http://www.vfpdevelopers-online.comThe truth will set you free, Ken knew the truth!