Writing data from Intouch to SQL using Blind list, and using SQLDataGrid to access the Database.

HP: [phone]

Other video

[rogaco]

The following code works for me (AVEVA InTouch 2020):
ResultCode=SQLConnect( ConnectionId, "DSN=MixingStation;
DB=Intouch");
SQLInsert( ConnectionId, "Report", "MaterialData" );
ResultCode=SQLDisconnect ( ConnectionId );

PD: ResultCode and ConnectionId I defined like MemoryInteger

ResultCode
Integer variable returned from most SQL functions. ResultCode is returned as zero (0) if the function is
successful and a negative integer if it fails.

ConnectionID
Name of a memory integer tag that holds the number (ID) assigned by the SQLConnect() function to each
database connection.

[ahmedalyelmeadawy]

I have a error message "invalid connection" that means that means the connection Id passed to the function is not valid. Please advise

[VinhLe-opix]

Hi, How would you retrieve datas from a column in database and display them on a combo box?

[MrEdwinAgustinus]

Hi, do you have the Licence for this version? I would be thankful for this. Cheers.

[akashbanaulikar]

Thanks dude.. This video helped us a lot

[wonderware_aveva]

Hi, If I want to read the data from a particular row in Sql grid. Then what will be the script?

[coolnagarajan]

Hello sir I am trying this same communication but the data was not pushed into SQL server
The button 'Write to SQL' I write the same action script what you give but it asked me to initialised ReadCode and ConnectionID please support me sir

[windas-nan-jaya]

ResultCode=SQLConnect( connectionId, "DSN=...; APP=Microsoft Windows Operationg System. WSID=(local); DATABASE=...; Trusted_Connection=Tes");
SQLInsert( connectionId, "...", "...");
ResultCode=SQLDisconnect( connectionId );

[NgocNguyen-qlvp]

Công cụ historian của intouch rất mạnh. với những tag đến hàng trăm hoặc nghìn tag thì như thế này liệu ổn k ạ.

[임경묵-go]

Hi, thanks a lot to made this video. Can i ask something about this video? 1st. I want to ask about the data type of "ResultCode", 2nd. What is it the ConnectionID? Is it Computer Name or SQL ID?

[alik]

Bro, how could I achieve this in Aveva System Platform