Re: Incremental queries?

Posted in 2005

Irwin Goldstein — Thu, 16 Jun 2005 12:01:48 -0500 — source: Usenet: comp.databases.informix

I'm pretty sure cursors are not supported under ADO.NET. ADO.NET is a "disconnected" framework. Query results are fetched and maintained locally at the client as an XML file. To get cursor type functionality (inlcuding locking) you'll have to use plain old ADO rather than ADO.NET. You might get better results posting this to a .NET and/or Visual Studio related newsgroup. HTH -- Irwin Goldstein Objective Software Systems, Inc. <rtomas@LUCENT.COM> wrote in message news:1118776233.453214.76560@g43g2000cwa.googlegroups.com... >I should have included more information about our application. It is a > Microsoft Windows application that is written in C# and uses ADO.NET. > I'm fully aware of cursors (a HOLD CURSOR would be just the ticket) but > I'm not sure we have any such construct available through ADO.NET > (although I'm not 100% sure about that). So I'm looking for some other > strategy for querying individual blocks of rows. We are currently > making use of the "SELECT FIRST n" syntax when we construct our SQL > statement. >

↪ replying to Irwin Goldstein

rtomas@LUCENT.COM — 16 Jun 2005 16:17:41 -0700 — source: Usenet: comp.databases.informix

> I'm pretty sure cursors are not supported under ADO.NET. Thanks for confirming what I thought was the case. -Roger