Black, Michael (IS) wrote, On 26/04/12 19:00:
Sqliteman must be pointing to the wrong database.
sqlite> SELECT transfer_date FROM transfer_history WHERE regn_no =
'039540'..... Error: no such table: transfer_history
Hmm. I've just done the following - cut & paste from my terminal:
[home@system06 test]$ mkdir sqlite
[home@system06 test]$ cd sqlite
[home@system06 sqlite]$ wget
http://www.somborneshetlands.co.uk/things/sss-test-nomem.zip
--2012-04-26 21:09:04--
http://www.somborneshetlands.co.uk/things/sss-test-nomem.zip
Resolving www.somborneshetlands.co.uk... 91.197.33.236
Connecting to www.somborneshetlands.co.uk|91.197.33.236|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 184279 (180K) [application/zip]
Saving to: `sss-test-nomem.zip'
100%[==============================================================================>]
184,279 792K/s in 0.2s
2012-04-26 21:09:04 (792 KB/s) - `sss-test-nomem.zip' saved [184279/184279]
[home@system06 sqlite]$ unzip sss-test-nomem.zip
Archive: sss-test-nomem.zip
inflating: sss-test-nomem.sqlite
[home@system06 sqlite]$ sqlite3 sss-test-nomem.sqlite
SQLite version 3.7.11 2012-03-20 11:35:50
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> select * from transfer_history where regn_no = '023674'
...> ;
023674|1610|Wycoller|1999-04-01 12:00:00|April 99|Presumed
023674|SSB900|(Dead)|2002-03-31 12:00:00|31/03/2002|Presumed
023674|1004|Glynwood|1995-04-04 00:00:00|4/4/95|Birth
sqlite>
Seems to work for me. You'll have to use 023674 instead of 039540 as the
latter doesn't exist in this test database.
Pete
--
Peter Hardman
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users