Re: [sqlite] primary key autoincrement updation problemincaserefereced

Corrected it. Thank you. insert into t1( hh, t1info) values ((select h from t0 where t0info = ?), ?) On Thu, Jan 12, 2012 at 11:35 AM, Durga D wrote: > Dear Igor, > > Insertion time, I am able to get the rowid from > sqlite3_last_insert_rowid(); > >It's

Re: [sqlite] Incompatible versions of SQLite on same system

Kevin and Joe, Thanks to both of you for your responses. I'm back to wondering how SQLite can be effective in the PC world with so many different programs using many different versions of SQLite. Since all versions are backward compatible, I was liking Richard's suggestion to get the

Re: [sqlite] primary key autoincrement updation problemincaserefereced

Dear Igor, Insertion time, I am able to get the rowid from sqlite3_last_insert_rowid(); It's working fine. Now, t0info record already exists, that time , I should not update with latest rowid. I should fetch the corresponding h value, update in t1 table. Here, fetching is

Re: [sqlite] primary key autoincrement updation problemincaserefereced

Durga D wrote: > Dear Igor, > >If already toinfo record exists, that time how to get the h > (primary key) (instead of rowid)? An INTEGER PRIMARY KEY column is in fact an alias for rowid. They are one and the same. -- Igor Tandetnik

Re: [sqlite] primary key autoincrement updation problem incaserefereced

Dear Igor, If already toinfo record exists, that time how to get the h (primary key) (instead of rowid)? Any shortcut for this? Thanks in advance, Durga. On Wed, Jan 11, 2012 at 7:19 PM, Durga D wrote: > Thanks alot !!! > > Have a good day. Let me try. >

Re: [sqlite] Incompatible versions of SQLite on same system

Kevin Benson wrote: > > Since the System.Data.SQLite.dll is a mixed assembly (i.e. contains > both managed & native code) in differing versions for x86 versus x64 , > I wonder if HP meant TurboTax was using, for example, an x86 flavor of > that DLL that conflicts with their (HP) program's use of

Re: [sqlite] Named parameters and spaces.

On Tue, Jan 10, 2012 at 4:11 PM, Simon Slavin wrote: > > On 10 Jan 2012, at 11:57pm, Steven Michalske wrote: > >> Some day they might have a field that is named with the underscore as >> a second column; not saying it makes sense.  We find all kinds on the >> internet :-) >

Re: [sqlite] Incompatible versions of SQLite on same system

Since the System.Data.SQLite.dll is a mixed assembly (i.e. contains both managed & native code) in differing versions for x86 versus x64 , I wonder if HP meant TurboTax was using, for example, an x86 flavor of that DLL that conflicts with their (HP) program's use of an x64 flavor? On 1/11/12, Joe

Re: [sqlite] Incompatible versions of SQLite on same system

Well, this seems really strange - neither Connection Manager nor TurboTax has a ! Here are all of the ones on the system: c:\Program Files (x86)\Calibre2\DLLs\sqlite3.dll c:\Program Files (x86)\Common Files\Apple\Apple Application Support\SQLite3.dll c:\Program Files

Re: [sqlite] /**** ERROR: (11) database disk image is malformed *****/

On Wed, Jan 11, 2012 at 3:29 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 11/01/12 12:13, Jos Groot Lipman wrote: > > When I look at the corrupt database, it no longer start with 'SQLite > > format 3' but with what seems like data from

Re: [sqlite] table names on the fly

On 1/11/2012 3:53 PM, inq1ltd wrote: Can someone tell me how to get the column names contained in a table on the fly. Prepare a statement of the form "select * from mytable;" (no need to actually run it), then use sqlite3_column_count and sqlite3_column_name[16]. Alternatively, execute

Re: [sqlite] table names on the fly

On Wednesday, January 11, 2012 09:58:17 PM Petite Abeille wrote: > On Jan 11, 2012, at 9:53 PM, inq1ltd wrote: > > Can someone tell me how to get the column names > > contained in a table on the fly. > > pragma table_info > ___ > sqlite-users mailing

Re: [sqlite] table names on the fly

On Jan 11, 2012, at 9:53 PM, inq1ltd wrote: > Can someone tell me how to get the column names > contained in a table on the fly. pragma table_info ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] table names on the fly

sqlite help, Can someone tell me how to get the column names contained in a table on the fly. Col names are altered and added by a front end program and I want to detect the column names while the DB is in use. I would appreciate the help. jd

Re: [sqlite] JOIN on between

On 1/11/2012 3:49 PM, Pawl wrote: select errorapi.*,login.* from errorapi JOIN login on (errorapi.start between login.start and login.ende) This command show only one end record. It is possible to use JOINS? I don't see anything wrong with the query. If it only reports one record, that must

[sqlite] JOIN on between

Hi, I need to join two table according to range of date. Fist table is error log table second is users{operators} login. I need to show complete table with all error with actual user id. CREATE TABLE [login] ( [id] iNTEGER NOT NULL, [start] TIMESTAMP DEFAULT (datetime('now','localtime'))

Re: [sqlite] /**** ERROR: (11) database disk image is malformed *****/

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/01/12 12:13, Jos Groot Lipman wrote: > When I look at the corrupt database, it no longer start with 'SQLite > format 3' but with what seems like data from one of my tables. Try a different USB stick. There are a lot of counterfeit ones out

Re: [sqlite] /**** ERROR: (11) database disk image is malformed *****/

> > Have you read the http://www.sqlite.org/howtocorrupt.html > document? The second paragraph of section 3.1 in particular > might be relevant to your situation. Even if the stick lies about the sync request: the stick has not been removed in the past few months and the router has not been

Re: [sqlite] /**** ERROR: (11) database disk image is malformed *****/

On Wed, Jan 11, 2012 at 2:12 PM, Jos Groot Lipman wrote: > Interesting, I have got a database on a (cheap) thumbdrive that gets > corrupted as well. It has happened three times to me now. > > It is a tiny database (< 200 kB) behind a website and it is under very > little

Re: [sqlite] /**** ERROR: (11) database disk image is malformed *****/

Interesting, I have got a database on a (cheap) thumbdrive that gets corrupted as well. It has happened three times to me now. It is a tiny database (< 200 kB) behind a website and it is under very little stress: perhaps 10 insert/update statements *per day*. The website is running on a router

Re: [sqlite] Incompatible versions of SQLite on same system

Richard, Thanks for the prompt reply - much appreciated! The machine with the issue is not onsite right now, but I expect to have it back in 4-5 hours. I will try your suggestion then and will post the results to the group. I have already complained to HP (both on the phone and in writing) and

Re: [sqlite] Incompatible versions of SQLite on same system

On Wed, Jan 11, 2012 at 12:39 PM, Joe Winograd wrote: > Hi Folks, > > First time poster here, so be gentle. I have an HP EliteBook 8460w running > 64-bit W7. HP provides an app called the Connection Manager that allows you > to control the status of the wired, wireless, and

[sqlite] Incompatible versions of SQLite on same system

Hi Folks, First time poster here, so be gentle. I have an HP EliteBook 8460w running 64-bit W7. HP provides an app called the Connection Manager that allows you to control the status of the wired, wireless, and Bluetooth connections (it uses SQLite). CM was working fine until I installed

Re: [sqlite] Is there some hidden way to create a log record of Sqlite commands?

On Wed, Jan 11, 2012 at 11:17 AM, John Elrick wrote: > I'm still debugging the issue I reported earlier concerning upgrading > from 3.6.17 to 3.7.9. One solution we are examining would be to > create a log of all SQL commands executed and then replay the log > using the

[sqlite] Is there some hidden way to create a log record of Sqlite commands?

I'm still debugging the issue I reported earlier concerning upgrading from 3.6.17 to 3.7.9. One solution we are examining would be to create a log of all SQL commands executed and then replay the log using the different versions. As an example, if I were to execute (psuedo-code) command :=

Re: [sqlite] PRAGMA index_info explanation

Thanks a lot Tom, don't know why this email was delivered even today, it was sent yesterday and Dr. Hipp already replied me. Anyway… thanks a lot for your detailed explanation, I really appreciate. -- Marco Bambini http://www.sqlabs.com On Jan 11, 2012, at 4:06 PM, BareFeetWare wrote: >

Re: [sqlite] suppress "database is locked"?

> how to suppress this messages? I cant find any kind of --quite or --silent > option. You can redirect stderr to /dev/null and you won't see any error messages then. Also you can redirect it to some file and analyze it later for some kinds of errors you want to process. Pavel On Wed, Jan 11,

Re: [sqlite] PRAGMA index_info explanation

Hi Marco, In reply to: > From the PRAGMA index_info documentation: > This pragma returns one row each column in the named index. The first column > of the result is the rank of the column within the index. The second column > of the result is the rank of the column within the table. The third

[sqlite] suppress "database is locked"?

Hello List, i have a perl script and do some selects, inserts, updates to my sqlite-db. it is a perl script but i use shellcommands (no dbi) and run them by exec for some reasons. example: $command="/usr/bin/sqlite3 mydb.db \"select foo from bar;\""; or: $command="usr/bin/sqlite3 mydb.db

[sqlite] PRAGMA index_info explanation

>From the PRAGMA index_info documentation: This pragma returns one row each column in the named index. The first column of the result is the rank of the column within the index. The second column of the result is the rank of the column within the table. The third column of output is the name of

Re: [sqlite] primary key autoincrement updation problem incaserefereced

Thanks alot !!! Have a good day. Let me try. On Wed, Jan 11, 2012 at 7:15 PM, Igor Tandetnik wrote: > Durga D wrote: > > so, first I need to insert in t0 table, then query for value from t0, > then > > update t1 with this value. Needs to avoid

Re: [sqlite] primary key autoincrement updation problem incaserefereced

Durga D wrote: > so, first I need to insert in t0 table, then query for value from t0, then > update t1 with this value. Needs to avoid reading from t0 table. You don't need to query t0 after insert. You can use sqlite3_last_insert_rowid API function, or

Re: [sqlite] primary key autoincrement updation problem in caserefereced

Thanks Igor. >>You seem to be under impression that a FOREIGN KEY >>constraint somehow magically pulls a value from >>referenced table. correct. so, first I need to insert in t0 table, then query for value from t0, then update t1 with this value. Needs to avoid reading from t0 table. Is

Re: [sqlite] primary key autoincrement updation problem in caserefereced

Durga D wrote: > create table if not exists t0 ( h integer primary key autoincrement, t0info > text); > create table if not exists t1 ( i integer primary key autoincrement, t1info > text, hh integer not null, unique(i, hh), foreign key (hh) references t0 > (h) ); The UNIQUE

Re: [sqlite] primary key autoincrement updation problem in case refereced

Simon/Jr Please find the attached main.c files. Thanks, Durga On Wed, Jan 11, 2012 at 12:58 PM, Simon Slavin wrote: > > On 11 Jan 2012, at 6:05am, Durga D wrote: > > > But, sqlite3_step(stmtoft1); is failing always. What might be the wrong > > with this approach. > >