RESOLVIDO: PROXIMA LINHA DO SC_LOOKUP

Formulários
#1

$aP[] = array(
‘nItem’ => {rs[0][0]},
‘cProd’ => “’”.{rs[0][1]}."’",
‘cEAN’ => ‘’,
‘xProd’ => “’”.{rs[0][2]}."’",
‘NCM’ => “’”.{rs[0][3]}."’",
‘NVE’ => “’”.{rs[0][5]}."’",
‘CEST’ => “’”.{rs[0][4]}."’", // Convênio ICMS 92/15
‘EXTIPI’ => “’”.{rs[0][6]}."’",
‘CFOP’ => “’”.{rs[0][7]}."’",
‘uCom’ => “’”.{rs[0][8]}."’",
‘qCom’ => “’”.{rs[0][9]}."’",
‘vUnCom’ => “’”.{rs[0][10]}."’",
‘vProd’ => “’”.{rs[0][11]}."’",
‘cEANTrib’ => ‘’,
‘uTrib’ => “’”.{rs[0][8]}."’",
‘qTrib’ => “’”.{rs[0][12]}."’",
‘vUnTrib’ => “’”.{rs[0][13]}."’",
‘vFrete’ => “’”.{rs[0][14]}."’",
‘vSeg’ => “’”.{rs[0][15]}."’",
‘vDesc’ => “’”.{rs[0][16]}."’",
‘vOutro’ => “’”.{rs[0][17]}."’",
‘indTot’ => “’”.{rs[0][18]}."’",
‘nItemPed’ => ‘’,
‘nFCI’ => ‘’);

Gostaria de saber como faço para pular para a próxima linha da minha query, e popular $aP, com os dados da proxima linha.

#2

use sc_select.

mesmo assim: sc_lookup(ds, query)

$ds[0][0] registro 1 coluna 1
$ds[1][0] registro 2 coluna 1

#3

está me retornando o seguinte erro: Trying to get property of non-object

sc_lookup(rs, $itens);

if (false == {rs}) // Error while accessing database
{
sc_error_message(‘Error ao acessar a base de dados.’);
sc_error_exit();
}
else
{

while(!$rs->EOF)
{
$i = 0;
$aP[] = array(
‘nItem’ => {rs[$i][0]},
‘cProd’ => “’”.{rs[$i][1]}."’",
‘cEAN’ => ‘’,
‘xProd’ => “’”.{rs[$i][2]}."’",
‘NCM’ => “’”.{rs[$i][3]}."’",
‘NVE’ => “’”.{rs[$i][5]}."’",
‘CEST’ => “’”.{rs[$i][4]}."’", // Convênio ICMS 92/15
‘EXTIPI’ => “’”.{rs[$i][6]}."’",
‘CFOP’ => “’”.{rs[$i][7]}."’",
‘uCom’ => “’”.{rs[$i][8]}."’",
‘qCom’ => “’”.{rs[$i][9]}."’",
‘vUnCom’ => “’”.{rs[$i][10]}."’",
‘vProd’ => “’”.{rs[$i][11]}."’",
‘cEANTrib’ => ‘’,
‘uTrib’ => “’”.{rs[$i][8]}."’",
‘qTrib’ => “’”.{rs[$i][12]}."’",
‘vUnTrib’ => “’”.{rs[$i][13]}."’",
‘vFrete’ => “’”.{rs[$i][14]}."’",
‘vSeg’ => “’”.{rs[$i][15]}."’",
‘vDesc’ => “’”.{rs[$i][16]}."’",
‘vOutro’ => “’”.{rs[$i][17]}."’",
‘indTot’ => “’”.{rs[$i][18]}."’",
‘nItemPed’ => ‘’,
‘nFCI’ => ‘’);

$rs->MoveNext();
$i++;

}

$rs->Close();

#4

veja como usar sc_select no web help do sc

essa função não existe para sc_lookup: $rs->MoveNext(); (esse é o objeto invalido assim como o close)

#5

Deu certo Haroldo!!
Muito obrigado.