Skip to Content
avatar image
Former Member

Current Tag Query

Newbie Tag query questions, two questions in one here -

1) We are able to pull multiple tags within a history query, but when we try a Current query it only pulls back one tag. Why doesnt it return the other tags within the Current?

2) We have been seeing odd error message occasionally, "SQLGetData: Conversion Character to Timestamp.". We thought it was the DateTime config but that is set up correctly.

Any thoughts?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Sep 25, 2007 at 10:55 PM

    Brian - glad to see you made it back from AT&T park in one piece...

    1) Is this just any pair of tags, or just certain combinations?

    2) Does your ODBC System DSN have any of the advanced settings checked besides Read-Only? (specifically the Timestamp sent as Character one).

    1/2) Are any of your tag meta queries failing when it sends the initial request for description and scaling ranges, etc?

    Regards,

    Jeremy

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 26, 2007 at 01:20 PM

    Brian,

    1) Did you test the queries as XML? Maybe the values are not supported data types, what types are the Tags defined as?

    2) Are you using an ODBC connection? This error is typically associated with that. What is the scenario for ODBC?

    -Sam

    Add comment
    10|10000 characters needed characters exceeded