Announcements
Hi , I am trying to create an edit form and when i add filed , under control type i am not getting edit controls. Only View option is showing up. Because of which unable to edit the filed. Any suggestion who to over come this ?
Note : My source is Azure SQL Server
Make sure the SQL database you are trying to edit has an Auto Incremementing Identity field and that the connection account has permission to edit the database. Its pretty common for SQL databases to connect as ReadOnly unless you make sure the database is setup to allow editing through the connector.
Thanks! Added Auto increment column in table and also there was an issue with Database datatype. Fixed them and working as expected.
what was the issue with the database datatype?
I have the same issue. I am unsable to fix it.
THe SQL server allows remote connection.I also have an id column. with INT IDENTITY(1,1)
However, that's still not working
The Auto incrementing Identity key is the primary key.
Please post this as a new question. You'll get more responses and others will be able to find the answer more easily later.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 549 Most Valuable Professional
Kalathiya 225 Super User 2026 Season 1
Haque 224
