Re: Problems with Oracle ODBC calls from Lotus Scripts
From: Terrance A. Crow <tacrow_at_ix.netcom.com>
Date: 1997/03/28
Message-ID: <5hfevc$mgd_at_mtinsc03.worldnet.att.net>#1/1
Date: 1997/03/28
Message-ID: <5hfevc$mgd_at_mtinsc03.worldnet.att.net>#1/1
My turn to be sorry. My initial response was vague. What I mean is that I've found it necessary to issue an extra:
Call result.Execute()
before I change the SQL property of the ODBCQuery:
qry.SQL = "SELECT * FROM MyDSN"
Otherwise, I've gotten inconsistent results. Like I said, I got into this habit with Notes 4.01, and the condition that forced me to do this may have been corrected in 4.5 -- I just haven't had time to test it.
Hope this helps.
"Allan" <allansg_at_post1.com> wrote:
>Sorry for the lack of info ... I'm using Notes 4.5 and Oracle 7.3 server.
>Btw ... can I know what do u meant by resetting the SQL property ?
>Allan
Received on Fri Mar 28 1997 - 00:00:00 CET