Multiple-step Operations Generated Errors

From: Emile Petrus (emile_at_think.com.br)
Date: 04/16/04 

Date: 16 Apr 2004 07:26:54 -0700

SQL Server 2000 - TADODataSet

Create table client (id int identity (1,1),
                     name varchar(100),
                     date datetime default (getdate()))

When I try to insert a new record the SQL Server must return two values: new id and the date.

It is work fine if CursorLocation property is clUseServer.

If I use CursorLocation = clUseClient then it is raised the message 'Multiple-step Operations Generated Errors'

Relevant Pages

  • Re: Best way to find ID of new record
    ... When I get back to the program using SQL Server, I'll try the adUseServer ... I did not specify (knowingly) ... the CursorLocation property and adOpenKeyset for the CursorType property, ...
    (microsoft.public.data.ado)
  • Re: Multiple-step Operations Generated Errors
    ... >When I try to insert a new record the SQL Server must return two values: ... >It is work fine if CursorLocation property is clUseServer. ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: Best way to populate webpages from multiple tables
    ... tables within hash tables, custom classes etc. ... > Set a session expiring cookie at the client that stores the Customer ID. ... > send it to the client, instead store it in your session mgmt sql server - ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Best way to populate webpages from multiple tables
    ... tables within hash tables, custom classes etc. ... > Set a session expiring cookie at the client that stores the Customer ID. ... > send it to the client, instead store it in your session mgmt sql server - ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL and Bandwidth use
    ... In addition to the other responses, take a look at the memory and CPU usage ... in Great Plains Client software. ... > near 100Mb/sec bandwidth). ... Client PC is on same segment as SQL server (not passing through ...
    (microsoft.public.sqlserver.server)