Loading...

Enables displaying and editing data as a text value

Select Value Query

Specifies the Data Query which returns a single value which is set as the initial value of the Text Box.

Example

This example shows a query for displaying the number of units in store for a given product.

SELECT Qty
FROM @Object[Products].DbObjectName
WHERE ProductID = @ProductID

Max Length

Specifies the maximum number of charachters that the user is allowed to enter in the Text Box. The default is unlimited.

Save Data Expression

Specifies the Data Query used for saving data. The query must handle both insertion of a new row and updating an existing one.

Example

This example shows a SQL expression that updates an existing row if it already exists (updates the number of items in store for a specific product), and inserts a new row if it doesn’t exist.

MERGE @Object[Products].DbObjectName AS [Target]
USING(SELECT @ProductID AS Key1) AS [Source](Key1)
ON([Target].ProductID = [Source].Key1)
WHEN MATCHED THEN UPDATE SET [Target].Qty = @FormElementValue()
WHEN NOT MATCHED THEN
INSERT (ProductID,Qty)
VALUES([Source].Key1,@FormElementValue());