Start a conversation

Get data from a select with the sc_lookup macro

The macro allows sc_lookup is returned in a dataset (two-dimensional Array - row / column):



We can use the following code in the OnLoad event:


where:

'ds' is the array that returns the records.

{ds[0][0]}: line one, column one of the array returning the selected record.

Running:


Returning the value 41.

If you have more than one record in the array, the use shall be as follows:

{ds[0][1]}: first row, second column.
{ds[1][1]}: second row, second column.

example:

{order_id} = {ds[1] [0]};
{product} = {ds[1] [1]};
{quantity} = {ds[1] [2]};


Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Amanda Santos (Migrated deleted Agent)

  2. Posted
  3. Updated

Comments