more quick actions
minimize quick actions
Hello SQL or Access experts:
I got a customer, who plans to store data as showed in the table_02. Normally,PcVue can only store data as table_01. Does somebody know it? With sql scripts or VBA?
I saw the excel export in the svhimdemo, in that file, the data displays as table_02.
Thanks in advance!
Posted : 12/12/2012 10:56 am
In the demo the way to is really different.
A scada Basic script is using svTrend to extract data in a csv format then create a file.
Apparently you want to do it from Access directly.
First remark: Did you advise your customer about the very very poor performances of Access Db?
Anyway I dont have the required script but I am quite interested if you fond it 😉
Posted : 12/12/2012 1:34 pm
In the demo the way to is really different.
A scada Basic script is using svTrend to extract data in a csv format then create a file.Apparently you want to do it from Access directly.
First remark: Did you advise your customer about the very very poor performances of Access Db?
Anyway I dont have the required script but I am quite interested if you fond it 😉
Thanks Nico.
🙁 bad news!
The customer used Kingview and ifix, and they told us with these scada, they can store data like that in the access database.
Posted : 12/12/2012 2:01 pm
Shu Quan, they can store data in Access. That's not the problem.
The problem is that Access is NOT an industrial database and if the size is more than 500Mb the performances will become very very bad.
Therefore, the problem is not in PcVue...
Is there a particular reason why they don't use SQL Server Express?
Posted : 12/12/2012 2:47 pm
Just to end this ticket.
Yesterday, Nico decided to train us to solve this issue, and then we'll make a demo for the customer.
Thx a lot! 🙂
Posted : 13/12/2012 9:36 am