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: u2-users@listserver.u2ug.org > 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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/