|
Posted by fig000 on 10/18/05 22:58
Hi,
I have an application that's running fine on development servers (web
and database-sql server 2000). I'm updating a record through a third
party component but I don't think the component is the problem. What's
happening is that I'm updating fields that are part of view. I'm only
updating fields in one table of the view and this works fine in the
development environment.
What happens in the production environment when I try to update
(using the third party component) I get the following message:
"Current recordset does not support updating. This may be a limitation
of the provider or of the selected locktype."
As an experiment I took the same code but removed the view, leaving
only the table I want to update as the record source. In that case the
update worked. So it seems that something in the production database
doesn't like me updating a view. However I can do that in the database
in the development environment.
The third party component is dbnetgrid which works fine in the
development environment. I can only conclude it's something about the
database that prevents me from updating this same table if it's in a
view. I've talked to our DBA but he says there's no difference between
the databases. Any ideas would be appreciated.
Neil
Navigation:
[Reply to this message]
|