Re: [sqlite] Problems compiling in Windows-32

Hello A.J.Millan, I compile my own using MSVC G and VS2005. You're not exactly describing what errors you're getting so, it's going to be hard to help. Endless loop of what? I'll probably try 3.3.10 tonight. I haven't upgraded yet. I've not had any problems building up to this point though. C

Re: [sqlite] does select reliably return insert order?

"Kevin Dangoor" <[EMAIL PROTECTED]> writes: > I'm using sqlite as a temporary store for flattened report database > (generally just one table). This data is pulled out in chunks using > OFFSET and LIMIT. This particular setup is quite simple... just insert > all of the data, and then pull it out

Re: [sqlite] does select reliably return insert order?

On 1/19/07, Kevin Dangoor <[EMAIL PROTECTED]> wrote: What I'm wondering about is whether I should put an integer primary key on the data table to ensure that the ordering is correct, or if "SELECT * FROM LIMIT OFFSET " will reliably return data in the same order in which is was inserted. It

[sqlite] does select reliably return insert order?

Hi, I'm using sqlite as a temporary store for flattened report database (generally just one table). This data is pulled out in chunks using OFFSET and LIMIT. This particular setup is quite simple... just insert all of the data, and then pull it out chunk by chunk afterwards. What I'm wondering

Re: [sqlite] Moving data from one table to a new table

Never mind... sorry. http://www.sqlite.org/faq.html#q13 - Original Message - From: "jose isaias cabrera" <[EMAIL PROTECTED]> To: Sent: Friday, January 19, 2007 9:44 AM Subject: [sqlite] Moving data from one table to a new table Greetings! I have this

Re: [sqlite] Moving data from one table to a new table

On 1/19/07, jose isaias cabrera <[EMAIL PROTECTED]> wrote: Greetings! .. Or the better question would be, can I add more columns to an already existing table? If there are answers to both questions, will someone point me to where I can get the answers? Or answer them? Thanks.

[sqlite] Moving data from one table to a new table

Greetings! I have this table, CREATE TABLE OpenJobs ( id primary key, login, cust, proj, bdate date, edate date, pm,