Filenames using the Windows SQLite3 version of the CLI program now have to
be specified using forward-slashes, rather than the back-slashes used by the
SQLite2 CLI. Would someone kindly point me to where this change has been
documented, as my searches have so far proved fruitless?
Thank you in
Bob Gilson wrote:
We believe the disk writes are caused by fcntl(). Its updates to the
bits on the file can be has resource consuming as an fsync() or write().
fcntl(F_RDLCK) and fcntl(F_UNLCK) should be adjusting some data
structures inside the kernel only. Those calls should *never*
modify the
Hello SQLiters,
We're doing some benchmarks on our app using SQLite and it appears disk
writes are bottlenecking selects against cached data. The benchmark is
doing a series of selects only. The vast majority of these selects
return a single row. The database is small, 1000ish rows. It is cache
Hi all:
I am trying to compile sqlite-2.8.15 on a Solaris 8 machine using
gcc-3.4.1 and tcl-8.4.9. The compile goes cleanly, but when I run
"make test" (with the appropriate LD_LIBRARY_PATH), I get a
segmentation fault in the attach2-3.1. Since the testfixture isn't
compiled with debugging symbol
In my experience you have to create a custom control. If you are doing
this under MFC, subclass listbox or grid. IIRC there might be a table
class that is a good starter. I did something similar in a recent app
(BackupBuddy 2) using wxWidgets. Another alternative we are looking at
seriously
Hi,
Do errors encountered when using sqlite3_step(), sqlite3_bind(), and
other API functions which work on sqlite3_stmt's set the error message
string in the corresponding sqlite3 db structure?
The documentation leads me to believe that the answer is yes, but I
wanted to be sure.
Thanks,
Charl
I am creating a program for basketball coaches.
I am having big problems choicing a suitable class for my database.
It should be one for players i.e
player shirt-nr age rating and so on in columns then beneath the user should
be able to add in a row and by pressing the columns that columns get sor
I am creating a program for basketball coaches.
I am having big problems choicing a suitable class for my database.
It should be one for players i.e
player shirt-nr age rating and so on in columns then beneath the user should
be able to add in a row and by pressing the columns that columns get sor
Hi I am using sqlite3 on Linux.
I have a table with the following schema:
CREATE TABLE packagedet (
pkgno int not null,
policy_order int not null,
dayno int not null,
start time not null,
endtime time not null,
qosno int not null,
bytepulse real not null,
timepulse real not null
)
Keith Herold wrote:
OwnerID, AString, Sequence
1, 'concatenate', 0
1, 'some', 1
1, 'strings', 2
1, 'together', 3
What I need to do is create a single string out of the AString,
Sequence pairs, for a given owner. Obviously I could do this through
some C++ code, but I would prefer to do it within SQ
On Wednesday 05 January 2005 13:05, D. Richard Hipp wrote:
> Thorsten Schuett wrote:
> > have I missed something obvious or is my explanation that bad?
>
> Your original posting was lengthy and dense. I doubt many people took
> the time to read it.
Thanks for the kind paraphrase of "hard to read".
Thorsten Schuett wrote:
have I missed something obvious or is my explanation that bad?
Your original posting was lengthy and dense. I doubt many people took
the time to read it.
Can I make sqlite use a more complex index for the joins? E.g.:
foreach row_type in type where row_type.mdc_value="MDC_
Hi,
have I missed something obvious or is my explanation that bad? I would really
like to promote sqlite in our group but if joins are so slow that won't
happen. Any advice?
Thorsten
On Monday 03 January 2005 17:14, Thorsten Schuett wrote:
> Hi,
>
> I am currently porting an application from
I think it is not possible. You can't express an arbitrary loop with
SQL. Perhaps you could write a group-by user function doing this, I am
not sure, but user functions are again C code.
Jakub
Keith Herold wrote:
I have a semi-quick question about how to do successive string concatenation.
I hav
14 matches
Mail list logo