Beginner question:

I have a stored procedure to search for a data and another procedure to update the data using the results from the search.

This is the Search Procedure:

PROCEDURE BUSCAR_LOTE_GESTION(P_NUM_TERM IN NUMERIC, P_FLECHA OUT t_cursor) AS BEGIN BEGIN OPEN P_FLECHA FOR SELECT TO_CHAR(MIN(X.FECHA_HORA),'YYYY-MM-DD') F_INICIAL ,TO_CHAR(MAX(X.FECHA_HORA),'YYYY-MM-DD') F_ULTIMA ,X.COD_AGENCIA, X.COD_SUCURSAL,X.OFICINA COD_POS ,X.LOTE ,CASE WHEN X.TRANSFER = 'P' THEN 'PENDIENTES' WHEN X.TRANSFER = 'T' THEN 'CERRADAS X SUBIR' END ESTATUS , COUNT(*) TOTAL_FACT, NVL(SUM(X.MONTO), 0) TOTAL_GESTION, NVL(SUM(CASE WHEN X.FORMA_PAGO = 1 THEN X.MONTO ELSE 0 END), 0) EFECTIVO, NVL(SUM(CASE WHEN X.FORMA_PAGO = 3 THEN X.MONTO ELSE 0 END), 0) CHEQUE, NVL(SUM(CASE WHEN X.FORMA_PAGO = 2 THEN X.MONTO ELSE 0 END), 0) TARJETA FROM TRANSACC_INGENICO X WHERE X.OFICINA = P_NUM_TERM AND X.TRANSFER IN ('P','T') GROUP BY X.COD_AGENCIA, X.COD_SUCURSAL ,X.OFICINA ,X.LOTE ,CASE WHEN X.TRANSFER = 'P' THEN 'PENDIENTES' WHEN X.TRANSFER = 'T' THEN 'CERRADAS X SUBIR' END ORDER BY F_INICIAL; END; END BUSCAR_LOTE_GESTION;

And this is the update procedure:

PROCEDURE ACTUALIZA_GESTION(P_NUM_TERM IN NUMERIC, P_NUM_LOTE IN NUMERIC) AS BEGIN UPDATE TRANSACC_INGENICO X SET X.TRANSFER = 'T' WHERE X.OFICINA = P_NUM_TERM AND X.LOTE = P_NUM_LOTE AND X.TRANSFER = 'P'; END ACTUALIZA_GESTION;

So, what i want to know is how can i create a form in with a search button in vb that displays the results from the search procedure, and then, with the results, to be able to select the row that i want from the results with an update button, that calls the other procedure that updates the status from P to T of the row.

Any help is greatly appreciated