Iniciar uma conversa

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]};


Escolher arquivos ou arraste e solte arquivos
Esse artigo foi útil?
Sim
Não
  1. Amanda Santos (Migrated deleted Agent)

  2. Publicado
  3. Atualizado

Comentários