Re: Returning SQLCA values: How?

Koen Van der Elst wrote: > > > Sorry, I don't know PowerBuilder, but surely if you can get access to > > SQLCA.SQLCODE, you can get access to the rest of SQLCA? I know it doesn't > help > > you, but V6 or greater has a builtin function called dbinfo() which will > > help you. > > Using dbinfo from within Powerbuilder works fine, accessing sqlca can be > done. Yes but can I just point people back to the original question? :^) Which was getting at SQLCA in a 5.01 stored procedure. Can't be done. dbinfo is good, but it came out in 6.x or 7.x as Billy said. My advice, check out version 5.16, a lot of the newer features are finding their way into the later 5.x releases. So you might find dbinfo there. If not then look at upgrading to 7.20. Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+