SoftadminApi.Multirow_Parse

Parses and validates text data ('¤' separated) from a multirow control and stores it in a table.

You will usually never call this procedure unless another field has a control dependency on a multirow, as the default way of passing multirows to an InsertUpdate procedure is as a temporary table and not as a ¤-separated string.

Example

CREATE TABLE #Order
(
	ArticleId int NULL,
	APrice numeric(19,5) NULL,
	Amount int NULL,
	Price numeric(19,5) NULL
)

EXEC SoftadminApi.Multirow_Parse
	@TableName = '#Order',
	@Values = '12¤3.99¤10¤39.9¤6¤1.99¤1¤1.99'

SELECT * FROM #Order

or

CREATE TABLE #Order
(
	RowId int IDENTITY,
	ArticleId int NULL,
	APrice numeric(19,5) NULL,
	Amount int NULL,
	Price numeric(19,5) NULL
)

EXEC SoftadminApi.Multirow_Parse
	@TableName = '#Order',
	@Values = '12¤3.99¤10¤39.9¤6¤1.99¤1¤1.99'

SELECT * FROM #Order