Board index » delphi » Post error on second access of record

Ted Hale

Delphi Developer
Sat, 07 Feb 2004 20:08:30 GMT

Post error on second access of record

I have an application that works well.  In the BeforePost routine the app
checks for several things and posts if all is well.

The problem comes in if a user discovers he/she mistyped some information
and wants to correct it.  They use the Navigator to update the record, make
the change and receive an error saying the rowset can't be found for
updating.  Has anyone come accross this?

Ted

 
Brian Jone

Delphi Developer
Sat, 07 Feb 2004 20:53:57 GMT

Re:Post error on second access of record


Ah - Sql-Server no doubt. You must have a unique index on a Sql-Server
table, otherwise it can not be updated. If the table design doesn't require
it add an identity and use that as the primary instead.

--
Adroit Software Ltd
------------------------------
Remove the nospam. to mail me direct

Quote
"Ted Hale" <t...@srs-inc.net> wrote in message news:3b82509a$1_2@dnews...
> I have an application that works well.  In the BeforePost routine the app
> checks for several things and posts if all is well.

> The problem comes in if a user discovers he/she mistyped some information
> and wants to correct it.  They use the Navigator to update the record,
make
> the change and receive an error saying the rowset can't be found for
> updating.  Has anyone come accross this?

> Ted

Brian Bushay Team

Delphi Developer
Sun, 08 Feb 2004 11:47:19 GMT

Re:Post error on second access of record


Quote
>The problem comes in if a user discovers he/she mistyped some information
>and wants to correct it.  They use the Navigator to update the record, make
>the change and receive an error saying the rowset can't be found for
>updating.  Has anyone come accross this?

The default behavior for ADOExpress is to locate the record to update on all the
field values.  If you have default values set in the database or fields that get
updated as a result of a trigger the record will not be found on subsequent
access  and you will get this error until your requery the data.

You can change this to use only the key fields
 set the 'Update Criteria' dynamic property:-

ADODataSet1.Properties['Update Criteria'].value :=adCriteriaKey;
put this code in the BeforeUpdate method.
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Ted Hal

Delphi Developer
Sun, 15 Feb 2004 12:56:18 GMT

Re:Post error on second access of record


Thanks I'll try that.  My current workaround was to refresh the dataset.
Limited # of records made it fast enough though there had another way...

Thanks again

Ted

"Brian Bushay TeamB" <BBus...@Nmpls.com> wrote in message
news:p976otslbaqh30c50k2iage968h711i1n9@4ax.com...

Quote

> >The problem comes in if a user discovers he/she mistyped some information
> >and wants to correct it.  They use the Navigator to update the record,
make
> >the change and receive an error saying the rowset can't be found for
> >updating.  Has anyone come accross this?

> The default behavior for ADOExpress is to locate the record to update on
all the
> field values.  If you have default values set in the database or fields
that get
> updated as a result of a trigger the record will not be found on
subsequent
> access  and you will get this error until your requery the data.

> You can change this to use only the key fields
>  set the 'Update Criteria' dynamic property:-

> ADODataSet1.Properties['Update Criteria'].value :=adCriteriaKey;
> put this code in the BeforeUpdate method.
> --
> Brian Bushay (TeamB)
> Bbus...@NMPLS.com

Matt Jaco

Delphi Developer
Mon, 16 Feb 2004 16:14:17 GMT

Re:Post error on second access of record


The standard ADO solution to this problem is Update Resync, but
refreshing the dataset manually works are well (as you found out). If
refreshing is already working for you, then that's the solution.

--

My reply-to address is purposely mangled to thwart auto-reply bots.
Please remove the two leading underscores if you wish to reply via
e-mail.

Other Threads

1. ADO 2.0 Open Record Set - Second Post

2. I don't get '...another user has changed the record'(second post)

3. Problem putting a query into Access and strange problem (second post)

4. Update an record needs 40 Seconds with Access 97

5. How to get the second error message (second request for help)

6. Error during post of new record

7. Record/Key deleted error--on post?

8. SECOND POST how to cancel SMTP.Send method

9. D4 & TimageList second post

10. TGraphicControl Management - Second Post, Anyone Please?