Set filter for deleted in MariaSql (SOLVED)

[Marc Venken]

Hello,

How can I show the deleted records in Ors ?

Code: Select all  Expand view

  FWCONNECT oCn HOST cServer USER cUser PASSWORD cPassword DATABASE cDatabase

   if oCn == nil
     ? "Failed to connect"
     return nil
   endif

   oRs   := oCn:RowSet( "SELECT * FROM ploegen" )
 

This set a filter correct
ACTION (oRs:SetFilter( "ploeg2017 = ?", { ::cCaption } )

But I also want a button that shows de deleted records? I have SET DELETED ON on top of the program.

[Marc Venken]

Oeps,

I just notised that when you delete a record in Xbrowse and MariaSql, the record is totaly deleted !! So it can't be shown again with a Filter.

Do I have to proceed a other way than ?

I want to deleted the records from the Browse so that they don't show up, but also that I can get them back for some actions.

[Adolfo]

First, this was the behaviour of DBF's when you mark a record for deletion, now you hace to use a field for this kind of filter or whatever, lets say a "ACTIVE" field, so you can Activate it or Deactivated as will. So when you "delete it " from xbrowse you just change "ACTIVE" to .F., and all the way around when you wanted it back.

My 2 cents.

From Chile
Adolfo

[Marc Venken]

Yes, I realise now that it has to be done like that.

A extra field for the deleted record set to on and off.

Thanks.

[nageswaragunupudi]

In ALL the databases in the World, except DBF, once a record is deleted it is gone.
More than 99.9% of the programmers in the world do not know DBF.
We need to start thinking like them.

[Marc Venken]

I Agree.

[Maurizio]

You cann use TRIGGER before delete ( or update ) , and popolate a table .

Maurizio

[nageswaragunupudi]

You cann use TRIGGER before delete ( or update ) , and popolate a table .

Maurizio

This is what we do generally for highly secure software. For every deletion and also modification we create log files with userid, programid and datetime stamp

[Marc Venken]

I did some lookups.

A trigger is a SQL command that will do a append in a file if there is a delete in a other file.

But in my specific case, (the old dbf way) I wanted to not show deleted items or show them.
I best make a fieldname with deleted, BIT 1 and than trie to make a sql filter to show or not show this.

ACTION (oRs:SetFilter( "ploeg2017 = ?", { ::cCaption } )

But than for a fieldname deleted = .t. or delted = .f. (How in SQL)

Thanks.

[nageswaragunupudi]

Add a new field

Code: Select all  Expand view

oCn:AddColumn( tablename, { "DELETED", "L', 1, 0 } )

Then use this

Code: Select all  Expand view

ACTION (oRs:SetFilter( "ploeg2017 = ? .AND. deleted = ?", { ::cCaption, .f. } )
 

[Marc Venken]

Thank you.