Fetching data problem...

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Rami" <a@xxxx>
Date: Wed, 7 Nov 2007 13:10:32 +0100

Hi,
When I'm using ODBC SQLFetch method in my code it retrieves data using
database cursor. In fact it calls sp_opencursor in DB. Is it possible to
retrieve data without using cursor? What is the fastest way to fetch data?
I'm afraid of using cursor because of the performance. Do you have any
suggestion? (I'm using SQL Server 2000).

Regards,
Radek

.

Prev by Date: Re: ODBC Tracing with Vista
Next by Date: Re: Two different dsns return the same dataset
Previous by thread: Re: Access query
Next by thread: Re: Two different dsns return the same dataset
Index(es):
- Date
- Thread

Relevant Pages

Fetching data problem....
... When I'm using ODBC SQLFetch method in my code it retrieves data using ... database cursor. ... retrieve data without using cursor? ...
(microsoft.public.sqlserver.odbc)
Re: I really hate .NET especially inside Delphi
... Nick Hodges (Borland/DTG) wrote: ... Its not a database cursor - but it performs the same. ...
(borland.public.delphi.non-technical)