Recent content by Manturo

Try today - 7 and see if that works.

Try in your by statement the Integer function. It has worked for me. Example: for each TABLE no-lock by int(text_number field).

Re: Sales reporting per Day In SXe The standard sales report we use is OERR using the following criteria stages 1 to 5 enter date ** /**/** Stage 0 would include quotes as well but that's the only way to include Future orders which are always in stage 0. I would stay away from trying to...

Re: Assign a Row Number - One more refinement I modified my code as follows: def var cnt as int. for each icsw exclusive-lock where (cono = 1 and whse = '') BY (qtyonhand * avgcost) DESCENDING: cnt = cnt + 1. assign countfl = no. if qtyonhand * avgcost >= 1500 then do: assign binloc1 =...

Thanks. That worked. I'm new to Progress so concepts are "sticking" as I'm coming from the rudiments of T-SQL.

Greetings - I would like to assign a row number to a query result list based on the descending order of inventory value. Here is my code: for each icsw no-lock where (cono = 1) BY qtyonhand * avgcost DESCENDING: if qtyonhand * avgcost >= 1500 then do: disp whse prod countfl qtyonhand qtyonhand...

Greetings, I'm wondering if anyone here has used in concert with SX.enterprise (NxTrend now Infor) product the third-party catalog management and e-commerce product called Catalog Builder (http://www.computerpundits.com/). I'd like to get an idea of the pain of implementation and anyone's...