Dave: AFAIR this is documented in the less-than-obvious location of the UCI Guide.
Here is a quick example using local UniVerse SQL in a subroutine as a stored procedure. I've used this with OleDB though not with ODBC, using the SQL CALL statement. NOTE that if you are using ODBC, I've found that {NATIVE} queries are very much quicker that regular ODBC queries. Check out the syntax for the NATIVE statement in the uvodbc guide. GetOrdersForCustomer 0001 SUBROUTINE( CustNo ) 0002 $Include UNIVERSE.INCLUDE ODBC.H 0003 0004 TCL = "SELECT * FROM ORDERS WHERE CUSTNO = " : CustNo 0005 T = SQLExecDirect(@HSTMT, TCL) 0006 RETURN Brian > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Dave Tabor > Sent: 27 July 2005 13:14 > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] UVODBC procedure call from VBScript > > Hi, Mr. Jordan. > > I've been considering using ODBC instead of UniObjects for > our web project, too, but am unfamiliar with . Could you > please include a small, very generic, code snippet to show > what you mean here. It would be much appreciated! > > Thanks, > Dave > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of OZEMAIL > Sent: Tuesday, July 26, 2005 6:21 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] UVODBC procedure call from VBScript > > > To return a recordset from a UniBasic subroutine to an ODBC > call you need to load data into the @HSTMT variable in the > UniVerse Basic Subroutine. > > Regards > David Jordan > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Wednesday, 27 July 2005 6:31 AM > To: u2-users@listserver.u2ug.org > Subject: [U2] UVODBC procedure call from VBScript > > Hi all, > > I'm trying to convert a web app from Sybase to UV. I've been > attempting to get a vbscript app to call a subroutine as a > stored procedure. I am able to connect to the database using > the OLE provider and retrieve recordsets. > I'd like to be able to execute stored procs as well. IBM > provided me with a VB sample to call a subroutine but I can't > seem to implement it in VBScript. I've gone over the docs a > million and one times and still can't seem to see what I'm > missing. Does anyone have any samples, calling a subroutine > through ODBC that would return a rescordset to the script > that they would be able to share ? > > Thanks for any help, > > Vance Forste > -------------------------------------------- > ------- > 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/ > ------- > 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/