SQL Query

All questions related to installations, configurations and maintenance of Advanced Host Monitor (including additional tools such as RMA for Windows, RMA Manager, Web Servie, RCC).
Post Reply
User avatar
eal
Posts: 8
Joined: Wed May 05, 2004 6:54 am
Location: Canada

SQL Query

Post by eal »

Can you specify variables that represent parameters of some explicitly specified test within a SQL Query?
For example:
Insert into Stats (YahooAliveRatio) VALUES (%::Yahoo::AliveRatio%)

I tried this and get an error. Return code: 4294967295
[Microsoft][ODBC Microsoft Access Driver] Sytax error in query expression '%::Yahoo::AliveRatio%'.

If I take out the ::Yahoo:: it works fine, but I want the AliveRatio for only this specific test :(
Top
KS-Soft
Posts: 12821
Joined: Wed Apr 03, 2002 6:00 pm
Location: USA
Contact:
Contact KS-Soft

Post by KS-Soft »

Can you specify variables that represent parameters of some explicitly specified test within a SQL Query?
No, you may use test related variables ony.
We can implement this option but... do you really need it?

Regards
Alex
Top
User avatar
eal
Posts: 8
Joined: Wed May 05, 2004 6:54 am
Location: Canada

Post by eal »

I just figured it was in the documentation I could use it. I need this fuctionality, I'll try to figure out another way of doing it...
Top
Post Reply

Return to “Configuration, Maintenance, Troubleshooting”