FiveTech Software tech support forums

Richard,

>Still puzzled, this is the part where the error occured , in the default part .... the first 2 lines were executed not the third.

Well, it is all actually only one line as far as the compiler is concerned, so I am wondering what makes you think it is erroring where you say it is?

James

James what does setrdd() do??

James yes i did add setrdd() to my code Still puzzled, this is the part where the error occured , in the default part .... the first 2 lines were executed not the third. DEFAULT ::bGoTop := {|| ( ::cAlias )->( DbGoTop() ) },; ::bGoBottom := {|| ( ::cAlias )->( DbGoBottom() ) },; ::bSkip := {| ...

Richard, Logic would say that the dbgotop() worked because the database was still open when it was called. Logic would also say that the if select( cAlias ) = 0 trap didn't work because the alias was still valid at that point. Possibly, it is a timing issue that a sysrefresh() or dbcommit() would so...

Not sure but if this code is what you looking for. it will let you know if the databas is open. It seems my app (Very large) closes out files i just reopen rather then spend hours looking for the close that happened. Not great programing but it works. function  IsAlias(cAlias)   local lIsUse...

James Rao is right , i agree with the 3 points After making further research , it looks like my file is closed somewhere in my app, it does not show on the active databases in the error.log Nevertheless i am puzzled how we get to the error and why all the traps did not work, so i have some questions...

Richard, Obviously, I need some sleep (I've been up all night). >And here is your definition of bSkip: >oBrwAPP:bSeek := {|c| DbSeek( Upper( c ) ) } I misread the above line to be dbskip not dbseek(). Nevertheless this line still needs fixing. It may, or may not, be causing the dbskip error. I...

With due respects to one and all here, I can guarantee that this dbskipper error would NEVER occur, IF obrw:cAlias is explicity assigned and then oBrw;SetRDD is called, unless this alias is closed in some other code of the program. Conditions: 1) oBrw:cAlias ---> SHOULD BE EXPLCITLY ASSIGNED. ( m...

Harvey, >I understand your comments but 130 prgs is a nightmare. Well, I don't disagree. However, I have recently been working on an application that I didn't write that is 104 PRGs, and Copernic has been extremely helpful. It would take me 10-100 times as long without Copernic. I highly recommen...

I understand you comments but 130 prgs is a nightmare.

Harvey,

After reviewing your error report again, I think you have the same problem as Richard.

Take a look at my previous message to him.

Richard and Harvey: I'll give you a hint. If you were using database objects you would never have these obscure, intermitant, and hard to find errors.

James

Harvey, >Jmaes: >130 prgs. Big job. You need Copernic Desktip Search. Its global searches are very fast and you can preview each find on the screen without opening an editor. I can seach my entire hard disk in about 2 seconds. Ironically, it takes slightly longer to search a directory since yo...

Richard, My apologies, I am trying to follow too many threads at once and I got confused. Please ignore my previous message about functions. You are getting a "workarea not in use" error with dbskipper(). And here is your definition of bSkip: oBrwAPP:bSeek := {|c| DbSeek( Upper( c ) ) } Do...

Jmaes:
130 prgs. Big job.

Richard, >I did a research in those functions , none of them closes the database, this database is always open Did you do a global search of all your code looking for places where databases are closed? It may be in another function called from one of those functions. >As per changing the worka...