Monthly Archives: March 2016

Linkdump: creating standalone executables for Tcl scripts

Freewrap handles the creation of standalone executables easily when you can’t┬ásimply install Tcl onto a PC. There are other ways to do it like starpack, but I used freewrap. http://wiki.tcl.tk/856 http://stackoverflow.com/questions/17367399/how-to-make-tcl-program-into-an-exe-file http://wiki.tcl.tk/11861 http://freewrap.sourceforge.net/ http://freewrap.sourceforge.net/freeWrapDocs.pdf  

Posted in Uncategorized | Leave a comment

Linkdump: Working with (Tcl) Expect on Windows

http://expectonwindows.blogspot.com/ https://en.wikipedia.org/wiki/Expect http://expect.sourceforge.net/ http://stackoverflow.com/questions/19460420/running-expect-script-on-windows http://www.admin-magazine.com/Articles/Automating-with-Expect-Scripts http://docs.activestate.com/activetcl/8.4/expect4win/expect.html#exp_close http://docs.activestate.com/activetcl/8.4/expect4win/expect.html#exp_spawn http://tcl.activestate.com/man/tcl8.4/TclCmd/contents.htm?_ga=1.17009081.1244592451.1459347583 http://docs.activestate.com/activetcl/8.4/expect4win/expect.html http://docs.activestate.com/activetcl/8.4/expect4win/ex_usage.html#e4w_commands http://wiki.tcl.tk/3548 Expect script: start telnet, run commands, close telnet http://stackoverflow.com/questions/11250564/how-to-automate-telnet-session-using-expect?lq=1 http://stackoverflow.com/questions/11250564/how-to-automate-telnet-session-using-expect  

Posted in Linkdump, Programming, System/DB Administration | Leave a comment

T-SQL UPDATE TOP (1) statement to distinguish non-unique rows

Occasionally I need to update or delete rows from a heap table (meaning it contains no primary key). When dark forces align, all the columns have duplicate data. This makes DELETE or UPDATE trivially┬ámore tricky than using a simple WHERE … Continue reading

Posted in Uncategorized | Leave a comment