FiveTech Software tech support forums

hi,

did nobody have a Solution to "show" DELETED Record in XBROWSE

hi, i want to shsw DELETED Record so i use    SET DELETED OFF   BrowseDBF( cPath, cFile, cAlias, cRdd )   SET DELETED ON but when call   oBrwDBF:Delete( .T. ) // what is Parameter .T. for ? i got a "YesNo ...

... I'm using Pelles C resource editor too. But I have a problem that each time I save my rc file the line 1,24 "WindowsXP.Manifest" is deleted. So I have to put it manually into the file which is not very difficult but quite annoying. Do you have the same phenomenon? Regards, Detlef

... * ::nLen, ; * If( Empty( OrdSetFocus() ), OrdKeyGoTo( n ), OrdKeyRelPos( n / ::nLen ) ) ) ) } * else ::lRelyOnKeyNo := If( Set( _SET_DELETED ), "DELETED()" $ Upper( DbFilter() ), .t. ) * endif endif DEFAULT ::bKeyNo := {| n | iif( n == nil,; ( ::cAlias )->( OrdKeyNo() ...

... text after I delete it init from ++ space 1) write a text https://i.postimg.cc/v89Kh3jT/1.png 2) press the button and the text is deleted https://i.postimg.cc/gcXxT6qn/2.png 3) I insert a new text , but it init from position 0 + 4 https://i.postimg.cc/3NnfGbSx/3.png ...

... ) ) // RETIDO->(DBGOTOP()) // xbrowse() cTime :=TIME() SELECT RETIDO Index On COD_AVUL+COD_EMPRES+COD_PRODES TAG TEMP_1 FOR (Deleted() == .F. .AND. MES_ANO == "0121" ) TO RET_TEMP TEMPORARY DbSetIndex( "RET_TEMP" ) RETIDO->(DBGOTOP()) DO WHILE !EOF() ...

... for use in the work area (alias) where created and not available for other aliases of the same dbf. They are created as temporary files and deleted when the alias is closed. They are also called memory indexes. In the command, we can use either TEMPORARY or MEMORY. I tested it here and it ...

... for use in the work area (alias) where created and not available for other aliases of the same dbf. They are created as temporary files and deleted when the alias is closed. They are also called memory indexes. In the command, we can use either TEMPORARY or MEMORY.

James, My concern was my clients. I figured they wouldn't normally use this capability. I resolved it by doing the following: 1) I left SET DELETED ON when starting the program 2) I put in a Menu item that calls a Function: FUNCTION SelDelStatus        IF MsgYesNo( "Do ...

Tim,

It is possible to do INDEX ON ... FOR NOT DELETED

And you can create another index without that clause.

Then you can just switch indexes to get all records or only records not deleted.

I haven't tested this.

James

That didn't work ... at least with the ways I tried. My TEMPORARY WORKAROUND is when I start the Editor, I SET DELETED OFF. Then, upon exit, using the VALID clause I can call a function to SET DELETED ON. The main problem with this is it is still universal. So if they use the ...

Dear Tim,

you could use the xbrowse container window bGotFocus and bLostFocus to SET DELETED ON and OFF

Though SET DELETED ON/OFF is a global setting effecting all WorkAreas, it is still possible to do what you want. There are several ways. I will be posting a few samples soon. Please wait.

... ( It is NOT FiveDBU though I do work with that. Mine is a full CLASS build and just for DBF at this time ). In the Main() module, I use SET DELETED ON because my clients never want to see Deleted records. However, in the Editor, it would be helpful to see them. IF I use SET DELETED OFF in ...

Dear Tim, I just tested FWH\samples\fivedbu.prg and changed this line: SET DELETED ON // OFF and then I did this before creating the XBROWSE (look for XBROWSE inside fivedbu.prg): SET DELETED OFF and the deleted records are properly shown https://github.com/FiveTechSoft/screenshots/blob/master/time_deleted.jpg?raw=true