10-12-2007 03:14 PM
10-15-2007 11:11 PM
10-16-2007 10:34 AM
Hi Eric,
Thank for quick responding.
Working Process
1. User Select Work Order Number from a drop down menu (Work Order Number ger from MfgPro by using ODBC connection)
2. Input Work Order Number information into SQL Server Database (WO#, Quantity, Model)
3. Dectect count signal from PLC (500ms debound)
4. When PLC signal is detect, Increase the completed quantity in SQL Server database)
(This program helps to prevent over built project)
-------------------- Now how to setup this system----------------------------------
- NI USB 6525 IO Card is used to detect the signal from PLC for counting. This signal will pull high for 500 ms. In timeout event structure, I set if Count is change, then go to make a count in Database that mean increase the complete quantity.
-There is two ODBC connection datasource, one is for SQL DB, another for Mfpro
-When user select Work Order Number, Program will go get Quantity, Model from MfgPro and input into SQL Database (if this work order's quantity and model are not in SQL DB)
----------------------------DLL----------
Before I use DLL webserver to get data from MfgPro to put in SQL DB. I thought DLL causes problem, so I I don't use DLL, instead using ODBC to connect to MfgPro and get Work Order's quantity and Model to put into SQL DB. But it still has same problem.
I hope my explain is clear. Otherwise I can provide more infor for you. Can I send my lv code for you? I am very new with Labview. I just learn this lv for a week at basic training course.
10-17-2007 09:25 AM
10-17-2007 09:09 PM