No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
 | **I have been automatically collecting machine breakdown info to a database for 12 months, so I have thousands of entries in a 'Machine Downtime' table. However, I have found that the time_down column is offset by one row. The 'time_down' in the top row needs to be moved to the …  |
| | I'm running a webpage dashboard on a TV on the production floor of our factory so workers can see their live uptime, scrap etc. I need the page to refresh when new data is available. I want to load a page in a hidden iframe every x seconds, if the … |
| | I am running an automated script that generates a CSV file from a query every 24 hours which works well, but I must use root login. As soon as I change it to the user login (who has the same rights to the schema as root) it gives me the … |
| | I have a machine logging production info to a database whenever certain conditions change state, so pretty much randomly throughout the day. The plant runs 24/7 so data is continuously flowing into it with about 500 entries in a 24 hour cycle. The shifts are strictly time based and are … |
| | I have a query which generates an xml file from data collected. There are 2 columns in the data (reason, TotTime) but they are joined together into one column using the concat command. Currently the results are ordered by reason, but I want to limit my results to only the … |
| | I have a table that a new line gets added to when the machine stops with reason for stopping, when the machine gets going again I want to add the time lost. So when the machine stops the table will look like this: [CODE]ID | reason | time_lost 1 | …  |
| | We have 3 shifts running at our plant, day 0720 - 1520 swing 1520 - 1120 night 2320 - 0720 I have a table storing the bags packed on each shift, and now need to display the team (tech, packer_l, packer_r etc) with the greatest number of packed bags depending … |
| | I have a table which holds the status of a machine in our factory. When the machine is running a line is written with a status of 1, when it stops it writes a status of 5 until a program records the error then it writes a line with a … |
| | I have a table with information about the type of scrap generated on a bag making machine. Every time scrap in generated on either side of the machine (left or right, there are 2 packing machines on the one bag maker) a line is added to the table with the … |
| | I am using VB to query a MySQl database and populate an Excel spreadsheet. All is working well, but now I would like to start distributing the spreadsheet shroughout the company and cannot protect it. If I protect the spreadsheet the VB cannot add the MySQL data, so I added …  |
| | I have written a script that runs with a glade gui. When a button in glade is pushed I need it to run a piece of code, pause for 3 seconds and run it again in an on going loop until the button is pushed again. So the button is … |