Unable to locate rows for updating

From: J Arty (jarty67_at_hotmail.com)
Date: 05/31/04 

Date: Mon, 31 May 2004 09:50:37 -0500

Hi,

Using Delphi 7, ADO, MSDE 8

I have a master detail invoice form where the user selects the customer,
employee etc.. before allowing inserts of the details info I post the master
so the detail can have the invoice number and set a bookmark on the
master...

I then allow user to enter detail info, and use the bookmark to update a
field Total invoice in the master after each detail...

My problem is when I try to delete an invoice I get the error "Unable to
locate rows for updating"... I tried using the bookmark but still get same
error... when I try to insert a new master record, after deleting...

Thanks for the help

Relevant Pages

  • Re: Sequential Numbering from Blank Document (k)
    ... I understood that from a master file (as an example, Invoice Master), you ... > Private Sub Workbook_Open ... Sub SequentialNumber() ...
    (microsoft.public.mac.office.excel)
  • Re: In-Memory Dataset
    ... - User clicks Create New Invoice ... - Detail foreign key is temporarily set to -1 (same as master ... I have to post master dataset BEFORE posting detail ... which should UpdateBatch everything at ...
    (borland.public.delphi.database.ado)
  • Re: Unable to locate rows for updating
    ... >I have a master detail invoice form where the user selects the customer, ... ADO needs to be able to find the record in your database to delete. ... Your choices are adCriteriaKey, adCriteriaAllCols, ...
    (borland.public.delphi.database.ado)
  • Master/Detail Databinding issue
    ... I have an invoice entry form, which is a simple Master fields / Detail grid. ... which is bound using a BindingSource. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Master Documents
    ... Note that master documents tend to corrupt, which is why most people in this ... Enter at the beginning of a bookmarked paragraph, ...
    (microsoft.public.word.docmanagement)