Subject | Re: [IBO] Record was not located to update |
---|---|
Author | Jason Wharton |
Post date | 2001-08-07T17:07:59Z |
I'm not 100% in touch with this thread yet but I need to clarify something
here.
If you have a dataset and you have inserted a record and posted it, you can
subsequently edit it and post it just fine even if the insert is not
committed. You just have to be in the same transaction and then everything
works just fine.
Also, even in cached updates I allow an inserted record to be edited. Is all
it does is replace the record in the cache with the new version edited.
Then, when they are applied it is simply applied as a single insert and not
and insert and then an edit.
If you are having this problem it most likely has to do with something
taking place between the time the inserted record was posted and edited.
Either a trigger as updated a column used in a where clause of the edit
operation or something is getting confused on the buffers on the client.
The SQL trace of such a situation will most likely tell you exactly what the
problem is. Without this there is really not much more I can determine at
this point.
What I would really like is if you can send me a sample that will duplicate
your issue. Otherwise I would be years figuring it out.
Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
here.
If you have a dataset and you have inserted a record and posted it, you can
subsequently edit it and post it just fine even if the insert is not
committed. You just have to be in the same transaction and then everything
works just fine.
Also, even in cached updates I allow an inserted record to be edited. Is all
it does is replace the record in the cache with the new version edited.
Then, when they are applied it is simply applied as a single insert and not
and insert and then an edit.
If you are having this problem it most likely has to do with something
taking place between the time the inserted record was posted and edited.
Either a trigger as updated a column used in a where clause of the edit
operation or something is getting confused on the buffers on the client.
The SQL trace of such a situation will most likely tell you exactly what the
problem is. Without this there is really not much more I can determine at
this point.
What I would really like is if you can send me a sample that will duplicate
your issue. Otherwise I would be years figuring it out.
Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com