[sqlite] newbie asks for help2: is it faster to store the larger files in a seperate table??

Hello everybody, i have an additional question now. I have a database which contains 2 tables. One of the table has only strings information. And the other one has larger files. Is it faster to store the larger files in a seperate table?? Or should I merge these two tables? thanks, Martin

Re: [sqlite] How to find the primary key ?

Bertrand Mansion wrote: Hi, I have been through the archives on yahoo groups and found a mail that said the current way to find the primary key in sqlite is to write your own sql parser. This was back in May 2003. Is this still the only way ? This looks tough to achieve, there seems to be so many

Re: [sqlite] How to find the primary key ?

You can try splitting the create-table statement on the regular expression [,()]|\s+. (The . is not part of the RE.) Then you need to look at the tokens that match the RE and at the strings between those tokens. With this method, I needed about 400 lines of tcl to do a complete parse with error

[sqlite] SQLITE_SCHEMA error

I've send it two times, I'm sending it again, cause it's realy problem ::(, I hope somebody could know the answer Brona > > Really nobody knows? it's serious problem to me... > > Brona > > > > > Hi, > > I've got a problem. I'm accessing the database from two separate > > connection, > > one co

[sqlite] How to find the primary key ?

Hi, I have been through the archives on yahoo groups and found a mail that said the current way to find the primary key in sqlite is to write your own sql parser. This was back in May 2003. Is this still the only way ? This looks tough to achieve, there seems to be so many things to take into con

Re: [sqlite] sqlite.org - cant open db

Nemanja Corlija wrote: Is anyone having problems with dynamic pages on sqlite.org for last few days? Thanks to everybody who sent me email about this problem. All 12543 of you :-) FWIW, I had found the problem myself at about 8am EST on Wednesday, but was unable to resolve the trouble before I was

Re: [sqlite] Column names without the callback function

- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] Column names without the callback function

Hi All, I've just started with sqlite, I discovered it a week ago. What I missed was a program to browse the database and open tables in a grid on a form. So I built it myself as a project to learn how to work with sqlite. There is one problem I could not solve and thats an empty recordset. When