Howto limit the select output with VDB7?

Article View: borland.public.vdbase.data.sql

Article #310

Back to borland.public.vdbase.data.sql Previous Next

#310

From: Joerg W.
Date: Wed, 30 Dec 1998 00:00

11 lines
907 bytes

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?

Thanking you in advance
Joerg W.

Technical Details

Message-ID: <76cufd$qlm3@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,5c7a3913fde8377e,start
X-Google-Attributes: gidff5a1,public
From: "Joerg W." <tvt-huerth@netcologne.de>
Subject: Howto limit the select output with VDB7?
Date: 1998/12/30
Message-ID: <76cufd$qlm3@forums.borland.com>
X-Deja-AN: 427070266
Organization: Another Netscape Collabra Server User
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Newsgroups: borland.public.vdbase.data.sql