I am not even sure which heading to put this under FPMI or FSQL. I am leaning toward FSQL but again am unsure. Here is my question:
I am looking at doing some changing on some of my project. However I know where I want to start, and I know where I want to end. It is the stuff in the middle that is throwing me a little. I would appreciate that whomever reads and responds to this can put the solution into somewhat laymans terms. I will do my best to describe what the change will entail.
We have Microsoft SQL 2005. There is a table which contains all employee ID numbers. Currently I have a screen in FPMI where the supervisor does the scheduling and assignments. When we first started working on this system this schedule was an easy way, but since starting a 3rd shift and all the other increases that have gone on this might not be the best approach any longer.
What we were talking about doing at todays meeting was to have the employees arrive at the machine, they would scan their badge, the PLC or course is connected to OPC then to FSQL then to the Microsoft SQL. Well anyway once the employee scans their badge at the machine level it would send the ID number over to some point, most likely FSQL where it would do a compare of the ID number. If the ID number matches one in the database then an enable type signal of sorts will be sent back to the machine. So my big question is would an idea like this work? If so, how?
I mean I can scan the data at the PLC, that is not a problem. And I can send the data back and have it go all the way to SQL. But from this point I need a push in the right direction. What help can you supply in regards to this undertaking?