Thor IntellisenseX for SQL Tables

IntellisenseX can be used to display the fields in SQL tables, although doing so requires customization on your part.

The sample below accesses a table from a SQL server database:

SNAGHTMLbe1d5e2

Customization is achieved by modifying a Plug-in PRG.

The Plug-In is called when IntellisenseX has exhausted all other possible interpretations of the text before the dot. In this example, it is called with “soheader” as a parameter, and the Plug-In is free to determine the list of items to appear in the dropdown. In particular, it can use SQLColumns to determine the fields in the table or read the list of fields from a data dictionary.

See plug-in PRG for handling names that may be of SQL tables or data objects.

Last edited Aug 17, 2012 at 6:11 PM by JimRNelson, version 3

Comments

No comments yet.