- Site Admin
- Posts: 288
- Joined: 05 Mar 2017, 20:57
- Location: Tauranga, New Zealand <--> Stroud, England
One of the GREAT features of SQLBase Stored Procedures is the ability to traverse Result-sets back and forth . Go here to see how : https://www.banksidesystems.com/gupta-s ... super-hero
BUT SQLServer Stored Procs cannot do this. Whats more , if you are using OLE DB, SQL Server does not even support OUTPUT parameters in a Stored Procedure !
The only way around ( that I know of ) is to make your lovely thinish client into a fat-fat-fat client by moving all the SQL from your Stored Procs onto the client. Then you can FetchNext() and FetchPrev(). Disappointing.
Gupta have nailed FetchNext () , FetchPrev() and FetchRow() from within a Stored Proc. within SQLBase, so think twice if you want to migrate. You have been warned.
Bankside Systems Ltd.
UK ♦ Australia ♦ New Zealand
Who is online
Users browsing this forum: [Ccbot] and 0 guests