UPDATE Statements
To modify existing records, use UPDATE statements.
Update Syntax
The UPDATE statement takes as input a comma-separated list of columns and new column values as name-value pairs in the SET clause, as shown in the following example:
UPDATE <table_name> SET <select_statement> | {<column_reference> = <expression> [ , ... ]} WHERE { Id = <expression> } [ { AND | OR } ... ]
<expression> ::=
| @ <parameter>
| ?
| <literal>
You can use the ExecuteNonQuery method to execute data manipulation commands and retrieve the rows affected, as shown in the following example:
C#
String connectionString = "SubscriptionKey=test;CountryVersion=2021.R2.AU;CompanyFile=Q:/CData Software.QBW;User=test;Password=test;InitiateOAuth=GETANDREFRESH;CallbackURL=http://localhost:33333;OAuthClientId=MyOAuthClientID;OAuthClientSecret=MyOAuthClientSecret;"; using (ReckonAccountsHostedConnection connection = new ReckonAccountsHostedConnection(connectionString)) { int rowsAffected; ReckonAccountsHostedCommand cmd = new ReckonAccountsHostedCommand("UPDATE Customers SET Name='Hook, Captain' WHERE Id = @myId", connection); cmd.Parameters.Add(new ReckonAccountsHostedParameter("myId","10456255-0015501366")); rowsAffected = cmd.ExecuteNonQuery(); }
VB.NET
Dim connectionString As [String] = "SubscriptionKey=test;CountryVersion=2021.R2.AU;CompanyFile=Q:/CData Software.QBW;User=test;Password=test;InitiateOAuth=GETANDREFRESH;CallbackURL=http://localhost:33333;OAuthClientId=MyOAuthClientID;OAuthClientSecret=MyOAuthClientSecret;" Using connection As New ReckonAccountsHostedConnection(connectionString) Dim rowsAffected As Integer Dim cmd As New ReckonAccountsHostedCommand("UPDATE Customers SET Name='Hook, Captain' WHERE Id = @myId", connection) cmd.Parameters.Add(New ReckonAccountsHostedParameter("myId", "10456255-0015501366")) rowsAffected = cmd.ExecuteNonQuery() End Using