Menu

#6 Customisable Intellisense (SqlHelper)

open
nobody
None
5
2002-12-11
2002-12-11
No

One flexible way to do this could be with "extensible
Intellisense" Microsofts Visual FoxPro has this and it is
awesome. VFP has a native dataengine and all
Intellisense entries are stored in it. Users can create
custom entries, attach any code to it and when the user
invokes it, the code is run and the resulting text is
inserted at the cursor location. I use it for doing the code
generation tasks mentioned above on the currently open
table. There could be a table inthe MASTER database
that holds user defined Intellisense entries.n The stored
code would be just TSQL that can access other sytem
tables to get SCHEMA info to generate the necessary
code. THis would be a killer feature.

Harold Chattaway

Discussion