Re: [sqlite] quetion on editing a sqlite database

john white [via SQLite] wrote: > I have a bit of a problem. I am moving a program (sickbeard) from > windows to ubuntu. The program has an sqlite database. It lists a > variety of things with their physical location on disk. The problem is > that ubuntu (linux) location information is slightly

Re: [sqlite] inserting record datinto mutliple tables with a composite primary key

p://sqlite.1065341.n5.nabble.com/file/n69543/sample_files_sqlite_ruby_loader.zip> Thanks for the assistance. I am now working on a script to add/change data in the existing records in a database, as well as a simple query script to export data to a delimited text file. *LMHmedchem* # scr

Re: [sqlite] JDBC Drivers for SQLite?

I have sqlite-jdbc-3.7.2.jar that I use as the sqlite driver for squirrel-sql. It is 3.1MB, so I don't think I can send it as an email attachment. You may want to search for that file name. If you can't find it, let me know and I will put is somewhere on the net for you. LMH Tilsley, Jerry M.

Re: [sqlite] inserting record datinto mutliple tables with a composite primary key

ject2, Project3, etc) as needed, and also allows for a quick method of looking up structures that might have been registered under a different name. Is ON CONFLICT FAIL what I want for the Structure table, or would ABORT/ROLLBACK make more sense? *LMHmedchem* -- View this message in context:

Re: [sqlite] inserting record datinto mutliple tables with a composite primary key

this if you are interested, but hopefully the above is enough to give a general idea. Tomorrow I will post a more complete version of the database definitions and insert syntax. *LMHmedchem* -- View this message in context: http://sqlite.1065341.n5.nabble.com/inserting-record-data-into-mutliple-

Re: [sqlite] inserting record datinto mutliple tables with a composite primary key

le quotes, but there could be any number of single quotes. N,N',N''-trimethylbis(hexamethylene)triamine These single-quotes will never appear as the first or last character, so possibly nothing needs to be done? *LMHmedchem* -- View this message in context: http://sqlite.10

Re: [sqlite] inserting record datinto mutliple tables with a composite primary key

orrectly. If Simon is reading this, I have not ignored your comment about having 500 columns in a table being an issue, I just am trying to get the basic syntax working first. None of those fields will ever have a null value. There are many zero's but those are not nulls and have meani

Re: [sqlite] subscribe to mailing list

I'm not having much luck with this. When I try to go to, http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users I get a "failed to connect", "The connection was refused when attempting to contact sqlite.org:8080." I tried in both seamonkey and ie and get the

Re: [sqlite] inserting record datinto mutliple tables with a composite primary key

hen I need to lookup data from a record using the 4 key values, there would have to be a way to retrieve the unique integer value ROWID that corresponds to the 4 keys (was assigned by AUTOINCREMENT). If I use unique like above, how would the lookup on the 4 keys work? LMHmedchem -- View th

[sqlite] inserting record datinto mutliple tables with a composite primary key

y, or even in a reasonable way? Suggestions and criticisms would be appreciated and a link to some examples or a tutorial would be fantastic. LMHmedchem -- View this message in context: http://sqlite.1065341.n5.nabble.com/inserting-record-datinto-mutliple-tables-with-a-composite-primary-key-tp