Hello
I write Rose script with ODBC connection.
I try three ODBC drivers: Oracle (native), MS ODBC for Oracle,
Intersolv ODBC for Oracle
Only last driver passed through following source:
function getrecid () as long
Dim columns() As Variant
Dim ra() As Variant
exec "select RecIDseq.nextval from dual"
i% = SQLBind(id&,columns,1)
l& = SQLRetrieve(id&,ra)
getrecid = ra(0,0)
^^^^^^^^^^^^^^^^^^ Here "Out of range" error
end function
Sequence declaration is Ok, connection is ok. sequence currval = 3700
and I don't know what's wrong. Please help.
Best wishes,
Lev mailto:[EMAIL PROTECTED]
=====================
Inovex-service. Information systems.
Inovex Web Consulting http://www.inovex.de
Design-cafe. Everything about software engineering.
(in russian only)
http://www.volga.ru/dcafe
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Admin.Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
*
* To: [EMAIL PROTECTED]
* Subject:<BLANK>
* Body: unsubscribe rose_forum
*
*************************************************************************
