D Space Posted November 8, 2007 Share Posted November 8, 2007 I have a reasonably simple application that links to a SQL Server database. I am trying to update a single field in SQL from a portal and get the message: ODBC Error For Update cannot be specified on a READ ONLY cursor. I cannot see anywhere that I have declared the connection to be read-only. I'm aware of all the statements that FM should not be used as a front-end to SQL, but this is a pretty simple app. I would greatly appreciate any suggestions. Thanks. Link to comment Share on other sites More sharing options...
D Space Posted November 8, 2007 Author Share Posted November 8, 2007 Never mind - I was linking to a SQL view and the view contained "Distinct" so it was not updatable. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6148 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now