Skip to content

Latest commit

 

History

History
32 lines (25 loc) · 1.74 KB

MultilineStringInQuery.md

File metadata and controls

32 lines (25 loc) · 1.74 KB

Multi-line literal in query (MultilineStringInQuery)

Description

Multi-line literals are rarely used in query texts, mostly these are error results due to an incorrect number of double quotes.

Examples

In the example below, the selection will have two fields instead of three.

Query = New Query;
Query.Text = "SELECT
|   OrderGoods.Cargo AS Cargo,
|   ISNULL(OrderGoods.Cargo.Code, "") AS CargoCode, // quote error here, should be """"
|   ISNULL(OrderGoods.Cargo.Name, "") AS CargoName
|FROM
|   Document.Order.Goods AS OrderGoods
|WHERE
|   OrderGoods.Ref = &Ref";

Sources