Leaderboard

I guess this would make a good nugget as well (if it hasn't already been covered). Allow me to explain. If you are editing the case name in the case selector with the text tool: Shift-Enter will give you a new blank case. Ctrl-Shift-Enter will give you a duplicate of the case you were on. In both methods, the new case becomes the active displayed case with the text tool active in the case selector. Type a new name and hit the key combo again. You can rapidly prototype up a bunch of empty or duplicated cases.

And if you've already created a bunch of VIs with Auto Grow enabled, you can run this utility to turn it off on all structures in all VIs in a given folder. Turn Off Auto Grow -D

WOW! And here I thought it was common knowledge. Incidentally, this is true of any button if you release the BooleanText and move it off the button. Clicking the text will still activate the button. I wouldn't advocate moving text off the button as standard procedure for anything other than Check Boxes or Radio Buttons, though. So does everyone know about shift-enter and ctrl-shift-enter on case structures?

I've used connectionstrings.com once or twice to resolve problems connecting to databases. There are sections for most of the major DBs as well as using Excel files! 'dbmssocn' The network library used to establish a connection to an instance of SQL Server. Supported values include dbnmpntw (Named Pipes), dbmsrpcn (Multiprotocol, Windows RPC), dbmsadsn (Apple Talk), dbmsgnet (VIA), dbmslpcn (Shared Memory, local machine only) and dbmsspxn (IPX/SPX), dbmssocn (TCP/IP) and Dbmsvinn (Banyan Vines). The corresponding network DLL must be installed on the system to which you connect. If you do not specify a network and you use a local server (for example, "." or "(local)"), shared memory is used.