![background image](http://html1.mh-extra.com/html/national-instruments/bridgeview/bridgeview_user-manual_3445534408.webp)
Appendix B
Citadel and Open Database Connectivity
©
National Instruments Corporation
B-3
Note
Some applications are not completely ODBC compliant. If you plan to use
Microsoft Query, Microsoft Access or Visual Basic, ensure Maximum Column
Name Length does not exceed 62 characters. These packages cannot handle longer
tag names. Other packages that are truly ODBC compliant should be able to
handle tag names up to 126 characters long. All threads whose tag names exceed
the Maximum Column Name Length
are excluded from queries.
If you plan to use Microsoft Access or Visual Basic, select Convert special
characters. This forces BridgeVIEW tag names into a format acceptable by these
applications by replacing characters within the tag names as follows:
7.
Select OK and CLOSE to exit.
What is SQL?
Structured Query Language (SQL) is an industry-standard language used
for retrieving, updating and managing data. You can use SQL to build
queries that extract data from Citadel. Beyond simple data extraction, the
Citadel ODBC driver also includes many built-in data transforms that
greatly simplify statistical analysis of retrieved data.
Original Character
Converted To
period ( . )
backslash ( \ )
ampersand ( & )
at sign ( @ )
exclamation ( ! )
vertical bar ( | )