[sqlite] Simultaneosly using sqlite on windows

Hi, I've created application using SQLite as database (Windows application). The database is on remote server and application is accesing the database through file system (e.g. user connect server as P:\ disc and uses the path p:\databases\database.sdb). More users are accessing the database on

[sqlite] Like function - searching for "%"

Hi, I'm using `like` to search in text, but how could I look for percent symbol (%)?? It's wildcard so I cannot write down simply `where value like "11%"` cause that means to look for everytning that starts with "11", I've tried to double this char `where value like "11%%"` and it has no effect...

RE: [sqlite] Field name

> > Bronislav Klučka wrote: > > So there is nothing like C escape strings? (\", \',\\,etc.) > > And the way to do it is to leave the field name, column name or > string the > > way it is, close it into double quotes and duplicate all double > quotes in >

[sqlite] C\C++ interface

Hi, I usualy download every new version of SQLite, I'm writing my own Delphi interface but there is no change in description since 2003/10. Should that mean that there was no change? Brona - To unsubscribe, e-mail: [EMAIL

[sqlite] querying attached database

Hi, I've got two same databases (one is older then the second one) and I wanted to attach them, so I've done: attach database './database/produkty.sdb' as commodities2; select * from commodities left join commodities2.commodities on commodities.id = commodities2.commodities.id the second query

[sqlite] Obtaining the database file name

Hi, I have pointer returned from sqlite_open function call, how can I obtain the file name of the database having just that pointer? I could'n fing any API to do it. Brona - To unsubscribe, e-mail: [EMAIL PROTECTED] For

RE: [sqlite] SQLITE_SCHEMA error

> Bronislav Klučka <[EMAIL PROTECTED]> writes: > > > PLIIZ HELP ME > > > >> > > I've read the documentation, where is written: "When the > database first > >> > > opened, SQLite reads the database schema into memory and uses that &

[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

[sqlite] SQLITE_SCHEMA error

Hi, I've got a problem. I'm accessing the database from two separate connection, one connection perform CREATE TABLE (DROP TABLE) statement and then the second is performing 'SELECT name FROM sqlite_master WHERE type="table";', this causes the SQLITE_SCHEMA (17) error, I've read the documentation,

[sqlite] Pragma setting

HI, there are some PRAGMAs in SQLite sql language, is there way hoe to get info about how are they set? Brona - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] Querying 2 databases

Hi, I've already asked this question, but nobody answered... Is there any way how to ask 2 databases?? "select db1.table1.id,db2.table9.name from db1.table1 left join db2.table9 on db1.table1.id=db2.table9.id_object" Brona -

[sqlite] API functions description

Hi are there any web pages which describe the SQLite API functions? The page on offitial site is not complete... Brona - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] New expresion

Hi, is there some way how to do new statement? I want to create ALTER TABLE statement... I know that I can do it using temporary table, but I'm looking for another way... Brona - To unsubscribe, e-mail: [EMAIL PROTECTED] For

[sqlite] Field name

Hi, I've done this: create table 'brona''-klucka' ('brona''-kluc"ka' int) insert into 'brona''-klucka' ('brona''-kluc"ka') values (1); if I try: select * from 'brona''-klucka'; then it realy returns >1<, but how can I address the field? select "brona''-kluc"ka" from 'brona''-klucka';

[sqlite] PHP, queries between databases and network

Hi, I've got few questions: 1/ I've got sqlite like PHP module (under windows). I tried this: a)execute script 1 (selecting from some table), it tooks 2 minutes b)execute script 2 , it tooks 3 minutes c)execute them both at the same time (from different browser windows),

[sqlite] Busy database API functions

HI, when database (table, etc.) is locked, there are 2 API functions to handle it: "sqlite_busy_handler" and "sqlite_busy_timeout", the first is to try to execute query for as many times as you want and the second is to set the time limit before query result is set to "SQLITE_BUSY". I need

RE: [sqlite] Rewriting SQLite APIs to Delphi

I know where the mistake is: this > int *pN, /* OUT: Number of columns in result */ is not AColumnCount:PInteger; but var AColumnCount:Integer; Klucka - To unsubscribe, e-mail: [EMAIL PROTECTED] For

[sqlite] Rewriting SQLite APIs to Delphi

Hi there are 3 functions as described in SQLite homepage help int sqlite_compile( sqlite *db, /* The open database */ const char *zSql,/* SQL statement to be compiled */ const char **pzTail, /* OUT: uncompiled tail of zSql */ sqlite_vm **ppVm,