National Instruments BridgeVIEW What is SQL?

Appendix B Citadel and Open Database Connectivity

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 ( | )