Reading, Writing and deleting access record, Help!
I'm a total amateur to VBS but need help on a VBS script. This is used in a HMI system from Siemens called WinCC, used for process viewing and control.
What I need to is to write to a table in Access, then read these values and then delete records (rows) in Access.
By using help functions in WinCC I have this set up:
I created an Access database with the WINCC_DATA table and columns (ID,
TagValue) with the ID as the Auto Value.
Then I can write to Access by the following code:
strConnectionString = "Provider=MSDASQL;DSN=SampleDSN;UID=;PWD=;"
lngValue = HMIRuntime.Tags("Tag1").Read
strSQL = "INSERT INTO WINCC_DATA (TagValue) VALUES (" & lngValue & ");"
Set objConnection = CreateObject("ADODB.Connection")
objConnection.ConnectionString = strConnectionString
Set objCommand = CreateObject("ADODB.Command")
.ActiveConnection = objConnection
.CommandText = strSQL
Set objCommand = Nothing
Set objConnection = Nothing
This actually works fine, pure luck I guess!
Can anyone help me with scripts for:
1. Reading one record (row) according to a ID number
2. Deleting the a record (row) according to a ID number
I would be very thankful for any help!