Re: Multiple-step Operations Generated Errors

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

Date: 16 Apr 2004 20:04:40 -0700

Brian Bushay TeamB <BBushay@Nmpls.com> wrote:
>
>>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

This is an example. The real name of the field is not 'date'. The problem is the default property. If there are more then one the error is raised.

Thanks anyway

Relevant Pages

  • Re: Cache Size and AsyncFetch
    ... Brian Bushay TeamB wrote: ... form set with the tables via an ADOConnection. ... Asnyc fetching is incompatible with serverside cursors and also with Delphi data ...
    (borland.public.delphi.database.ado)
  • Re: how to deal with multiple result sets in D6 ADO?
    ... Or do you need to extract data and stuff it into a TStrinGrid ... When you run sp_help in the Query Analyzer, ... Brian Bushay TeamB wrote: ...
    (borland.public.delphi.database.ado)
  • Re: TADOQuery master-details
    ... Brian Bushay TeamB wrote: ... >>My program is to extract athletics results from an access database. ... >>TDataSource - DataSourceAV ...
    (borland.public.delphi.database.ado)
  • Re: TADOQuery master-details
    ... Brian Bushay TeamB wrote: ... >>My program is to extract athletics results from an access database. ... >>TDataSource - DataSourceAV ...
    (borland.public.delphi.database.ado)
  • Re: ADO Connection in a Service App
    ... he could run the service under a user account. ... Brian Bushay TeamB wrote: ... >>I use the came exact connection string in my application and it works fine. ...
    (borland.public.delphi.database.ado)