CData Power BI Connector for SugarCRM 2019 - Online Help
Questions / Feedback?

INSERT Statements

CData Power BI Connector for SugarCRM 2019 - Build 19.0.7354

To create new records, use INSERT statements. This statement can be accessed using the Odbc.Query function in the M formula language.

INSERT Syntax

The INSERT statement specifies the columns to be inserted and the new column values. You can specify the column values in a comma-separated list in the VALUES clause, as shown in the following example:

INSERT INTO <table_name> 
( <column_reference> [ , ... ] )
VALUES 
( { <expression> | NULL } [ , ... ] ) 
  

<expression> ::=
  | @ <parameter> 
  | ?
  | <literal>
The following is an example query:
INSERT INTO Accounts (Industry) VALUES ('Chemicals')

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0