Re: [U2] How to adresse OracleClientInterface from UV/Basic
Robert keyway.net> writes: > > Ken, the remote execute feature that you added, sounds awesome. > > Do you capture any error message numbers or error message output and > return it? > > Robert Norman > . > ROBERT NORMAN AND ASSOCIATES > Address: 23441 Golden Springs Dr., #289, Diamond Bar, CA 91765 USA > Phone : (951) 541-1668 > Email : ice keyway.net > Website: http://users.keyway.net/~ice/ > [Affordable UNIVERSE programming services for PICK/BASIC, DATA/BASIC, > UniVerse Basic, UniBasic, R/BASIC, jBC] Yes, we included error messages. Not all but the important ones. Eg. If you try to insert a record into a file that already exists it will fail and display the SQL error text in a dialogue box. Similar if you try to insert a mv'd association into a record but the base file is missing. We built this about 10 years ago and use it to import/export data from our app to other outside apps. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to adresse OracleClientInterface from UV/Basic
Ken, the remote execute feature that you added, sounds awesome. Do you capture any error message numbers or error message output and return it? Robert Norman . ROBERT NORMAN AND ASSOCIATES Address: 23441 Golden Springs Dr., #289, Diamond Bar, CA 91765 USA Phone : (951) 541-1668 Email : i...@keyway.net Website: http://users.keyway.net/~ice/ [Affordable UNIVERSE programming services for PICK/BASIC, DATA/BASIC, UniVerse Basic, UniBasic, R/BASIC, jBC] Ken wrote: Manu Fernandes infodata.lu> writes: Hi group, I'll connect my Universe app to a Oracle system. The Oracle expose a list of PL/SQL functions I'll call to and receive some results. I'm running UV 11.1 on Linux/Suse and OracleClientInterface is installed on the system (OCI is correctly running). Do you have any advice, basic sample, ... ? Thanks by advance. manu ___ U2-Users mailing list U2-Users listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Manu: I developed a feature within my app that lets me run SQL in Universe or outside databases and delivers the results into a Universe file. For SELECT's I execute the Basic CONNECT command with the output file designated and then data in the SQL I want to run. I've also built in the ability to execute commands in the foreign database (eg. DELETE * FROM table;). I used the BCI features that you can find in the "Universe BASIC SQL Client Interface Guide". This will also work when run against the Universe database which lets me run SQL in Universe and then use the results in a process or SB+ report. Hope this helps. Ken ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to adresse OracleClientInterface from UV/Basic
Manu Fernandes infodata.lu> writes: > > Hi group, > > I'll connect my Universe app to a Oracle system. > > The Oracle expose a list of PL/SQL functions I'll call to and receive some results. > > I'm running UV 11.1 on Linux/Suse and OracleClientInterface is installed on the system (OCI is correctly running). > > Do you have any advice, basic sample, ... ? > > Thanks by advance. > manu > ___ > U2-Users mailing list > U2-Users listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > Manu: I developed a feature within my app that lets me run SQL in Universe or outside databases and delivers the results into a Universe file. For SELECT's I execute the Basic CONNECT command with the output file designated and then data in the SQL I want to run. I've also built in the ability to execute commands in the foreign database (eg. DELETE * FROM table;). I used the BCI features that you can find in the "Universe BASIC SQL Client Interface Guide". This will also work when run against the Universe database which lets me run SQL in Universe and then use the results in a process or SB+ report. Hope this helps. Ken ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] How to adresse OracleClientInterface from UV/Basic
Hi group, I'll connect my Universe app to a Oracle system. The Oracle expose a list of PL/SQL functions I'll call to and receive some results. I'm running UV 11.1 on Linux/Suse and OracleClientInterface is installed on the system (OCI is correctly running). Do you have any advice, basic sample, ... ? Thanks by advance. manu ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users