Login / Signup

Edit HDS database

 
Archive Data mgt
Last Post by n.kunzer 5 years ago
3 Posts
3 Users
0 Likes
29 Views
RSS
 c.pinasanz
(@c-pinasanzarcinfo-com)
Posts: 42
Trusted Member
Topic starter
 

Hello,

I had a Customer Request. He wants to edit/remove some variable values already logged on HDS SQL.
Do you have any exemple of Scada Basic or VBA program to access and modify the HDS?

Thanks!

Claudia

 
Posted : 17/08/2021 6:43 pm
 k.lemaire
(@k-lemairearcinfo-com)
Posts: 14
Active Member
 

Hello Claudia,

We don't have specific way to remove data on a HDS database through PcVue.
The best way would be to directly remove data from Sql Server Management Studio, using a SQL query that matches what the customer wants to remove.

Best regards,
Kévin

 
Posted : 19/08/2021 4:42 pm
n.kunzer
 n.kunzer
(@n-kunzerarcinfo-com)
Posts: 1236
Member Moderator
 

Hello,

@Claudia: I think you must be a bit more specific. First of all, the PcVue version. If the version is >= 15.1 then it could be done by SQL Variable feature. If not, then by code only. VBA is more adapted and I can help you on this. We can talk directly

@Kevin: Asking an operator to make a sql request using ssms is really not realistic.

Nico

 
Posted : 23/08/2021 3:13 pm
Forum Jump:
  Previous Topic
Next Topic