BTW, if anyone else is working with Apache Axis, please feel free to contact me offline with any hints / tips / questions.
Best, David Beahm
Tom Firl wrote:
Could Kris use an I-descriptor to call a BASIC SUBRoutine that uses BCI to retrieve the value in the SQL database?
Tom Firl
-----Original Message----- From: David Beahm [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 2:52 PM To: [EMAIL PROTECTED] Subject: Re: [U2] Get External Sql Data Dynamically
BCI doesn't offer quite as tight an integration as that. What it gives you is the ability to read and write to SQL data sources from within UniBasic. For instance, we have a table that exists in MySQL, but we need to access the data from UniData (and for the moment we don't have time to change the user interface to support interfacing with UniData -- besides it made a good test case). Anyway, we were able to execute SQL queries against the external database from within a program. In your case, you might want to write a program that updates a local file with data from the SQL table. Then you can use all your familiar Retrieve logic (I-types, etc.)
HTH, David Beahm
------- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
