If you don't want to purchase any third-party software or add-on modules for UV and still code it in BASIC, then the BASIC Call Interface (BCI) is the way to go. Depending on your UV release, you may need to "enable" the UCI/BCI module - later releases it isn't necessary to do (check your UV UCI/BCI Guide).
You have the choice of using a complex SQL update/query syntax or the vastly more simple and far easier path (which I've used) is to call a BASIC subroutine on a remote UV host, as a BCI stored proceedure. This BASIC subroutine on your remote host would be responsible for record reading/locking/updating and the like on that host. Your local host (the client) will be supplying the data and key (of course) as input arguments in the stored proceedure "CALL" statement for either retrieval or updating (as required). Hence, the complex BCI stuff is in your BASIC client application and your BASIC server application is a run of the mill application you code to do the updating/querying (etc). No need need for ODBC drivers, you need to pre-define your local/remote hosts defined in your local or UV account UCI/BCI configuration file. Refer to the BCI manual for examples (or see the UV account BP file, for a program called "CONNECT" - a highly complex real life working example, but more detailed than the manual:)). Regards David -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason Lin Sent: Tuesday, May 01, 2007 7:14 AM To: [email protected] Subject: [U2] Connecting to a remote Universe server in Universe Basic Hi all. Does anyone know what is the easiest way for Universe BASIC programs to access or update records residing on another Universe server? In Visual Basic, this can be done easily using UniObject. But I am surprised that Universe BASIC itself does not seem to have the capability provided by UniObject. ODBC is out of the question because our Universe servers are runing on two HP-UX boxes without ODBC drivers. Our administrators have no plan to acquire ODBC drivers for them. Any information would be greatly appreciated. Thank you. Jason ------- 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/
