The future depends on us. It is up to us to the future of Clarion.
Will this programming language to live long and happy life or dies in oblivion depends on us. If you have to say, do it here in this blog. Welcome!

Read More

MS SQL Field Box


Download MS SQL Field Box 2.4
Download MS SQL Field Box 2.0 source (CFC Library 2.5 or higher required)

mssqlfb

About
MS SQL Field Box it is a small tool which allow you view MS SQL Server database structure and paste table or field names in your favorite editor with mouse left double click or keyboard hotkeys. It’s a another way of using “IntelliSense” technology :)

MS SQL Field Box helps you to type your T-SQL statements if you are still using the Query Analyzer or MS SQL Server Management Studio Express. You can reach more productivity using both technologies “IntelliSense” and “Field Box”.

Features
You can view:
• list of the databases
• tables and their fields
• views and their fields

You can paste in your editor:
• table name
• table field name
• view name
• view field name
• Ctrl+MouseLeft2 or Ctrl+Enter adding comma at end of a pasted name

Requirements
The program uses ADO, therefore you need in installed MDAC, usually it can be installed with MS SQL Client tools.

Quick start
1. Run a MS SQL Field Box
2. Run a Query Analyzer (or any editor)
3. Double click of left mouse button on table or field name in MS SQL Field Box window
4. And… Selected table or field will be pasted into Query Analyzer.

Hotkeys (recommended)
• Alt+R – reconnect to server
• F9 – program preferences
• Alt+A – sets or removes Alias for Table
• Ctrl+U – select a database
• Alt+X – exit
• Ctrl+Alt+R restores list box format
• MouseLeftDoubleClick on caption – roll the window up/down
• MouseLeft2 (or Enter) on Tables List – paste the highlited TableName in active editor. If Alias for table exists then it will be added.
• Ctrl+MouseLeft2 (or Ctrl+Enter) on Tables List – paste the highlited TableName in active editor with comma.
• MouseLeft2 (or Enter) on Fields List – paste the highlited FieldName in active editor. If Alias for table exists then it will be added.
• Ctrl+MouseLeft2 (or Ctrl+Enter) on Fields List – paste the highlited FieldName in active editor with comma.

You can set the global hotkeys for bringing the window front/back and rolling up/down. See the program preferences.
Also you can add the “MS SQL Field Box” in the “Tools”-menu if you are use Query Analyzer or MS Studio Express.