Search found 7 matches: orsveh

Return to advanced search

Re: Intermittant xBrowse ADO error ( again )

... is what is triggering the error. As I suggested before I would try a sysrefresh(). I think the event queue is still holding the oBrw:End() when oRsVEH:Close() is being executed. I don't know why this sort of thing happens, but I have had sysrefresh() solve such problems that seemed to defy logic ...
by James Bott
Sat Aug 08, 2009 5:18 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Intermittant xBrowse ADO error ( again )
Replies: 61
Views: 15718

Re: Intermittant ADO xBrowse error ( thread with Antonio )

... to Access.mdb .. What sets this code apart from the usual .. since this table contains so many rows .. I use a wrapper to call _OpenUM() and the oRsVeh is actually defined static but not initialized until the program runs thru _OpenUM() then I start the browse. I have worked with antonio to modify ...
by Rick Lipkin
Wed Jul 22, 2009 2:04 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Intermittant ADO xBrowse error ( thread with Antonio )
Replies: 11
Views: 4525

Re: Intermittant ADO xBrowse error on valid close

Rao oRsVeh is defined static at the top of the program .. however I was passing it as a paramter within the same .prg especially to _VehClose() .. then the static oRsVeh was being nilled out in _CleanUP() after the local oRsVeh ...
by Rick Lipkin
Sun Jul 12, 2009 9:28 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Intermittant ADO xBrowse error on valid close
Replies: 8
Views: 1541

Re: Intermittant ADO xBrowse error on valid close

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" ...
by Rick Lipkin
Sun Jul 12, 2009 8:50 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Intermittant ADO xBrowse error on valid close
Replies: 8
Views: 1541

Re: Intermittant ADO xBrowse error on valid close

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  RUN

   _CleanUP()
  oRsVEH:Close()
 

Closing of Rs or any Table browsed should be the very last statement
by nageswaragunupudi
Sat Jul 11, 2009 4:06 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Intermittant ADO xBrowse error on valid close
Replies: 8
Views: 1541

xBrowse and a codeblock column

... that I want to convert to xBrowse.. with using the COLUMNS syntax .. I have a code block that returns a value that populates a column. ( DispType( oRsVEH ) ) It is that codeblock that errors and I do not know of a way to return the value I want to display in the specific column .. here is the code ...
by Rick Lipkin
Tue Jun 30, 2009 7:07 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: xBrowse and a codeblock column
Replies: 4
Views: 813

... ID 135 of oGRPS PICTURE "@!" ; when ( xSUPER = 'Y' .or. xADMIN = 'Y'.or. xMGR = 'Y' .or. xTECH = 'Y' ); valid MTRPGET( zMTRPOOL, cMODE, oMTRPOOL, oRsVEH, "VEHICLES", zPOOLID ) UPDATE // mtrpslct.prg //---------------------- Func MTRPGET( cNAME, cMODE, oOBJ, oRs, cTABLE ) LOCAL oDLG,oLBX LOCAL ...
by Rick Lipkin
Fri Dec 14, 2007 2:21 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: How to turn OFF the ESC key ( globally )
Replies: 10
Views: 2703

Return to advanced search