checking for error following an UPDATE

From: Terry (cooleyt_at_woh.rr.com)
Date: 03/26/04 

Date: Fri, 26 Mar 2004 14:49:59 -0500

Using D6, Microsoft access database and ADO

Using an adocommnd.execute with an UPDATE string in the command text. the
WHERE clause indicates the record to update. I expected to get an error if
no match was found for the parameters in the where clause, but I did not.
Is there a good way to check for this case? I would like to report an error
on this condition.

Relevant Pages

  • Re: checking for error following an UPDATE
    ... >Using an adocommnd.execute with an UPDATE string in the command text. ... >no match was found for the parameters in the where clause, ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Re: Update problem ADO vbnet 2005
    ... due to optimistic record locking. ... scotty, before executing the .Update command, determine what the SQL ... text of the command is. ... Where clause is so specific that it fails to find the record to update, ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Limit on Access where clause?
    ... Microsoft Access query specifications Attribute Maximum ... Number of characters in a cell in the query design grid 1024 ... Access had a limit of 99 fields in the where clause. ... a select command that retrieves rows to a OleDbDataAdapter dataset? ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Question about replace and _tally
    ... but it also returns the totat reccount. ... It seems if you do not use a function in the replace clause it returns the ... > command using _TALLY, but I am getting unexpected results. ... > me" $ MyField ...
    (microsoft.public.fox.programmer.exchange)
  • Re: adCriteriaAllCols and text columns
    ... The text, ntext, and image data types cannot be compared or sorted, except ... However, with ADO ... > clause whereas the BDE would use all columns in the where clause. ... > notes and posts the changes whilst user2 is looking at the original notes. ...
    (borland.public.delphi.database.ado)