[sqlite] delphi sqlite strings

hi- in my attempt to generate a createTable syntax when i come across the default keyword i run into a slight problem. i want to write DEFAULT'something could be more than one word' it seems to get inserted as default \'something could be more than one word\' into the sqlite table one

Re: [sqlite] ALTER TABLE substitute?

On 6 ene 2005, at 18:01, aleks ponjavic wrote: What I want to do is drop and add columns, couldn't find something appropriate with sqlite, atleast it doesn't seem as ALTER TABLE works, how can I do it instead? Maybe it isn't possible? Please check the archives. It's been discussed already:

[sqlite] ALTER TABLE substitute?

What I want to do is drop and add columns, couldn't find something appropriate with sqlite, atleast it doesn't seem as ALTER TABLE works, how can I do it instead? Maybe it isn't possible? _ Express yourself instantly with MSN

Re: [sqlite] bug in btree code 3.0.8

Ted Unangst wrote: D. Richard Hipp wrote: Provice specific SQL that causes a problem. The same btree code has been in use for ages and there are many tests that do what you describe above. You are the first person to ever see this problem. Also say what OS and compiler you are using. sql

Re: [sqlite] sqlite3_open() exclusive?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Andrew Piskorski wrote: | On Fri, Dec 24, 2004 at 07:32:07PM -0500, John Richard Moser wrote: | | |>I thought sqlite databases weren't supposed to be opened with two sqlite |>processes at once. There are unimplemented locking commands due to this

Re: [sqlite] bug in btree code 3.0.8

Ted Unangst wrote: I can provide sample sql statements to trigger this, although it seems nearly any will do, provided: 1. you insert inside a transaction. 2. there is an index on one of the table's fields. 3. there's at least around 100 inserts. Anything else I can do to help? Provice specific

[sqlite] bug in btree code 3.0.8

I'm not sure of the solution to this, but hopefully I can provide enough information to diagnose or reproduce the problem. The problem occurs at around line 3278: pCell -= 4; Sometimes, this sets pCell out of bounds. For instance, apCell is the return of this malloc: 65026 sqlite3 USER malloc

[sqlite] Detecting changes/last insert rowid question

I know I can recover the last_insert_rowid() in SQLite in the SQL query itself; is there an equivalant SQL function to sqlite_changes or sqlite_last_statement_changes (from 2.8.15)? If, for example, an insert doesn't take place, I get the last id of the insert *before* this one. What I would

[sqlite] pager for sqlite?

I installed sqlite in NetBSD running on a NEC MobilePro 780. (The hardware is relevant because of its short screen.) When I execute commands in sqlite, much of the output scrolls off the top of the screen. Can sqlite be configured to use a pager such as less or more? Thanks, Andrew Gould

Re: [sqlite] disk write bound while doing selects?

D. Richard Hipp wrote: Bob Gilson wrote: We believe the disk writes are caused by fcntl(). Its updates to the bits on the file can be has resource consuming as an fsync() or write(). fcntl(F_RDLCK) and fcntl(F_UNLCK) should be adjusting some data structures inside the kernel only. Those calls