Re: Multiple-step Operations Generated Errors

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 04/17/04 

Date: Fri, 16 Apr 2004 20:44:12 -0500

>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'

Date is an SQL key word my guess is using Date as a field name is the source of
your problem. 

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com

Relevant Pages

  • Re: Field width
    ... In SQL server the following code will populate AdoDataset1 with the field ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: XP_CmdShell and OLE provider
    ... First is the Foxpro Oledb driver installed on the machine where SQL server is ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: Update Query
    ... >This syntax should work for SQL server and Access ... >Brian Bushay (TeamB) ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • 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: ADO connection
    ... That is not something you can detect with ADO or SQL server ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)