Re: [sqlite] binding paramters for SELECT

On 8/8/06, Dixon <[EMAIL PROTECTED]> wrote: I have prepared the following wide text string: L"SELECT ROWID FROM indext WHERE state='1' AND clientName='?' ORDER BY size DESC" with sqlite3_prepare16, I then call sqlite3_bind_parameter_count on the resulting statement. I get 0 back

[sqlite] ANN:SQLtTableImprot - Free SQLite to SQLite Table Import Tool

SQLtTableImprt is a little tool for importing a table from one SQLite database into another SQLite database. - This can easily be done in SQL with ATTACH DATABASE. - SQLtTableImprt automates the process. - Windows only. - Should work with any SQLite Type 3 database that the Window's file system

Re: [sqlite] primary key information

another way "SELECT rowid FROM MyTable LIMIT 1" the column name returned will be the Integer Primary Key StanD sd at sqlight.com - Original Message - From: "Mario Frasca" <[EMAIL PROTECTED]> To: Sent: Monday, August 07, 2006 9:33 AM Subject: Re: [sqlite]

Re: [sqlite] Insert delay!

Cesar David Rodas Maldonado wrote: Yeah John I am studying Math and computer science (but i am in the first year, and this is very boring) in National University Of Paraguay. When I finish my idea i will share my code. Thanks For understand my English John! On 8/5/06, John Stanton <[EMAIL

Re: [sqlite] what tier architecture?

John Newby wrote: Hi, this is probably a stupid question and it has nothing to do with SQlite per se so I apologise in advance for hijacking the emails withmy question plus I don't even know if this is the right place to ask the question. I have created a GUI to SQLite using VB.Net for my

Re: [sqlite] About Triggers

chetana bhargav uttered: Hi, I have few questions regarding triggers, * If we want to have trigger for some condition and if multiple applications create a trigger for the same condition providing different C callback functions (which I guess is possible through sqlite3_create_function),

RE: [sqlite] Replace of substring in sqlite-table - how can I do this?

Hi Wolfgang, Regarding: "...thank you very much for your reply. But is there no command within sqlite to do this? In my case, only substrings of the cells of one column need to be changed!" Sqlite was designed as a small SQL library -- extremely small, considering its capabilities --

Re: [sqlite] what tier architecture?

Hi Jay, I will be writing about the technical details within the implementation stage of my report, but I wanted to write about the architecture in the design part of the report. Thanks for your advice. John On 07/08/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote: On 8/7/06, John Newby <[EMAIL

Re: [sqlite] About Triggers

- Last time I tried, the triggers are triggered only for the calling thread which registered the function. Can you elobarate more on this. ( For me if two threads register for the same trigger condition, with different callback functions, do both the functions get called)

Re: [sqlite] what tier architecture?

Hi Michael, thanks for your help, it is much appreciated. Thanks again John On 07/08/06, Michael Ruck <[EMAIL PROTECTED]> wrote: From your description I would consider this a one-tier architecture. Ussually the tiers are defined as follows: - Presentation GUI, all user interaction. -

Re: [sqlite] Insert delay!

Yeah John I am studying Math and computer science (but i am in the first year, and this is very boring) in National University Of Paraguay. When I finish my idea i will share my code. Thanks For understand my English John! On 8/5/06, John Stanton <[EMAIL PROTECTED]> wrote: Cesar David Rodas

Re: [sqlite] what tier architecture?

On 8/7/06, John Newby <[EMAIL PROTECTED]> wrote: Hi, this is probably a stupid question and it has nothing to do with SQlite per se so I apologise in advance for hijacking the emails withmy question plus I don't even know if this is the right place to ask the question. I have created a GUI to

AW: [sqlite] what tier architecture?

>From your description I would consider this a one-tier architecture. Ussually the tiers are defined as follows: - Presentation GUI, all user interaction. - Business Logic Logic, which can not be expressed by constraints in the database. Interaction with other (software) systems and some more

[sqlite] what tier architecture?

Hi, this is probably a stupid question and it has nothing to do with SQlite per se so I apologise in advance for hijacking the emails withmy question plus I don't even know if this is the right place to ask the question. I have created a GUI to SQLite using VB.Net for my University project and

Re: [sqlite] Replace of substring in sqlite-table - how can I do this?

Hi Peter, thank you very much for your reply. But is there no command within sqlite to do this? In my case, only substrings of the cells of one column need to be changed! Best regards, Wolfgang Am Montag 07 August 2006 pH:19:16 nachmittags/abends schrieb Peter Cunderlik: > On 8/7/06, wqual

Re: [sqlite] primary key information

Nemanja Corlija wrote: I think in any other case unique index would be created as expected. sqlite> drop table test; sqlite> create table test (ni integer, pk_name varchar(32) primary key, info integer); sqlite> pragma index_list(test); 0|sqlite_autoindex_test_1|1 sqlite> pragma

Re: [sqlite] Replace of substring in sqlite-table - how can I do this?

On 8/7/06, wqual <[EMAIL PROTECTED]> wrote: Hi list, I have sqlite 3.2.1 installed on my computer. Now, I need to replace some substrings in my sqlite-table (for example, replace 'strasse' with 'str.' , german 'ä' with 'ae' etc.). Can I search for the substrings and replace them by another one?

[sqlite] Replace of substring in sqlite-table - how can I do this?

Hi list, I have sqlite 3.2.1 installed on my computer. Now, I need to replace some substrings in my sqlite-table (for example, replace 'strasse' with 'str.' , german 'ä' with 'ae' etc.). Can I search for the substrings and replace them by another one? I do not know, what would be the right

[sqlite] About Triggers

Hi, I have few questions regarding triggers, * If we want to have trigger for some condition and if multiple applications create a trigger for the same condition providing different C callback functions (which I guess is possible through sqlite3_create_function), will the trigger be

Re: [sqlite] primary key information

On 8/7/06, Mario Frasca <[EMAIL PROTECTED]> wrote: I was a bit wondering: does the declaration 'primary key' actually produce an indexing? or does that happen only if I explicitly ask for a (unique) index? It usually does create unique index for you. But in this case, INTEGER PRIMARY KEY, it

Re: [sqlite] primary key information

Nemanja Corlija wrote: If you turn the headers on (.header ON) you'll see that the last column of table_info() output is "pk". This column indicates weather or not the table column in question is part of primary key. Though that last column of table_info() pragma is missing from documentation

Re: [sqlite] primary key information

On 8/7/06, Mario Frasca <[EMAIL PROTECTED]> wrote: hallo, list... how do I get primary key information about a table? [EMAIL PROTECTED]:~$ sqlite3 /data/mariof/test.db SQLite version 3.3.6 Enter ".help" for instructions sqlite> drop table test; sqlite> create table test (pk integer primary

[sqlite] primary key information

hallo, list... how do I get primary key information about a table? [EMAIL PROTECTED]:~$ sqlite3 /data/mariof/test.db SQLite version 3.3.6 Enter ".help" for instructions sqlite> drop table test; sqlite> create table test (pk integer primary key, name varchar(32), info integer); sqlite> create

Re: [sqlite] From Windows file format to MacOSX (ok!)

Ok, it seems to work when I set the PRAGMA right away, then create a table and insert one or two rows. I then exit the sqlite3 command line, export my data from access to sqlite3 through an ODBC adaptor. It is readable on the MacOSX side. Now, I have to figure how to use it in a CoreData

Re: [sqlite] date data types

Kees Nuyt wrote: Will PRAGMA table_info(tablename); do? >>> from pysqlite2 import dbapi2 >>> db = dbapi2.connect('/data/mariof/test.db') >>> cr = db.cursor() >>> cr.execute('pragma table_info(test3)') >>> cr.fetchall() [(0, u'd', u'date', 0, None, 0), (1, u'h', u'time', 0, None, 0), (2,