🚀 go-pugleaf

In article <76cufd$qlm3@forums.borland.com>,
  "Joerg W." <tvt-huerth@netcologne.de> wrote:
> I'm using SQL Server 6.5 (through ODBC) and VDB7.
> I just want receive only 10 rows in a query.
> SET ROWCOUNT X or SET TEXTSIZE X doesn't work, because
> a query opens a new connection to the Server (ID n+1, SPID n+1)
> and settings in the connection before are ignored.
> VDB doesn't accept a sql string in a query like query1.rowset.sql="set
> rowcount 10 select * from table".
> Is there a way to handle this?
>
When using the following SQL in the ODBC Test tool through the MS SQLServer
driver

set rowcount 10; select * from test; set rowcount 0

I got 10 results back. Basically this problem can be caused by two
possibilities: 1) the version of your driver will not allow this. This can be
seen at the error message that comes back.. it says something like
[SQLServer] in the errormessage. If this should be the case I suggest
upgrading to for example version 3.5 of the driver (this is the version that
I got) 2) the VDB is parsing the SQL statement and decides this is not
correct according to his standards. Check the application to find out if
there is the possibility to turn this parsing off.

Toffie.

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own