Re: [sqlite] How to create a database in run-time

2008-01-22 Thread Dennis Cote
Luis Esteban Fajardo Bravo wrote: my question is if there's a better solution for check if the database is already created, something like a "describe" SQL Command (in oracle) that help to know if the schema is already there on the database? Luis, You can use the pragma user_version

RE: [sqlite] How to create a database in run-time

2008-01-22 Thread Lee Crain
I'm not responding to your entire email, only the question far below. On my employer's system, we use a query named "$CMD_ISDATABASECONSTRUCTED" to check for whether the database is created. The query is simple: "Analyze Categories;" If the Categories table does not yet exist, the query

Re: [sqlite] How to create a database in run-time

2008-01-21 Thread John Stanton
Luis Esteban Fajardo Bravo wrote: Hi! we've using SQLite on our software since about a month ago, and still i have some questions about how does sqlite works at all. I have the following sourcecode to check if a database is already created, if yes then just open, if not, open it and create

[sqlite] How to create a database in run-time

2008-01-21 Thread Luis Esteban Fajardo Bravo
Hi! we've using SQLite on our software since about a month ago, and still i have some questions about how does sqlite works at all. I have the following sourcecode to check if a database is already created, if yes then just open, if not, open it and create the appropiate schema for the