FiveTech Software tech support forums

... con ! FOR deleded() Un saludo JLL Yes. Finally I am going to come to a similar recommendation. Before that I wanted to know the effect of ::DelRepos(). Some users have been occasionally facing this problem and I am trying to decide a final fix. About ! Deleted() condition: Having a for clause ...

May I know the version of FWH you are using?

Please see the method Refresh() in the xbrowse.prg and locate the line with the code:
::DelRePos()

Please comment out this line and link to your program. Can you let me know if the problem is resolved or not with this change?

... escrito con llamadas a ToExcel() o ToCalc() funciona en cualquier sistema en el que, ya sea Excel o OpenOffice Calc estén instalados. Método DelRePos Este método es llamado desde el método Refresh. Se utiliza para lanzar un error en tiempo de ejecución cuando en una dbf se usa SET FILTER ...

... , cFilter will be empty. Next code tries to avoid this //----------------------------------------------------------------------------//METHOD DelRepos() CLASS TXBrowse   local lRepos := .f.   local rec1 , rec2   if lAnd( ::nDataType, DATATYPE_RDD ) .and. ::nLen > 0      ...

... software is not found. Now software written with call to ToExcel or ToCalc work on any system where either excel or calc are installed. METHOD DelRePos This method is called from Refresh method. This used to raise a runtime error when DBF is SET FILTER TO an expression containing local / static ...

NageswaraRao, Thanks for the detailed explaination. It does seem that it would be less work to change from using a local or static than to write repostioning code. One other possible solution would be to leave the original code as is (so that it does error out with locals and statics) and add a comm...

... modification has become a great irritant to the programmers who use local / static variables in their filter expressions. I propose revision of DelRePos() method as below: //----------------------------------------------------------------------------//METHOD DelRepos() CLASS TXBrowse  ...

Hi Richard, The filter now works fine, but an error in DelRepos encountered when pressing the Alt key or when resizing columns with mouse.: Error description: Error BASE/1003 Variable does not exist: CALIAS_PAYDB Stack Calls =========== Called from: ...

... the variables contained in the filter expression private not local so they remain visible to xbrowse 2. Change your copy of xbrowse.prg in the delrepos method and comment the filter section this way METHOD DelRepos() CLASS TXBrowse   local lRepos := .f.   local cFilter, ...

... 2 xbrowses with reference to different database respectively.. I have used DBFilter but the browses crashes the display after each method call to DelRepos(). I wonder if somebody could send me a sample working program with the situation below: First browse have records of employee indexed by lastname ...

James,

Yes, I also thought about that yesterday, when I answered

That enhancement was developed by Nageswararao, as far as I remember. His comments would be welcome.

Antonio, >Basically the idea is that we are going to repaint the browse, and if the current record does not match the filter expression, then we skip it, so it is not displayed. But as Frank said, isn't this redundant since the database RDD is already handling the filter? It seems to me that the ...

Otto,

>
But if the filter expression contained references to local or static variables you get an error:
Error BASE/1003 Variable does not exist: CRGZIMMERNR
>

You can create a temporary private variable to hold such value.

Thank you, Antonio. But if the filter expression contained references to local or static variables you get an error: Error BASE/1003 Variable does not exist: CRGZIMMERNR How can you resolve this problem? Thanks in advance Otto Otto, The problems comes from macro evaluation cFilter ( := Dbfilter() )...

Thank you, Antonio.

But if the filter expression contained references to local or static variables you get an error:
Error BASE/1003 Variable does not exist: CRGZIMMERNR

How can you resolve this problem?
Thanks in advance
Otto