Thanks for the responses.
The ProcessExplorer was just the thing I needed! With it I can see
that sqlite _does_ release the file handle and that my program must
hold on to it in another way sometimes. Now I have to find that
sometime;)
Thanks again...
/Anders
--
On 11/29/06, Ralf Junker <[EMAIL PROTECTED]> wrote:
* SQLITE_EXTENSION_INIT1
If I compile both fts1 and fts2 into the same executable with
-DSQLITE_CORE=1
-DSQLITE_ENABLE_FTS1=1
-DSQLITE_ENABLE_FTS2=1
I receive a linker warning that sqlite3_api is defined in both fts1.c and
fts2.c.
The
Lloyd wrote:
Hi,
How much time can it take to perform 2000 selection queries on the
same database ? Mostly the result set will contain only 1 raw. Is there
is any way to improve the selection speed?
Thanks,
Lloyd
__
Scanned and protected by Email scanne
Sysinternals' Process Explorer can be used to verify that your process
does indeed still have a handle to the file, or search for another
process that does, if you need it.
http://www.microsoft.com/technet/sysinternals/ProcessesAndThreads/ProcessExplorer.mspx
In the .NET application case, make s
Kirrthana M wrote:
Hi,
Im new to sqlite,i have written a program to create a table and perform
the following operations
Insert,Delete,search.
To perform a search i used the query SELECT along with
sqlite3_exec..Execution is successful but the result is not displayed in the
screen.how to retriev
Christian Smith wrote:
John Stanton uttered:
If you use an extension greater than 3 chars you violate rules for
some existing file systems and reduce portability. You can also make
it difficult to parse the extension when it is used to type the file.
An extension of arbitray length shoul
I've had this same issue with files written by .net applications.
I haven't found what's causing mine yet... It might help to wait
10 seconds or so and retry the operation
On 11/29/06, Anders Holmberg <[EMAIL PROTECTED]> wrote:
Hi
I am using sqlite (version 3.3.7) on Windows and I am loading on
"Da Martian" <[EMAIL PROTECTED]> wrote:
> Hi
>
> Are there any powered by images for SQLite3?
>
A search for 'powered by sqlite' on google images
turned up two candidates for me. Both seem adequate,
though neither is great. You want to make a new
and better one and contribute it to the project
"Anders Holmberg" <[EMAIL PROTECTED]> wrote:
> Hi
>
> I am using sqlite (version 3.3.7) on Windows and I am loading one database
> (stored in a file) into another database (:memory:) using the attach /
> detatch scheme described on the sqlite site.
>
> My problem is that sqlite keeps hanging on t
[EMAIL PROTECTED] wrote:
>
> "SELECT * from database where STRING1 = 'x' && STRING2 = 'y' && STATE = 1
> && purpose = 'z'"
> "Create INDEX INDX on database( STRING1, STRING2, state, purpose)"
>
> i)
> If above index is present then the SELECT statement given,
> iterates to the all ro
Kirrthana M wrote:
To perform a search i used the query SELECT along with
sqlite3_exec..Execution is successful but the result is not displayed
in the screen.how to retrieve the result.Give me a suggestion.
Don't use sqlite3_exec. Use sqlite3_prepare, sqlite3_step,
sqlite3_column_*, sqlite3_f
[EMAIL PROTECTED] wrote:
"SELECT * from database where STRING1 = 'x' && STRING2 = 'y' &&
STATE = 1 && purpose = 'z'"
To achive this whether I need to attach given INDEX with the table so
that
during INSERT it will be inserted in a sorted order
"Create INDEX INDX on database( STRING1, STRING2,
Hi,
Im new to sqlite,i have written a program to create a table and perform
the following operations
Insert,Delete,search.
To perform a search i used the query SELECT along with
sqlite3_exec..Execution is successful but the result is not displayed in the
screen.how to retrieve the result.Give me
On 11/30/06, Lloyd <[EMAIL PROTECTED]> wrote:
Hi,
How much time can it take to perform 2000 selection queries on the
same database ? Mostly the result set will contain only 1 raw. Is there
is any way to improve the selection speed?
How on earth can anyone answer this question except for you
Cécilia Vigny wrote:
Hi,
Does SQLite supports the right(string, len) function ?
For instance :
SELECT myfield, right(myfield,5) FROM mytable
where myfield = "aaa";
I've got an error near '(' when executing this request.
http://www.sqlite.org/lang_expr.html
substr(X
I did try the ODBC driver, but I found it was quite a bit slower.
RBS
> RB Smissaert uttered:
>
>> Yes, that looks to be the way to do it. Basically will have to learn how
>> to
>> translate C defines to VB declares.
>
>
> Why not just use ODBC?
>
> http://www.sqlite.org/cvstrac/wiki?p=SqliteOdb
Hi,
Does SQLite supports the right(string, len) function ?
For instance :
SELECT myfield, right(myfield,5) FROM mytable
where myfield = "aaa";
I've got an error near '(' when executing this request.
Thanks.
Ce message est prot?g? par les r?gles relatives au secret de
RB Smissaert uttered:
Yes, that looks to be the way to do it. Basically will have to learn how to
translate C defines to VB declares.
Why not just use ODBC?
http://www.sqlite.org/cvstrac/wiki?p=SqliteOdbc
http://www.ch-werner.de/sqliteodbc/
That way, you're not even tied to SQLite.
RBS
John Stanton uttered:
If you use an extension greater than 3 chars you violate rules for some
existing file systems and reduce portability. You can also make it difficult
to parse the extension when it is used to type the file.
An extension of arbitray length should be just as easy to parse
Hi
Are there any powered by images for SQLite3?
Google seems at a loss which is unsual?
S
Hello Scott Hess,
>http://www.sqlite.org/cvstrac/tktview?tn=2046 should fix this for fts1 and
>fts2.
I have just tested them in both fts1 and fts2 and the reported problems no
longer show! Many thanks for the fixes!
Please allow me to report some (compiler-independent) compiler warnings about
Ok, Let me do it with C language
const unsigned char* Format(const char* szFormat, ...);
int AudioFillDatabase(const char* audiofile);
int main(void)
{
Open();
execDML(" CREATE TABLE IF NOT EXISTS AudioTable (id INTEGER , \n"
" name VARCHAR , \n"
Hi
I am using sqlite (version 3.3.7) on Windows and I am loading one database
(stored in a file) into another database (:memory:) using the attach /
detatch scheme described on the sqlite site.
My problem is that sqlite keeps hanging on to the first database even after
I have made a detach; whic
[EMAIL PROTECTED] schrieb:
the 2.4 kernel. If you are using win32 or mac os-x or linux
with a 2.6 kernel, this restriction does not apply.
Thats interesting ! Thanks !
Marten
-
To unsubscribe, send email to [EMAI
24 matches
Mail list logo