Recent content by philipped

Mon plaisir ;)

You can do it using procedure editor

I'm using SyteLine 5 and i'm cleaning tmp-sum once a year as a part of my year end procedures. And i never had any remorses doing it ;) If you want to validate the theory without deleting the entire content you could delete the records between 28000 and 32000. Don't forget to take a backup of...

Mathieu, I had the exact same symptoms years ago. You should take a look at the tmp-sum table in your progress database, just to be sure it is not the same problem that I had. Each time an user log in in SyteLine, a record is created in the table. The primary key of that table is the id field...

I'm using a shared variable to find the current user to. The only reasy i'm using this method to find the current user is that's how it was made by my predecessor. I never asked myself if there is another way to achieve this. So I think now is a good time to do so. I'll start by looking at the...

I think everything was developped under v9 where the statement is supported. But when consultants bring in code you can't be sure wich version where used to develop the program in first place...

Nice topic. I was hired 5 years ago as a student in a Progress 9 environment. I had to learn Progress almost by myself. All of our custom programm are using the "For each Delete" mothod, not the EMPTY TEMP-TABLE method when temp table are used. I think I will take some time to check those...

Just to add my two cents regarding this, when it comes to cut the time needed to process reporting or rebalance utilities in SyteLine I would advice to thnk about moving old record such as co, po and jobs to the history files. There is also many utilities used to purge transaction like job...

Take a look at the Tax Codes screen: Customer -> customer Service -> Order Maintenance, View -> Files -> Tax Codes

There is something i definitely miss about that parameter: Remember that I have less than 70k items in my database. The following code: FOR EACH ITEM EXCLUSIVE-LOCK WHERE ITEM.net-change = TRUE: ASSIGN ITEM.net-change = FALSE. END. Result in this in the Locking and waiting Stats option...

Sadly, yes. We are a air-jetted bath manufacturer. We offer many option with our bath (lights, armrest, overflow...) wich result in more than 50k different baths created in the database since we starts using SyteLine. Since we want to modify the recipe of an item that is used in all baths (a...

Hi, I'm using Syteline 5 ERP with a Progress 9.1D database wich is ancient, obsolete, unsupported and buggy. Yes, I know Tom!! ;). A user is performing an operation that result in a "Increase -L parameter" error. After investigation, I have found that the program (wich is a standard program...

Just to share some info i had a similar problem with the Current BOM and Standard BOM screen. Impossible for SyteLine to display the BOM treeview. By looking at the source code I found that the required library is called Tlist. The version 3 is shipped with SyteLine 5...

Re: I was very pleased to find this post BTW, we are using SyteLine 5, not 6.

Re: I was very pleased to find this post OMG! It's working... Thank you so very much Mathieu... This post made my day!! :) The guy who is using the Current Operation screen and the Job Operation screen was stuck to Win XP because of this. Thank you again!!