Displaying 2 results from an estimated 2 matches for "wwtagkey".
2001 Nov 13
1
RODBC
I'm tryuing to get the RODBC package to work with a MS Sql database
(Wonderware's InSQL). I'm able to connect to the database using the
following:
version
_
platform i386-pc-mingw32
arch x86
os Win32
system x86, Win32
status Under development (unstable)
2001 Nov 14
0
RODBC: Minor problem, I hope.
...istory TagName 12 varchar
3 Runtime dbo AnalogHistory Value 6 float
4 Runtime dbo AnalogHistory Quality -6 tinyint
5 Runtime dbo AnalogHistory QualityDetail 4 int
6 Runtime dbo AnalogHistory wwTagKey 4 int
...
When I try to query the table, I get:
> test <- sqlQuery(channel,"select DateTime, value from AnalogHistory
> where Tagname = 'a055-re-0020_ph_pv_flt' and DateTime >= 'nov 1, 2001
> 2:00pm'")
> test
test
[1] "37000 201 [M...