Re: Multiple Step Operation


"arper" <support@xxxxxxxx> wrote:
>
>Hi all,
>Anyone know what exactly generates the 'Multiple Step Operation'
>error using MSJet or ADO?

Ones I've received this error when use TAdoTable to insert and edit records.
When I call Post method the Dataset does not become in dsBrowse state. The Dataset was sill in dsEdit or dsInsert State.
And next time I called Append or Edit the error is raised, becasue the Dataset is in dsInsert(dsEdit) state.

If this case is yours - here is workaround:
To edit or Insert DataSet don't use TAdoTable,
instead use TAdoQuery and construct SQL like this:

AdoQuery.Sql.Text := '
Insert into MyTable (MyField)
values ('Test')';

and call AdoQuery.ExecSQL;


.

Relevant Pages

  • Multiple Step Operation
    ... Anyone know what exactly generates the 'Multiple Step Operation' ... error using MSJet or ADO? ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • Re: why can I still edit data when I set the "allowedits" property to
    ... If there is an edit in progress when you set the form's AllowEdits property ... you need a related table to hold the multiple ... The form properties have no apparent control. ...
    (microsoft.public.access.forms)
  • RE: Mulichoice Column Rendering in MOSS
    ... \par As for the multiple select column, I've performed some simple test as below: ... The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support ... These fields are placed in an edit panel and our authors ... \par would like to be able to display items in multiple columns to enhance ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: Change + to -
    ... Place -1 in an empty cell ... Edit, Paste Special, Multiply ... Progression of multiple changes to a constant ...
    (microsoft.public.excel.misc)
  • Re: Create Excel-like view in Access form
    ... If there's a possibility that multiple users could interfere with each ... There's an introductory presentation on Access in a Multiuser Environment ... > temporarily hold the data while they edit it - is the way I usually handle ... > teacher or administrator to try to edit the data at the same time - but it ...
    (microsoft.public.access.forms)