on 04-27-2007 10:52 AM
<b>In my current application I have to pass 180+ tags in a single query to retrieve data from iHistorian.
I want to know how to pass more thatn 100 tags in a single SQL or TAG Query using OLEDB or UDC connectors.
If anybody has done it in the past ,please share with me and also let me know how to do it</b>
Currently you can only query a maximum of 128 tags, this is a hard limit and may be changed in future releases of xMII, but < 11.5 (im fairly sure 12 also) all have the limit of 128.
As for iHistorian with the OLEDB UDS, you can write a query that would return over 128 queries becasue this is an input limitation on the UDSs. (PLEASE DON"T ASK US HOW TO WRITE iHistorian QUERIES... we aren't experts in iHistorian).
Please note that though you can query over 128 tags, the performance may not be what you expect... This may take a very long time to return.
Martin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Out of curiosity, why do you need to do this? Seems excessive for a single query.
I suspect there's a better way.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
7 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.