Re: [sqlite] binding paramters for SELECT

Nemanja had the solution I needed. DRH, I figured out what prepare16 was doing vs prepare as I had dug down there with the debugger once. I think if I was preparing anything with non-ascii characters then prepare16 is a little easier as those characters are likely to originate it UTF-16 inter

Re: [sqlite] how to unsubscribe this mail list

Thank you very much - Original Message - From: "Gunnar Roth" <[EMAIL PROTECTED]> To: Sent: Wednesday, August 02, 2006 3:15 PM Subject: Re: [sqlite] how to unsubscribe this mail list > jason zhang schrieb: >> Hi All, >> I don't find the method to unsubscribe this mail list from www.sqlit

Re: [sqlite] binding paramters for SELECT

"Nemanja Corlija" <[EMAIL PROTECTED]> wrote: > 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 sqlit

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 when

[sqlite] binding paramters for SELECT

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 when I expected 1. Is this an invalid way to spe

[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] Insert delay!

I know that that Math and CS is very cool, but in the beginning is very boring. I will share my code in the next week. I am doing something like lucene ( a library for fulltext search). On 8/7/06, John Stanton <[EMAIL PROTECTED]> wrote: Cesar David Rodas Maldonado wrote: > Yeah John I am stud

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] primary key information Nem

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 PROT

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 Univer

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 -- implementin

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 P

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) Cheer

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. - Busin

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 M

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 SQ

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 l

[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 it

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 <[E

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 table_info(t

Re: [sqlite] About Triggers

- Last time I tried, the triggers are triggered only for the calling thread which registered the function. - When the trigger is fired, you can refer to any field in the table. HTH. On 07/08/06, chetana bhargav <[EMAIL PROTECTED]> wrote: Hi, I have few questions regarding triggers, * If we

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? I

[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 synta

[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 o

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 key,

[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 u

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 appl