Wednesday, November 25, 2009

To turn off the menu in xterm

Add this to your ~/.Xdefaults file or to /etc/X11/app-defaults/XTerm


xterm*toolBar: false

Monday, November 23, 2009

Excel 2007 'Cannot empty the Clipboard.'



If you drag and drop a cell in Excel 2007 and get a pop error with "Cannot empty the Clipboard.":

Check to see if you have any applications running that interact with the clipboard.

In my case, it was MultiMonitor TaskBar from http://www.mediachance.com/free/multimon.htm
To turn this off:

Right-click on the MultiMonitor TaskBar
-> Click "Properties"
-> Uncheck "Add Multi-Text Clipboard"

There are other solutions for this here:

http://www.online-tech-tips.com/ms-office-tips/cannont-empty-clipboard/

Friday, November 20, 2009

SQLite guis for Windows

I have tried quite a few from:

http://www.sqlite.org/cvstrac/wiki?p=ManagementTools

These are OK:

SQLite2009Pro-v3.6.20.zip
sqlitebrowser-1.3-win.zip
SqliteDev357.zip
SQLiteExpertPersSetup.exe

Multiple field primary key in sqlite


BEGIN TRANSACTION;
CREATE TABLE test_table(
field1 text not null,
field2 text not null,
field3 text not null,
PRIMARY KEY(field1, field2)
);
INSERT INTO "test_table" VALUES('a', 'a', '1');
INSERT INTO "test_table" VALUES('a', 'b', '2');
INSERT INTO "test_table" VALUES('a', 'c', '3');
COMMIT;


http://groups.google.com/group/android-developers/browse_thread/thread/948acbc9358a3095