Why am I Unable to Execute a Parameter Query on the Citadel Database?
Primary Software: LabVIEW Toolkits>>Enterprise Connectivity Toolset
Primary Software Version: 3.0.1
Primary Software Fixed Version: N/A
Secondary Software: N/A
Problem: Why am I unable to execute a parameter query (using Microsoft Query) on the Citadel database? While following the Microsoft Excel Online Help for setting up a Parameter Query, an invalid SQL statement is generated and the "unknown characters" error message occurs when querying the Citadel database. The unusable statement will follow this general form:
SELECT "(trace name)" FROM Traces Traces WHERE (LocalTime >? And LocalTime
Solution: A Parameter Query uses Microsoft Query to prompt users for search parameters. Microsoft Query builds an SQL statement and it inserts a "?" for each search parameter, but the National Instruments driver for Citadel databases does not currently support the "?" syntax, which is why you see the error.
If you want to use dialog boxes to prompt a user for search parameters, then you must create your own prompts for search parameters (e.g., create Excel macros or dialog boxes in Visual Basic that do the prompting), build a query from the results, and then execute the query.
Related Links:
Attachments:
Report Date: 09/27/2000
Last Updated: 12/02/2004
Document ID: 21QA1J6W
