Re: [sqlite] Control the scheme layout

Hello Delf, Look at the PRAGMA commands: http://www.sqlite.org/pragma.html#schema HTH Philipp >> If I understand your question, the FAQ may help: >> >> http://sqlite.org/faq.html#q9 > > Oops, I did not see this point. But the FAQ does not explain how to retreive > the > field names from a

Re: [sqlite] Testing for table existence?

> Hi, > > How can I test for the existence of a single table in a SQLite database? > > I tried sqlite3_get_table with "select * from persons" to test for the > existence of the table 'persons' and I had hoped the return value would be > SQLITE_NOTFOUND in the case of a non-existent table.

Re: [sqlite] How to get the schema

> Is there another way to get the column schema besides parsing the original > CREATE TABLE command? > > thx > -Brett G. > > > This message was sent using IMP, the Internet Messaging Program. Hello Brett You can access the

Re: [sqlite] Problems with character '

> Hi Guys > > I'm having some problems dealing with the character '. Sqlite thinks > fair enough that it should terminate the string, which I would like it > to avoid. Are there any solutions to my problems. > > Thanks, Niels Hello Niels try: sqlite> CREATE TABLE t (id INTEGER, bez TEXT);

Re: [sqlite] Managing trees in the database

SanjayK schrieb: Since SQLite is perfect for use in single-user desktop utility applications and since such applications typically store hierarchial data (tree) in a single table, it would be nice to have support for special features like connect by of oracle. See:

[sqlite] Using variables within trigger definitions

Hello SQLite Users Is there a possibility to define variables within trigger definitions? I would like to to something like this (simplified example): CREATE TRIGGER Side_Insert AFTER INSERT ON Side BEGIN SET LOWDATE = SELECT MIN(Startdate) FROM Basis; INSERT INTO BASIS

[sqlite] [OT] SQL: limit a query by sum(val)?

Hello SQLite-Users This is offtopic, but as I would like to use it within SQLite... so let's try: I would like to reduce the resultset of a query like using limit. But instead of using the number of records by the sum of values. A small example: create table t1 (val int, period text); insert into

[sqlite] [OT] SQL: limit a query by sum(val)?

Hello SQLite-Users This is offtopic, but as I would like to use it within SQLite... so let's try: I would like to reduce the resultset of a query like using limit. But instead of using the number of records by the sum of values. A small example: create table t1 (val int, period text); insert into