Thanks. I also have another question: How can I to put data-time into where clause , something like this:
For each mytable where (create_date + create_time) > "05/29/2009 14:22:24"
display
fileld1
filed2
string(create_date, "99/99/9999" ) + " " + string(create_time, "hh:mm:ss")...
I ran your code, burt received another error
"Incompatible data types in expession or assignment. (223)
Could not understand line 3. (196)"
If I comment the line with (if active ... the code runs fine.
Hi,
I am trying to convert all "yes" to 1 and all "no" to 0 in a case statement.
Here is my code:
for each prospect where:
display
prosp_id
name
address
active
case active:
when "yes" then 1.
when "no" then 0.
end case.
skip.
end
However I receive a message "Line2. Colon followed by...
Hi all,
My questions probably sound too primitive, but I am relatively new to Progress and I found some problems while deveoping 4GL code for it.
Generally speaking, I am creating a dump file from a Progress table with pipe-separated columns.
Here is what I am doing:
for each prospect...
Hi, I need to perform a cross-tab of data in Progress 4GL.
I have a table like this, it's called sales:
seq city date sold
----------------------------
1 New York 02/01/07 123
1 New York 03/01/07 125
1 New York 04/01/07 128
1 New York 05/01/07 132
1 New York 06/01/07 140
1...
Thanks Rrojo, but RUN command is to call it from Progress or Unix ? I tried to RUN it from Unix (ksh shell), but received a message ksh: run: not found.
My procedure is not stored in Progress database, it is saved in Unix, actually it is a script not a procedure, and I have to call it from...
Hi,
I relatively new to Progress. I wrote a Progress 4GL procedure which is actually a script saved in OS (not in database). Now I need to change it to accept input parameters.
Can someone point to an example or paste code snippet here ?
Thanks.
Elliot,
This is actually not so bad news, we have SQL Server 2000 in our environment as well, so if it is impossible to connect Progress to 2005 I am going to do it to 2000 and then upgrade with detach/attach or backup/restore to 2005.
So let me ask you the next question: how to connect to...
Hi,
I have to migrate our existing Progress databases to SQL Server. As far as I know there are so called ODBC drivers (or something like that) that may help in such migration to move data from Progress to SQL Server.
My environments are :
Progress version 9.1e running on Unix.
SQL Server 2005...
Hi, I am new to Progress and I need to convert the following SQL query into progress 4GL language:
update table1
set col1 = 2,
col2 = getdate()
where col1 = 3
Thanks in advance.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.