Search results

How do I return a default value when my query finds no value in the database?

select * from pub.almo_historico_ressupr where data = SYSDATE it works perfectly. When i add a parameter the ODBC return error.

yes, it works perfectly. My problem is when I add a parameter to the query.

my database = OpenEdge my application: SQL Server

i'm sorry. using sql for execution query in progress.

how do i pass a parameter to sql server for exec query in table progress 4gl Sample: select * from pub.almo_historico_ressupr where data = :datainicial return error: Missing input parameters. Thank you.

I'm connecting via broker. I know you're stuck in a consultation. Follow the code I use. def input parameter c-operacao as character. def input parameter c-broker as character. def output parameter c-status as character. def var c-comando as char. def var c-linha as char. def var l-agentes...

I have a .NET communication with Progress that is done through a broker, agents that connect to the database, and I'm having problems because some agents are getting their connection stuck, and this is overloading the system, leaving it slow. Is there any way to track these where these agents...

This procedure only returns when I leave a table. DEFINE TEMP-TABLE ttProcessos FIELD iProcesso LIKE proc-compra.nr-processo INDEX Proc iProcesso. DEFINE DATASET dsProcessos FOR ttProcessos. DEFINE VARIABLE hdProcessos AS HANDLE NO-UNDO. hdProcessos = DATASET...

I have a problem that is as follows. I have a table, order-purchase, which is being used by a user ... No code type found, no code of any kind, I was wondering if there is a way for me to identify if there is any table allocated without a bank and if it exists, I return an error for my mother...

FIND LAST req_mov WHERE req_mov.req = 7203574 NO-LOCK NO-ERROR. DISP req_mov.seq. Table: req_mov Flags Index Name St Area Cnt Field Name ----- ----------------------- ------- --- ---------------------- index_req_mov_1 8 1 + req...

index_id is the name of index. for exemplo : index_id, index_id_date, index_id_date_uf.

The index is id. FIND LAST table WHERE table.id = 711444 NO-LOCK NO-ERROR USE-INDEX index_id.

My query : FIND LAST table WHERE table.id = 7114445 NO-LOCK NO-ERROR. return : 1 More my table : 1 2 Thank you.

I understand, but it's the same as me taking the comment from find. What I do not understand is why when I shoot the OUPUT comment the application does not return me error. That does not make sense to me.

Thank you, more this not is the problem. :(

If I change the code : IF first-of(tt-atend.hora) THEN DO: CREATE tt-resumo. ASSIGN tt-resumo.dt-trans = tt-atend.dt-trans tt-resumo.turno = tt-atend.turno tt-resumo.hora = tt-atend.hora. END. for ...

Hello guys! My routine is returning an error when commenting the code : /* OUTPUT TO c:\temp\tt-atend.txt. FOR EACH tt-atend NO-LOCK: EXPORT DELIMITER ";" tt-atend. END. OUTPUT TO c:\temp\tt-resumo.txt. FOR EACH tt-resumo NO-LOCK: EXPORT DELIMITER ";" tt-resumo. END. */ if i...