Description
This is a Ruby version of this Python script.
This script will query a table called "tblBar" (consisting of three fields, an ID [number], Name [string] and E-mail address [string]) in an Access database and display the results in a CT-formatted table. Additionally, the e-mail addresses will be properly linked.
Requirements
ActiveRubyScript must be installed as per the standard CT instructions. A Microsoft Access 2000+ database with the aforementioned design must also exist. Tested under ConnectedText 2.0.0.4.
Installation
Download this script into your /ConnectedText/Scripts folder and register it with the "Manage Scripts" feature. Create a topic called "Dbtest", then simply run the script.
Enhancements, Suggestions, Etc.
The possibilities are almost endless. Modifying the above code and placing it into an external script you could, along with ConnectedText's built-in OLE Automation, generate new topics for every record in a given table.