Recent content by srelliott

I'm still having trouble getting this SQL SELECT string converted to a format that the Progress database will understand. Can anyone help me adjust it please? Maybe I was close (or maybe not?) in my last post...I just don't know enough about Progress to know. Thanks!

Thanks for the reply. How is this looking? SELECT SUM(Qty) as Total From Productionhistory WHERE Operation='MOLD 1' AND (Shift = case when TO_CHAR(CURTIME(), 'HH24:MM') < '06:30' then 3 when TO_CHAR(CURTIME(), 'HH24:MM') < '15:00' then 1 when TO_CHAR(CURTIME(), 'HH24:MM') < '23:30' then 2 else...

I have some SELECT strings that work fine in asp.net when connecting to an SQL database, but I can't get them to connect to the Progress database and perform these tasks to display info without errors. Do I just need to change some of the commands in the SELECT string (are some just not...