What if... then how to?

[dexterdg]

Hi experts!

Now, I have two free tables and bot are used in a form and both are in buffering mode
freetable1 is on buffering 3 (coz its just what i need, record editing)
freetable2 is on buffering 5 (coz i manipulate more than 1(one) record on this table)
NOTE: the primary key of freetable1 is a foreign key to freetable2 in which they are related accordingly

for instance im done with addting in both tables(also handled revert if ever user changes his mind)

Now, when the user deletes a record, i issue a simple delete tag for both tables(two delete tags, one for ea.)
the "record" on freetable1 is successfully deleted but "records" in freetable2 has no effect.

Then how can i possibly achieve deletion to this freetable2, with (Buffering = .t.) don't work;
Delete with (Buffering = .T.) From freetable2 where FK = freetable1.PK

Flow:
Run From
-enter adding mode
--Add the info.
---*click* save
-exit adding mode
-issue delete command
--no error occurance, freetable1 specified record is deleted but not the related info on freetable2 that is dependent to freetablle1
Close Form

Thanks
Dexter

 

[Olaf Doschke]

In table buffering mode any changes, also deletions, are buffer. TABLEUPDATE() to delete records in the DBF.

Bye, Olaf.

 

[Olaf Doschke]

i issue a simple delete tag for both tables"
Are you really doing DELETE TAG? That is deleting an index tag, not a record.

Bye, Olaf.

 

[dexterdg]

oh! i didnt know what hit me and forgot that! thanks olaf!