Re: error: Cursor not returned from query

Erland Sommarskog wrote:
IW2FIV (carlo.merlini[NONROMPERE]@libero.it) writes:
I'm a really beginner about sql2000.
During my test I have created the following query. It's works ok until I
do't add the code included in section A, when I add it the i obtain the
error: Cursor not returned from query

Apparently you are using some environment unknown to me. At least I
don't recognize the message.

I would suspect that it's some data layer (such as ADO, ADO.NET, DAO,
etc), which has at least two different methods of performing work in
the database - one for performing data retrieval and another (possibly
on another object, if the layer is object oriented) which allows data
manipulation.

For instance, ADO.NET has ExecuteReader and ExecuteNonQuery methods on
it's command object.

Damien

.

Relevant Pages

  • Re: formatting a calculated number field on a form
    ... > I have created a query with a field that calculates ages as described above. ... > problems filtering correctly. ... If, for example, I want to see only patients who ... The principles of tiered architecture tells us to use the data layer to ...
    (microsoft.public.access.forms)
  • Re: formatting a calculated number field on a form
    ... the user to set the filter criteria, but that I should develop my own form for ... >> I have created a query with a field that calculates ages as described ... >> are incorrectly included since the filter is comparing text rather than ... >The principles of tiered architecture tells us to use the data layer to ...
    (microsoft.public.access.forms)
  • Re: sorting twice?!
    ... So I run a query to select the top 20 when ordered by datemodified ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Format a datetime columns output?
    ... Erland Sommarskog wrote: ... You can also do it in an SQL query, look up CASE and CONVERT in Books ... string that looks like a date. ... State what version of SQL Server you are using and specify the content ...
    (comp.databases.ms-sqlserver)
  • Re: Profiler execution warning not document
    ... "Erland Sommarskog" wrote in message ... > The 3 means there is indexed view loaded, and the interger data means ... I don't understand what this has to do with a query that I am running. ... bothering me with an execution warning just to say "hey, ...
    (microsoft.public.sqlserver.programming)