FiveTech Software tech support forums

Hello,

Unfortunately I have not found any info to do it via FW.

hi

as James say you are using FILTER on "Skipper" of "Browse"
DbSetFilter() will use hole DBF and "Skipper" will test until EOF() / BOF()

i use DbSetFilter() only with SCOPE
SCOPE will "limit" EOF() / BOF()

Marc, The more a problem is that using several combinations and so calling the function several times (ex. 10 calls) It seems that the program is going to freeze. I hardly ever have been thinking of releasing objects, fonts, etc. and have no clue about memory leaking, so this could also be the probl...

Enhanced version: live tests: https://www.fivetechsoft.com/counter/info.php https://www.fivetechsoft.com/counter/modpro.php test.php <?php   $result = shell_exec( "./modharbour test.prg" );   print( substr( ...

Otto, However, it appears that Marc's routine allows the user to pick the fields for the replace. This eliminates the possibility of using an index. So he has to use a plain filter which requires reading the entire database. And this requires the database to be in exclusive use mode, so it needs to...

... on all possible options. Ok, the speed will process all data, but i wonder .... If I make a second solution for my other users (they just want info about a brand or so) Dbf = 10.000 records and I select a products brand, that will give me a result of 700 records. With the filter function I ...

Otto wrote:Hello Marc,
would you mind telling me how many records the database has?
Best regards,
Otto

44.000 records

Dear James, Thanks very much. As you contributed so much with your "Introduction to FIVEWIN" and your DATABASE class for our language, I hope you can do the same for mod harbour. I posted under this topic, but I don't mean in this particular case. I mean for WEB programming in general and ...

Otto, On the web, we read the data and then hand it over to the client. Is there perhaps a different approach to choose as on desktop where an object has a certain life? Is our task on the backend simply to achieve the fastest processing speed on reading and writing from/to the database When you are...

Dear James, may I ask your advice. On the web, we read the data and then hand it over to the client. Is there perhaps a different approach to choose as on desktop where an object has a certain life? Is our task on the backend simply to achieve the fastest processing speed on reading and writing from...

Marc, My count of Indexes are growing. For products now, there are 14. Several off them are only used in a update routine, but since they are in the initial cdx, they will be active all the time. Is it adviced that we only make a index for the CDX for main Tags like, code, name, firstname and for al...

Hello Marc,
would you mind telling me how many records the database has?
Best regards,
Otto

... good I think. (this become a speed issue) Maybe I should reconsider this total function and make a dialog filter system where I can ask the needed info ? Maybe I need to make (temp) indexes for all the search fields from that browse, so they become optimised ? :bBarGetAction := {|| ( oBrwSel:cAlias ...

My count of Indexes are growing. For products now, there are 14. Several off them are only used in a update routine, but since they are in the initial cdx, they will be active all the time. Is it adviced that we only make a index for the CDX for main Tags like, code, name, firstname and for all othe...

         case nBruto > 0 .and. nAankoop > 0           replace (cAlias)->bedrag with nofoto->bruto           replace (cAlias)->aankoop with nofoto->aankoop       ...