Trying to update SQL via ESS

[D Space]

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.

[D Space]

Never mind - I was linking to a SQL view and the view contained "Distinct" so it was not updatable.