Hi Sqlite Team,
>insert into disk.your_table select * from your_table;
There is an bugwithin insert into table01 select * from table02
Always double the inserted rows in table01 ...
where the structure of table01 and table02 are the same
I use Sqlite 3.3.2b
Shum
www.mingyik.com
I've seen this same behavior when running a MinGW-compiled sqlite3.exe in the
cygwin shell. It has
something to do with the lack of flushing of information written to stdout
(until close() anyway).
If you blindly type in the sqlite commands - it does work. Once you exit the
shell via .q you can
In my table(s) I need to model a class hierarchy, as well as a
class/var/function belonging to a namespace, and/or a function/var
belonging to a class. In other words a parent/child relationship. If I
simply add a new column to my primary symbols table, call it
"Parent", how would I query for a
> -Original Message-
> From: Nono BEZMan [mailto:[EMAIL PROTECTED]
>
> My point was that there is light for windows users, if
> this
> FILE_FLAG_WRITE_THROUGH flag is added to the code.
> Otherwise, it seems that
> FlushFileBuffers really hinders SLQite to a point it
> becomes unusable.
Hello drh,
There's nothing in MSDN about it only applying to SCSI drives.
I believe what you're seeing is that the "Disk Drive Cache Flush"
command is ignored on IDE drives (specific command to the disk drive
itself) but, that doesn't mean the OS isn't flushing the data to disk
instead of
Hello Nono,
Microsoft's SQL Server uses FILE_FLAG_WRITE_THROUGH in it's
"CreateFiles". Read a neat article about it while looking up what
exactly this flag does.
"All versions of SQL Server open the log and data files using the
Win32 CreateFile function. The dwFlagsAndAttributes member includes
Nono BEZMan <[EMAIL PROTECTED]> wrote:
>
> My point was that there is light for windows users, if
> this
> FILE_FLAG_WRITE_THROUGH flag is added to the code.
> Otherwise, it seems that
> FlushFileBuffers really hinders SLQite to a point it
> becomes unusable. '7
> Inserts per seconds' on a brand
--- Robert Simpson <[EMAIL PROTECTED]> wrote:
> > -Original Message-
> > From: Nono BEZMan [mailto:[EMAIL PROTECTED]
> >
> > Why not integrate a patch like this one
> > (http://www.sqlite.org/cvstrac/tktview?tn=1250) in
> the
> > next cvs. It would awesome for us windows users to
> be
>
By the way, I also realized that the PRAGMA
synchronous=OFF does not work anymore, so there
probably a little bit of work there to insure that the
safety_level is passed correctly in the os_win.c
functions (so that the FILE_FLAG_WRITE_THROUGH flag is
not used when we are on safety_level=OFF).
> -Original Message-
> From: Nono BEZMan [mailto:[EMAIL PROTECTED]
>
> Why not integrate a patch like this one
> (http://www.sqlite.org/cvstrac/tktview?tn=1250) in the
> next cvs. It would awesome for us windows users to be
> able to chose between FILE_FLAG_WRITE_THROUGH and
>
Hi All,
This is hopefully a really basic question for someone. I have downloaded
the precompiled binary for Linux and I've got a file called
sqlite-3.2.8.so.gz
So far so good, but I'm not sure what steps to use to install this
properly.
Should I extract it and copy it into \usr\lib and
I can run sqlite3 from a windows cmd but running it from msys shell or
emacs shell doesn't work. No sqlite prompt and I have to interrupt the
process with Ctrl c.
Does anyone know the cause?
Thank you.
--
Radek
Ken & Deb Allen <[EMAIL PROTECTED]> wrote:
>
> > The following statement works in other databases but fails in
> SQLite with "SQL error: no such column: X.TeamID"
>
> SELECT X.TeamID,
> X.TeamName,
> Y.TeamID,
> Y.TeamName,
> X.Points
> FROM ( SELECT
On 28 Jan 2006, at 01:09, Randy J. Ray wrote:
Although - now that I've said all that - does the dbd interface
actually use sqlite3, or just version 2?
DBD::SQLite uses sqlite3.
Correct.
There's DBD::SQLite2 for those who have to use
sqlite2 for legacy purposes, but I'm pretty sure it
> -Original Message-
> From: Chris Robinson [mailto:[EMAIL PROTECTED]
>
> We have SQLite working for the desktop and the Pocket PC (PDA).
>
> We can add database components.
>
> The desktop application is working fine and we can add
> data-aware controls.
>
> However on the PDA we
Michael,
Your first-draft design is going to be easier to manage and more
scalable. Stick with that, rather than the curious notion of having one
table per keyword. Speaking as a frequent maintenance programmer,
that's the kind of design that would force me to hunt somebody down. It
probably
Hi
We have SQLite working for the desktop and the Pocket PC (PDA).
We can add database components.
The desktop application is working fine and we can add data-aware controls.
However on the PDA we can add the database components but are not able to get
data-aware controls to work.
Can anyone
Hello all!
Is it possible to access and work with SQLite databases with Open Office
Base?
Thanks
18 matches
Mail list logo