Re: [sqlite] errors compiling with MS VC++ 6.0

if it gives a different (more normal) error.. Randall Fox

Re: [sqlite] transient SQLITE_CORRUPT

rity_check; Perhaps that will tell you if you have integrity problems on the db.. Randall Fox *

[sqlite] PRAGMA user_version

I am trying to use "PRAGMA user_version;", but it doesn't seem to work with my version of Sqlite, 3.08. What version is this feature in? I also checked the pragma.c file, from the website CVS, and I didn't see any notes about it being added since 3.08.. Thanks Randall Fox

[sqlite] Cluster Indexes

What type of select query would benefit from cluster indexes in SQLITE3 ? If you can, an example would be nice.. I found the following in the wiki, but it doesn't explain much.. Use cluster indexes Clustered indexes are indexes that comprise more than one column. These increase the speed of qu

Re: [sqlite] Do _ErrMsg strings have to be freed?

On Mon, 7 Feb 2005 18:14:42 -0800, you wrote: >Does this > >var > pMsg: PChar; > >.. >pMsg := SQLite3_ErrMsg(aDB); > >necessitate this? > > if pMsg <> nil then SQLite3_Free(pMsg); It depends. If you use sqlite3_exec, then yes, if you use the other method (sqlite_prepare) then I would say

Re: [sqlite] still struggling with "Database schema has changed" errors

Seems the attachment is automatically removed on the mailing list. I will go ahead and send it to those who request it. Just send me a request and I will send it to you. Randall Fox

Re: [sqlite] still struggling with "Database schema has changed" errors

e, use a program like Examdiff and compare it to the same file in the source code. It will show the differences. I used 3.08 as the source, but I would bet the file is the same in the current version.. Randall Fox

Re: [sqlite] SQLite 3.0.8 dates

hen you select out of SQLITE, have it do the conversion for you. You can also convert when inserting or updating if you want. I prefer the julian because it smaller, and I have no worries about sorting by that column. Anything fancy and I use SQLITE to do the format conversions, which is rare. Randall Fox

Re: [sqlite] still struggling with "Database schema has changed" errors

and line switch for the TCL sqlite3 instruction. Randall Fox

Re: [sqlite] still struggling with "Database schema has changed" errors

s opening the database twice, and when I would create a table with one of the open instances, the other would get the schema error the next time I started a write operation. I did end up fixing it by rewriting part of the SQLITE code. Randall Fox

Re: [sqlite] quick question regarding INTEGER PRIMARY KEY default value

function sqlite3_column_int to represent NULL. The only safe way is to either not allow zero as a key entry, or get the fkey as a text value. Randall Fox

Re: [sqlite] embedded TCL and sqlite in one app

ee if it is healthy. I assume the user is smart enough to know. If you feel it is worthy, use the changes in your next release. I would prefer if you did, since I won't have to maintain the code myself.. :) Randall Fox

[sqlite] embedded TCL and sqlite in one app

) in a TCL script, and the next time I attempted to write to the database using the application's handle, I got an error -- schema modified. As a developer, I know reissuing the database write will work, but that is hard to explain to a user who sees a flakey program. Thanks Randall Fox

[sqlite] Sqlite Binding

indings a lot in those cases you mentioned. Without it, you would need to alter the sql statement instead of having a simple IF statement. I guess you would bind NULL with the sqlite3_bind_null. Speaking of bindings, is there any chance of allowing the '?' use in a create table statement as well? For binding of default values of a particular column. Thanks Randall Fox

Re: [sqlite] upgrade?

r defines to handle many of the SQLITE calls. But in the end, I had to change my src as well.. Randall Fox

[sqlite] Is it possible to BIND in a CREATE TABLE

I have a CREATE TABLE sql command with DEFAULT values. I would like to BIND the default values, but it seems it is not supported. Is this so? I am using SQLITE3.. Any help appreciated. Randall Fox

Re: [sqlite] DATABASE SCHEMA HAS CHANGED

he original poster didn't say what version, and a follow up mentioned the sqlite3 structure, so I assumed it was v3. Good to know it is not a problem. Randall Fox

Re: [sqlite] DATABASE SCHEMA HAS CHANGED

gt;VACUUM again, that is.) This sounds like a major bug. I use Sqlite embedded in my app and an error like that could be catastrophic. Should I close and reopen the DB every time after a vacuum? Is there a fix? I was not able to recreate the error but I just upgraded to v3 today so I am still tes

Re: [sqlite] What does the first expr do in a CASE statement ?

On Fri, 17 Sep 2004 19:49:34 -0600, you wrote: >Randall Fox wrote: > >>What does the first expr do in a CASE expression ? >> >>I understand the rest of the syntax, but I don't get what the very >>first expr (after the keyword "case") does.. And I co

[sqlite] What does the first expr do in a CASE statement ?

What does the first expr do in a CASE expression ? I understand the rest of the syntax, but I don't get what the very first expr (after the keyword "case") does.. And I couldn't find the answer in the documentation or wiki.. Thanks Randall Fox

[sqlite] Any speed advantage in a view

I am coding a program that uses SQLITE and I am wondering if there are any advantages (speed?) to using a preset view instead of hard coding the SELECT query into the source code? Is the view precompiled at all? Thanks Randall Fox

Re: [sqlite] Alternating Output

do the trick.. Thank you for your input though. Randall Fox

Re: [sqlite] Alternating Output

ry of user written functions somewhere that I can browse? Thanks Randall Fox

Re: [sqlite] Alternating Output

The trigger is a nice idea, but renumbering the index won't work, since the index might be used as a key to link the record to another table.. I guess I could use a new index, just for this purpose but that seems to be a waste of resources.. How do you renumber an index anyway? Randal

Re: [sqlite] Alternating Output

variable that toggles between two supplied strings each time. I am just wondering if it was done or there is an easy way.. Thanks Randall Fox On Wed, 21 Jul 2004 08:55:09 -0500, you wrote: >> Is there an easy way to have an "alternating" column value ...? > >No easy or relia

[sqlite] Alternating Output

row3=grey, row4 = white, etc... Thanks Randall Fox

Re: [sqlite] Another way of corrupting the database.

On Tue, 20 Jul 2004 07:21:43 -0500, you wrote: >>> Is there any way to determine the sqlite version ... ? > >Look at the first 47 bytes of the file -- or the first 48 >bytes if you want a null-terminated string. That works.. Thank you.. Randall Fox

Re: [sqlite] Another way of corrupting the database.

of my head I can't think of a way to do it easily. I guess in the end I would need to include both versions of the sqlite db engine inside the application, in order to do a conversion from 2.x to 3.x.. Randall Fox On Mon, 19 Jul 2004 09:08:47 -0400, you wrote: >George Ionescu wrote: &

Re: [sqlite] SQLite performance with mid-size databases

either access is taking advantage of this, or is caching it from w/in the DB itself.. Also, did you implement a integer primary key, and use indexing? Randall Fox - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Adding and subtracting decimals is not accurate

to make a special "MONEY" type for users, and every time convert it to cents.. Hmm.. Thanks Randall Fox - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Adding and subtracting decimals is not accurate

ificant digits sooner or later.. Randall Fox - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] Adding and subtracting decimals is not accurate

. Is there a work around to accurately add fixed point numbers? Or more generally, has this been addressed before? I couldn't find any reference to it on the FAQ or web site.. This problem becomes more obvious when the 1.2 is interpreted as $1.20 Thank you R