Delete in view

[parslej]

Sorry 4 waste your time, but I still have big problem (for me):

1. I have a view (my_view) and table (main.dbf)
2. I do something like:
"INSERT INTO my_view start VALUES (datetime())"
3. next: TableUpdate(1,.t.,"my_view&quot
4. now, if I want delete this record:
DELETE IN my_view
3. next: TableUpdate(1,.t.,"my_view&quot


OK, record deleted from my_view, but not from main.dbf.
(when I delete other records in view - all works fine - but if I try delete record just inserted in view and update view it's not working...)

Please, please, please helpppppppppppp !

 

[Guest_imported]

Try using
Go recno('my_view') in my_view

after issuing the delete command. !

This might work.

 

[parslej]

Tnx, but my problem is in update main table not view...
in View records deleteing corectly...

By the way:
What command to use is better SQL or stabdard

I mean:
"REPLACE WITH " OR UPDATE ?

 

[weedz]

Have you checked if the update of the view to the table was succesfull or not ?

In the view's propeties (in the view designer), have you checked the 'send SQL update' propety ?

HTH,
Weedz (Wietze Veld)
My private project:

http://www.crowncap.demon.nl\info\crwnbase

Download the CrownBase source code !!