FiveTech Software tech support forums

... this function in hundreds of clients every day! I think that the error is somewhere else, some kind of virus or another odd error... The error is intermitent (only on the first run of the day, if I recover a copy of the exe the error ceases), happens only in this client, changing the file from ...

Richard, That looks like a nice workaround but it looks like the user is going to be quite surprised when the browse just automatically closes on them. Here is how you can track down where the database is being closed. Create a transaction log file and record when each function of the buttons is bei...

James

What i did to secure my browse is to add this

oBrwAPP:bGotFocus := {|| IF(SELECT("APPEL") = 0, (OBRWAPP := NIL,APP1:SetFocus(),APP1:PostMsg(WM_CLOSE),APP1 := NIL ) , ) }


Richard

Harvey, I looked at your error message again and I don't think the error is occuring at the msgwait(). Like Richard's problem, your database is being closed and then the program is erroring out in the browse when it attempts to skip, probably when redisplaying the browse after the msgwait() display ...

Harvey,

An idea just came to me. Rather than your msgwait() I would write that same info to an audit file (especially since it is an accounting app). Such an audit file also helps in troubleshooting code problems. You can also have an option in the program to turn auditing on and off.

James

Harvey, First, I don't see any database objects--where is it? Second, I do see lots of database functions being called without aliasing. This is very risky. There are a number of function calls and any one of them may be changing the workarea or closing the database. Using a database object eliminat...

Yes odbf. The error ocurrs at the msgwait() line. Makes no sense and only occasionaly happens. Here is the function where the error occurs. Nothing makes sense. No skip jsut bails out. Not often. Message wait at bottom of code produces the error. static function combine(mconscomp)   local mt...

Rao, Richard is using setRDD() because he is not using a database object. Harvey is using a database object--or at least it appears so from his error message. Perhaps he will confirm or deny this. Your point about MDI is helpful, but in this case Richard says the error has only been occuring occasio...

Let me point out two possibilities: 1. If he is using he should use oBrw:SetoDbf( oDbf ) and definitely not SetRDD() 2. if the browse is created in a window ( other than main window ) and the dbf or odbf is closed after ACTIVATE WINDOW statement this error occurs. Because the dbf is closed even befo...

Richard, OK, I tried something different. I tried to recreate the error by modifing TXBrowse(). First I tried splitting the default line between the bGotop and bSkip and closed the database between the lines. I got a differnt error.   Error description: Error DBCMD/2001  Workarea not in use: RDDNAME...

Richard, OK, that is the one you posted earlier. I am not exactly sure what that means. It doesn't make sense that it was in the setRDD() when it crashed because that would mean that the browse was never initialized. I don't see how this could happen because the file was just opened and no other fun...

james here it is below Error occurred at: 12/10/2009, 14:07:09 Error description: Error DBCMD/2001 Workarea not in use: DBSKIPPER Stack Calls =========== Called from: => DBSKIPPER(0) Called from: C:\PRODUCTION\CBATIPROD\xbrowse.prg => (b)TXBROWSE:SETRDD(3312) Called from: C:\PRODUCTION\CBATIPR...

Richard,

>The error.log shows this line

Please post that section of the error log.

James

Harvey,

SetRRD() does (amoung other things) sets the codeblocks you see in Richards last message.

Since you are using a database object you need to call setoDBF(oDBF) instead.

James

The error.log shows this line