I don't know if this is related but we have a complicated query that runs on UniODBC (UniData 5.1). Most of the time it take two or three minutes to run but about one occasion in four it will return pretty much immediately with no records, even although there should be records.
Similar to the code Simon has inherited we time the query and if it runs in under 10 seconds run it again. Peter Welsh Senior IT Development Officer NHSAC -----Original Message----- From: Simon Carter [mailto:[EMAIL PROTECTED] Sent: 10 August 2005 11:36 To: [email protected] Subject: RE: [U2] Failure of Uniobjects subroutine call Sunny, Hi. I second the point made about the inadvertant date conversion (sorted by a one line execute in your called subroutine). I 'inherited' a VB app that uses the subroutine object: interestingly, one of my predecessors had set the call in the code, and if the returned error property wasn't 0, repeated the call. I've never bothered changing it, but I was told that sometimes the call to the sub drops dead for no reason, and this was the way round it. Just a thought! Regards, Simon > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Sunny Matharoo > Sent: 10 August 2005 08:35 > To: [email protected] > Subject: [U2] Failure of Uniobjects subroutine call > > > Hi, > > I wonder if anyone has had a problem with UniObjects calling > a MV database program, on a few occasions we have come across > the scenario where the call is made to the routine, > parameters passed correctly if required, but the expectant > result is not forthcoming. > > Simple example we pass a date parameter to a UV program get > it to execute a select statement and build a list of ids and > return that to > the calling VB program, but we get nothing back. Now running this in > UV at TCL produces the right results. > > Any ideas most welcome. > > Thanks > > Sunny Matharoo > Development Team Leader > > Tristar Worldwide Chauffeur Services > > Tel: +44 (0) 1895 432074 > Fax: +44 (0) 1895 432098 > E-mail: [EMAIL PROTECTED] > www.tristarworldwide.com ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
