ODBC Driver for Microsoft Dynamics 365

Build 22.0.8462

Modifying Data

The following code examples show how to use data modification statements.

Procedure for Updates

You can use sqlQuery method to execute data modification statements.

INSERT

To insert updates:

sqlQuery("INSERT INTO GoalHeadings(GoalHeadingId) VALUES ('John')")

UPDATE

To retrieve updates:

sqlQuery("UPDATE GoalHeadings SET GoalHeadingId = 'John' WHERE Name = 'MyAccount'")

DELETE

To delete updates:

sqlQuery("DELETE FROM GoalHeadings WHERE GoalHeadingId = ''test''")

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462