Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Block Cursor

2 posts in General Discussion Last posting was on 2003-06-04 19:22:35.0Z
Matthew_Curry Posted on 2003-06-04 19:22:35.0Z
From: Matthew_Curry
Date: Wed, 4 Jun 2003 15:22:35 -0400
Newsgroups: ianywhere.public.general
Subject: Block Cursor
Message-ID: <598B2445104EF065006A703985256D3B.006A704785256D3B@webforums>
Lines: 12
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:1156
Article PK: 3401

Does any one have examples of the SQLFetchScroll function and Block
Cursors. I am trying to do something similar to the wide fetch in ODBC. I
checked out the MSDN and it really didn't seem like too much help.

I am looking for a way to imitate the limit function in mySQL or SQL Server
through an ODBC connection to ASA.

thanks,

Matthew Curry
Software Developer
Trans-soft Inc


Glenn Paulley Posted on 2003-06-04 19:21:22.0Z
Date: Wed, 04 Jun 2003 15:21:22 -0400
From: Glenn Paulley <paulley@ianywhere.com>
Reply-To: paulley@ianywhere.com
Organization: iAnywhere Solutions
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2.1) Gecko/20021130
X-Accept-Language: en-us, en
MIME-Version: 1.0
Subject: Re: Block Cursor
References: <598B2445104EF065006A703985256D3B.006A704785256D3B@webforums>
In-Reply-To: <598B2445104EF065006A703985256D3B.006A704785256D3B@webforums>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <#j3Cy9sKDHA.317@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: vpn-dub-194.sybase.com 10.22.120.194
Lines: 25
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1157
Article PK: 3402

SELECT TOP n?

Glenn

Matthew_Curry wrote:
> Does any one have examples of the SQLFetchScroll function and Block
> Cursors. I am trying to do something similar to the wide fetch in ODBC. I
> checked out the MSDN and it really didn't seem like too much help.
>
> I am looking for a way to imitate the limit function in mySQL or SQL Server
> through an ODBC connection to ASA.
>
> thanks,
>
> Matthew Curry
> Software Developer
> Trans-soft Inc

--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer