Re: [sqlite] PRAGMA journal_mode=WAL;

Guy Terreault wrote: Hi, Simon. I have been reading your back and forth answers like the next 4 responce. And I am still waiting for the example that works in c code like the one that Bill McCormick that is wrong. Why do you not include in your answer a working correction of the c code so

[sqlite] File checking mechanism.

Hi Friends, Is there any File checking mechanism in sqilte3. Suppose i have a file ABCD.db, before i want to create the data base file, i want to check whether it is already exit with the same or not. If it is exist returns an error. Is there any sqlite function to

Re: [sqlite] File checking mechanism.

On Wed, Feb 1, 2012 at 1:37 PM, bhaskarReddy wrote: > > Hi Friends, > >         Is there any File checking mechanism in sqilte3. > >         Suppose i have a file ABCD.db, before i want to create the data > base file, i want to check whether it is already exit with the same or

Re: [sqlite] PRAGMA journal_mode=WAL;

On 12-02-01 03:03 AM, Larry Brasfield wrote: Guy Terreault wrote: Hi, Simon. I have been reading your back and forth answers like the next 4 responce. And I am still waiting for the example that works in c code like the one that Bill McCormick that is wrong. Why do you not include in your

Re: [sqlite] joint two table

Thanks it work. I don't know that sqllite save TIMESTEMP as string, problem is with counting i have to use helpful function like as strftime('%s',timestampevar) .. but ... comparative operator <> = BETWEEN is right. Thanks Igor Tandetnik wrote: > > ... > You probably want something

Re: [sqlite] PRAGMA journal_mode=WAL;

On 01.02.2012 09:32, Guy Terreault wrote: On 12-02-01 03:03 AM, Larry Brasfield wrote: I cannot answer why Simon does not write demo code at every opportunity, but I think I speak for more than just myself by revealing that I have other work, and a life, and consider time a scarce resource.

Re: [sqlite] PRAGMA journal_mode=WAL;

On 12-02-01 04:32 AM, Marcus Grimm wrote: On 01.02.2012 09:32, Guy Terreault wrote: On 12-02-01 03:03 AM, Larry Brasfield wrote: I cannot answer why Simon does not write demo code at every opportunity, but I think I speak for more than just myself by revealing that I have other work, and a

Re: [sqlite] PRAGMA journal_mode=WAL;

On 01.02.2012 11:10, Guy Terreault wrote: On 12-02-01 04:32 AM, Marcus Grimm wrote: On 01.02.2012 09:32, Guy Terreault wrote: On 12-02-01 03:03 AM, Larry Brasfield wrote: I cannot answer why Simon does not write demo code at every opportunity, but I think I speak for more than just myself

Re: [sqlite] PRAGMA journal_mode=WAL;

On 1 Feb 2012, at 7:41am, Guy Terreault wrote: > I have been reading your back and forth answers like the next 4 responce. > > And I am still waiting for the example that works in c code like the one that > Bill McCormick that is wrong. > > Why do you not include in your answer a working

Re: [sqlite] File checking mechanism.

On Wed, Feb 1, 2012 at 9:07 AM, bhaskarReddy wrote: > Suppose i have a file ABCD.db, before i want to create the data > base file, i want to check whether it is already exit with the same or not. > If it is exist returns an error. > See

[sqlite] ANN: SQLite Maestro 12.1 released

Hi! SQL Maestro Group announces the release of SQLite Maestro 12.1, a complete Windows GUI solution for SQLite database management. The new version is immediately available at http://www.sqlmaestro.com/products/sqlite/maestro/ Top 10 new features = 1. SQL Editors: unicode

[sqlite] Cannot insert/retrieve 8 byte integers without losing digits

I have some very large integers I need to insert and retrieve from SQLite without losing any digits. These numbers can be up to 8 bytes (20 digits) long. The SQLite documentation says INTEGER datatypes can hold values up to 8 bytes long, however, when I insert any number greater than 17 digits,

Re: [sqlite] Cannot insert/retrieve 8 byte integers without losing digits

On Tue, Jan 31, 2012 at 4:32 PM, Richard D Watkins < richard.d.watk...@seagate.com> wrote: > I have some very large integers I need to insert and retrieve from SQLite > without losing any digits. These numbers can be up to 8 bytes (20 digits) > long. > SQLite integers are 8-byte twos-complement

Re: [sqlite] joint two table

Pawl wrote: > I don't know that sqllite save TIMESTEMP as string, problem is with > counting i have to use helpful function > like as strftime('%s',timestampevar) .. but ... comparative operator <> = > BETWEEN is right. It only seems this way, because all dates in your

Re: [sqlite] SQLite on Visual Studio 2010

This is for reference of those who might be searching the archives of this list for solutions to this same issue: After Joe's reply yesterday I searched for SQLite designer tools and came across this extra-ordinarily useful post:

[sqlite] Perl script to output to file

From the sqlite command line interface, the .output command will output the result of a query to a file. How can I do this from a Perl script? I'm not finding any built-in facility to do this in the Perl module. I found this (http://members.toast.net/strycher/perl/example_dbi_sql.htm), but

Re: [sqlite] Perl script to output to file

On 1 Feb 2012, at 4:20pm, Bill McCormick wrote: > From the sqlite command line interface, the .output command will output the > result of a query to a file. > > How can I do this from a Perl script? I'm not finding any built-in facility > to do this in the Perl module. The '.output' command

Re: [sqlite] Perl script to output to file

On Feb 1, 2012, at 10:20 AM, Bill McCormick wrote: > From the sqlite command line interface, the .output command will output the > result of a query to a file. > > How can I do this from a Perl script? I'm not finding any built-in facility > to do this in the Perl module. > pseudocode

[sqlite] How to return many data sqlite extension

Hi everyone i hope that you are ok. so im doing a sqlite extension that generate many data, i have a structure something like that: struct data { char *name; int age; }; in the precess y create a listo of data: data *t = malloc(5 * sizeof(data)) i need to return that values in order that the

[sqlite] Testing a new SQLite Data Provider with SQLite?

I am in the process of writing a new SQLite Data Provider, but I'm a bit confused about testing it. Do I need to have SQLite3.exe installed to manually create a test database? and then I assume I need the SQLite DLLs for that App that communicates with the database. Is that correct? -- View this

Re: [sqlite] Testing a new SQLite Data Provider with SQLite?

On 1 Feb 2012, at 8:22pm, LouOttawa wrote: > I am in the process of writing a new SQLite Data Provider, but I'm a bit > confused about testing it. Do I need to have SQLite3.exe installed to > manually create a test database? and then I assume I need the SQLite DLLs > for that App that

[sqlite] Tracking error 11 : database disk image is malformed.

Hello All, I have been in the process of getting SQLite 3.7.7.1 working on our ARM based platform and using WAL on some of our database files. Yesterday, I kept getting: Error = 11 : database disk image is malformed We have seen this issue before, but not quite like this. We were manually

Re: [sqlite] joint two table

Can I eliminate this problem by using function strftime('%s',timestampevar) it try to rewrute: select * from JX, JX_lim lim1 where lim1.rowid = ( select rowid from JX_lim lim2 where strftime('%s',lim2.edittime) <= strftime('%s',JX.starttime) order by lim2.edittime desc limit 1 it

Re: [sqlite] joint two table

On 2/1/2012 4:13 PM, Pawl wrote: Can I eliminate this problem by using function strftime('%s',timestampevar) Your strings are not in any format that strftime accepts. strftime('%s', '15.01.2011') returns NULL. You really, really should change the format of your timestamps. You could do it

Re: [sqlite] Tracking error 11 : database disk image is malformed.

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/02/12 12:57, Korey Calmettes wrote: > What would cause rows to disappear from an index? The answer is always the same for corruption. One or more of the following happened: http://www.sqlite.org/howtocorrupt.html Roger -BEGIN PGP

[sqlite] How to find type of value that a column contains.

Hi Friends, I have to find a type of a value in sql. Suppose if i pass to a function with column names and values. I want to find the 'type' for that values first, suppose if it is an INTEGER i will do some steps, if it is TEXT some other steps. How to