Search results

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

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 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...

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...

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

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...

Hello! How removing last character of a string? Sample : Requisição : 7062298 7066083 - 7067325 - 7076260 - 7084470 - Requisição : 7078230 7078233 - 7078236 - 7078240 - 7078244 - 7078250 - 7078255 - 7078258 - 7078259 - 7078262 - 7078267 - 7078268 - 7078272 - 7079844 - 7079847 - 7079856 -...

How do I insert a file into a progress table?

How do I do to convert it to XML...

I have an record in database oracle field that access by the Progress 4GL which was recorded by using a C# GZIpStream component. How to redeem this field, using only resources from Progress 4GL?