Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Sybase/SQLRouter converts a SELECT to an SQL procedure with a CURSOR on it

7 views
Skip to first unread message

Vladimir Zivota

unread,
Oct 18, 2000, 3:00:00 AM10/18/00
to
Why do SalTblPopulate and SqlPrepareAndExecute behave such way ?

This behaviour drags out communication with server and
probably leads to suppression of a previous T-SQL SET ROWCOUNT command.

It is unwanted. How I could switch this treatment off ?

Or, is it possible to achieve functionality of the SET ROWCOUNT
instruction in this situation anyway?

We are migrating from SQLServer/SQLRouter (16bit) to CTD 1.5.1 and it is
impractical to revise all programs.

Many thanks for advice in advance !


V.Zivota
ziv...@dcb.cz


Viralex

unread,
Oct 18, 2000, 3:00:00 AM10/18/00
to
Use the prepareproc from the library sybsal32.apl
The problem of the rowcount is a lost of context, that can be avoided with
the functions of sybsal32.apl

...But you'll have to revise all programs...

Michel


"Vladimir Zivota" <ziv...@dcb.cz> wrote in message
news:9auBNaNOAHA.1232@cs...

0 new messages