To include possibility of update of the data received by you at execution of any SQL-query to you it is necessary to open properties of the program. Find on dialogue item Allow Update (fig. 1) and put on it a tick. Press then the button Apply and close a window of properties of the program. After that open the SQL-query and fulfil it to receive result in a browser of the data. On bar of data access (fig. 2) you will see the button of update of the data which all over again will be not accessible. Edit data fields necessary for you. After move to other data field or other data rows you will remark, that the button of update of the data became accessible (fig. 3).
You can update the data by means of the button of change of the data as shown in fig. 2. The Update button is unavailable to default until then while you do not change any values in the data received by you.
It is necessary to notice, what not all types of providers OLE-DB allow to update the data. And also you cannot update the data received from different connected sources and limited at a level of the data source constraints or triggers.
Technical support:
E-Mail: support@visualsoftru.com
WWW: Web support
