FiveTech Software tech support forums

... recordset is closing its connection .. I remmed out the oRsVeh := NIL in the _Cleanup() as it should already be NIL. Hopefully this will stop the intermittant error and possible run-time confusion. I will put this mod in production and see if it fails. Rick

Rao The _Cleanup() function occurs after the oRsVeh:Close() //------------------------static FUNCTION _VehClose( lCLEAN, oRsVEH )IF lCLEAN = .T.   lOK := .T.   VEHNUM := oRsVEH:Fields("LICENSE"):Value   FERASE( "C:\DBOVL\VEHNUM.MEM" )   SAVE All like VEHNU...

oRsVEH:CLose()
_CleanUP()

If an error occurs in the function _CleanUP(), naturally you will get into this kind of situation.
Please Try

Code: Select all  Expand view

   _CleanUP()
  oRsVEH:Close()
 

Closing of Rs or any Table browsed should be the very last statement

Unfortunitly this error persists .. Rick Lipkin pplication===========   Path and name: J:\VEHICLE\VEH32.EXE (32 bits)   Size:   946,176 bytes   Time from start: 0 hours 3 mins 53 secs    Error occurred at: 07/10/2009, 15:39:34   Error de...

oBrw:cAlias:=NIL

Not necessary.
Only thing you should make sure that there is no other statement that results in any screen painting after closing the table

Rao Thanks for the quick responce .. I had that statement in the old twbrowse as well and was getting similar errors during a valid close .. //------------------------static FUNCTION _VehClose( lCLEAN, oRsVEH )IF lCLEAN = .T.   lOK := .T.   VEHNUM := oRsVEH:Fields("LICENSE")...

Please remove SysRefresh(). By the time SysRefresh() is called, the recorset is already closed but the window and browse are not yet closed.

To All Receiving a strange intermittant run-time error 'recordcount' ADO from xBrowse FWH 904 on a 'valid' close ... here is the code and error: IF oRsVEH:eof   oRsVEH:MoveFirst()ENDIFcTITLE := "SELECT * from VEHICLES where ...