Using SQL in Oi4.x (OpenInsight 32-Bit)
At 16 SEP 2002 10:51:28AM [email protected] wrote:
How can you use SQL against OI tables. I am sure there is a way .. but in look in the archives I have found nothing that works.
Other than speed .. are there any drawbacks known ..
For those of you booing .. and I can hear you .. I moving my Internet Radio Station from PHP/Mysql to PHP/OI I would like to keep as much of the scripting as possible. Since Mysql (as all other relational dbms do) uses Sql I would like to just pass this through.
Compatability Compatability Compatability
Thanks
[email protected] onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"
David Tod Sigafoos ~ SigSolutions
Phone: 971-570-2005
OS: Win2k sp2 (5.00.2195)
OI: 4.1
At 16 SEP 2002 01:12PM Mike Ruane wrote:
Sig-
Call the REV_SQL routine-
Call rev_sql(statement, sqlstate)
where statement is your SQL statement, and sqlstate will return errors and status.
Hope it helps-
Mike
At 16 SEP 2002 01:41PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
DSig,
For more info and example procs on Rev_SQL check out link in the KB
World leaders in all things RevSoft
At 16 SEP 2002 03:10PM [email protected] wrote:
Thanks man .. I looked at the SQL window but had some problems ..
Thanks again
[email protected] onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"
David Tod Sigafoos ~ SigSolutions
Phone: 971-570-2005
OS: Win2k sp2 (5.00.2195)
OI: 4.1
At 16 SEP 2002 03:11PM [email protected] wrote:
2 Answers and a phone call .. cant do any better than that in a day.
Thanks
[email protected] onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"
David Tod Sigafoos ~ SigSolutions
Phone: 971-570-2005
OS: Win2k sp2 (5.00.2195)
OI: 4.1