Hello,
I am a newbie to Visual basic and OPC, and I hope someone can help me here. I have an historical database which has data in intervals of 40mins, I also have an OPC server which intends to go into the database and get data. I am trying to write a Visual basic script to tell the OPC Server...
Thanks Geates,
The database is a SQL database, with historical date. The time difference is not always 40 mins (Sorry i did not mention this earlier.
-Dee
Hello,
I am a newbie to Visual basic and OPC, and I hope someone can help me here. I have an historical database which has data in intervals of 40mins, I also have an OPC server which intends to go into the database and get data. I am trying to write a Visual basic script to tell the OPC Server...
Hello,
I am a newbie to Visual basic and OPC, and I hope someone can help me here. I have an historical database which has data in intervals of 40mins, I also have an OPC server which intends to go into the database and get data. I am trying to write a Visual basic script to tell the OPC Server...
I am trying to get data from Oracle (ODBC) to an OPC server client.
Does anyone have any idea of a product/tool that can do this?
Thanks for your help in advance.
Daisy
Thank you Feherke for the reply. When i try to open the outfile, its giving me an error message that:
"Word experienced an error trying to open the file
I have a quick tcl question, hope someone can help.
I have 2 files and Im trying to get the information in the second file to the first file. I wrote a code but it doesnt seem to work. This is the code below.
set infile [open "daisy.doc" r]
set outfile [open "daisy2.doc" w]
while {![eof...
Thank you guys for the reply. Im not sure if you guys understand what im trying to say. Let me explain better.
I have a code that outputs some information from sql database. This is the code below:
set query "select Comment FROM Table WHERE Name = 'Daisy'"
set foo [database $query]
but when i...
I have a code that outputs some information from Sql database using tcl. I noticed that when the information i output have a space in it, it is surrounded by a curly brace {} and when it does not have a space there is no curly brace surrounded. Does anyone know why and how i can output it...
I just figured something out now.
if i insert a "\n" or a "letter" before the $foo, like this:
[$::application Selection] TypeText "\n$foo" or
[$::application Selection] TypeText "a$foo"
it works with a "space" and "a" before it.... wierd!
but i can work with that.
Thanks for you help.
I have that i did not just type it in my question.
I mean it can access sql and output anything right but it wont just insert it in the word table.
for example, if i type
puts $foo, it will output it right.
but if i type
[$::application Selection] TypeText "$foo" it gives me a "type...
I have a code that creates a MS word file with tables using tcom package. I am trying to insert some text from sql database into the columns and rows, ive being trying different codes and its doesnt seem to work, any help please? The code is below:
This code creates a 3 rows and 3 columns table...
I was able to figure it out, below is the code.
package require tcom
set application [::tcom::ref createobject "Word.Application"]
$application Visible 1
$application DisplayAlerts 0
set docs [$application Documents]
set doc [$docs Add ]
[$doc Tables] Add [[$application Selection] Range]...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.