>How can I append only from current record ?
>
>
>CREATE CURSOR REPORT_PROD ( QUANT N(6), ITEM C(150), CODIGO1 N(10), CODIGO2 N(10))
>
>SELECT ap
>
>SCAN for ap.SIT1 = 4 AND ap.data = d_apu
> SELECT itens
> SCAN FOR itens.id = ap.id2
>
>
> SELECT report_prod && temp. cursor
>
> APPEND FROM itens && I would like to append only from the **current record of table itens, but it is appending from the whole table
>
> ENDSCAN
> ENDSCAN
>
> SELECT report_prod
> BROWSE
>
>
> USE IN REPORT_PROD
CREATE CURSOR REPORT_PROD ( QUANT N(6), ITEM C(150), CODIGO1 N(10), CODIGO2 N(10))
INSERT INTO REPORT_PROD;
SELECT * FROM itens;
INNER JOIN Ap ON itens.id = ap.id2 AND ap.SIT1 = 4 AND ap.data = d_apu
BROWSE
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.