Devart Forums

Hi there,

I have a problem when appending a new record in an Access View with UniQuery. I get the following error message:

Operation must use an updateable query.

Updating records works without any problem.

With ADOquery the appending worked without any problem.

What property should I set in Uniquery or in the Uniconnection that the appending of records in the view will work again.

Best regards

Hello,

To modify data retrieved from View, you should specify the correct data modification queries in the SQLInsert/SQLUpdate/SQLDelete properties of TUniQuery. For automatic generating of such queries, you can use the UniQuery editor. For this, open the editor by double-click on the component, go to the 'SQL Generator' tab, specify the name of the table you need to modify in the 'Table Name' combobox, select the needed operations, and click the 'Generate SQL' button.