> How big is the database file in the filesystem after you do this?
> Can you post it (the database file)? Have you defined any preprocessor
> macros when compiling, for example SQLITE_DEFAULT_AUTOVACUUM or one
> of the OMIT symbols?
Hi Dan,
how you can see in my other mail, starting with a new (a
> When you say that you have no problem, does that mean you
> have run SQLite version 3.3.1 on vxWorks and it worked, or
> that you have run some other SQLite version 3.x.x? There
> were big changes in the OS layer going from 3.2.8 to 3.3.0.
> Something might have broken, at least in respect to vx
--- Andrea Federico <[EMAIL PROTECTED]> wrote:
> Hi sqliteUsers,
>
> I have a simple question:
>
> can you tell me why I obtain an error creating a simple table
> in a new database ?
>
> if I insert this simple command:
>
> sqlite> create table tbl1(one varchar(10), two smallint);
> sqlite>
Indeed. VC2005 brings up much more than 10 warnings with the x64
compat warnings on, all due to lack of proper casting. The current
code may work, but these warnings may mask a future warning that
should be heeded. I've been meaning to work on a patch but havn't
been able to find the time.
On 1
Ken & Deb Allen wrote:
Hmmm. The number of warnings compiling the 3.3.1 source is up to 10
from 6 in the 3.3.0 source. All of them appear to be related to
inappropriate sign comparisons/assignments.
-ken
So your compiler is blowing smoke. GCC 4.02 which I use under Linux
coughs up warnings
Hmmm. The number of warnings compiling the 3.3.1 source is up to 10
from 6 in the 3.3.0 source. All of them appear to be related to
inappropriate sign comparisons/assignments.
-ken
> Was looking on the functions code. Wondered if their's any way I can
> do something like
>
> for select from table
>
> do something here
>
> loop
>
> the field have a array of data may be single row but only single column
Hi Vishal --
I'm not sure I understand your syntax. Maybe a more c
Dear All ,
Was looking on the functions code. Wondered if their's any way I can
do something like
for select from table
do something here
loop
the field have a array of data may be single row but only single column
--
With Best Regards,
Vishal Kashyap.
http://vishalkashyap.tk
> What language and/or wrapper library are you using to drive SQLite?
>
> Also, how large are the records in your database? You said earlier that
> they have 45 fields, but not what type of data was stored in any of
> them. Since you are doing string searches, I assume that at least one
> contains
"Andrea Federico" <[EMAIL PROTECTED]> wrote:
> > > My first guess is that the implementation of
> > > sqlite3OsFileSize() (actually implemented as
> > > "unixFileSize" on line of os_unix.c) is
> > > not working correctly.
> >
> > in my case I have no problem, with debbuger I see the size is c
"Steve O'Hara" <[EMAIL PROTECTED]> wrote:
> The standard SQLite function random() is actually seeded by
> the current time and date every time you open a database.
>
FWIW, the random() function in SQLite uses a cryptographic
PRNG and (at least on Unix) is seeded using /dev/urandom
if that device
> > My first guess is that the implementation of
> > sqlite3OsFileSize() (actually implemented as
> > "unixFileSize" on line of os_unix.c) is
> > not working correctly.
>
> in my case I have no problem, with debbuger I see the size is correct,
> 2048 Byte.
>
> Following a suggestion from an
Carl Jacobs wrote:
I'm using Windows XP Sp2, SQLite3.DLL V3.2.7. One of the tests which follows
was repeated with bleeding edge SQLite3.DLL V3.3.1 - and gave the same
result.
If I do the following query 'SELECT count(*) FROM MyTable' then when I time
the process I get the following results:
(Al
Carl Jacobs wrote:
I'm using Windows XP Sp2, SQLite3.DLL V3.2.7. One of the tests which follows
was repeated with bleeding edge SQLite3.DLL V3.3.1 - and gave the same
result.
If I do the following query 'SELECT count(*) FROM MyTable' then when I time
the process I get the following results:
(Al
On 1/17/06, Steve O'Hara <[EMAIL PROTECTED]> wrote:
> Jay, If you're going to offer advice, at least do some basic research to
> make sure it's accurate.
Was it your intent to be insulting or are you just drunk?
>
> Firstly, having a column that has a random number in it and sorting by
> it produ
Jay, If you're going to offer advice, at least do some basic research to
make sure it's accurate.
Firstly, having a column that has a random number in it and sorting by
it produces the same output each time you query on it - obviously
unsatisfactory and I would have thought, manor from heaven for
- Original Message -
From: "Simon Posnjak" <[EMAIL PROTECTED]>
Robert Simpson wrote:
For your convenience, I've updated the code at the previous link I
supplied with the latest os_win.c that I am using against the 3.3.1
alpha.
Thank you. It works super with my application on WinCE 4.1
On 1/16/06, Clark Christensen <[EMAIL PROTECTED]> wrote:
>
> So, I have to ask, is this the right way to implement such functionality? Is
> there a better, or more efficient way?
The standard method of ordering a list randomly that doesn't return duplicates
is to add a column for each of the ite
On 1/16/06, Carl Jacobs <[EMAIL PROTECTED]> wrote:
> The only thing that seems to make it quick again is terminating and
> restarting the process - i.e. shutting down and restarting my program. It
> seems that no matter what I do it's quick for about 5 queries, and then
> seems to fall in a heap.
> My first guess is that the implementation of
> sqlite3OsFileSize() (actually implemented as
> "unixFileSize" on line of os_unix.c) is
> not working correctly.
in my case I have no problem, with debbuger I see the size is correct,
2048 Byte.
Following a suggestion from an old mail in this m
Robert Simpson wrote:
- Original Message - From: "Simon Posnjak"
<[EMAIL PROTECTED]>
Robert Simpson wrote:
I incorporated the locks into the latest CVS version of os_win.c and
it's available here:
http://sqlite.phxsoftware.com/os_win.c
Would i be possible to post the whole src?
I have observed a "bug" in sqlite (3.2.8). when a table is created, and
then renamed via the ALTER TABLE statement, the create statement gets
adjusted (which is correct), but the new
name appears in single quotes. according to sql syntax, table and field
names are quoted by double quotes, so this c
"Andrea Federico" <[EMAIL PROTECTED]> wrote:
> > What operating system are you running? What version
> > of SQLite are you using? Did you compile it yourself
> > or did you obtain a precompiled version?
>
> Excuse me I have forgot to insert these important information:
>
> Sqlite version = 3.3.
"Andrea Federico" <[EMAIL PROTECTED]> wrote:
> > What operating system are you running? What version
> > of SQLite are you using? Did you compile it yourself
> > or did you obtain a precompiled version?
>
> Excuse me I have forgot to insert these important information:
>
> Sqlite version = 3.3.
> What operating system are you running? What version
> of SQLite are you using? Did you compile it yourself
> or did you obtain a precompiled version?
Excuse me I have forgot to insert these important information:
Sqlite version = 3.3.1
OS = vxWorks
CPU= powerPC
build f
"Andrea Federico" <[EMAIL PROTECTED]> wrote:
>
> can you tell me why I obtain an error creating a simple table
> in a new database ?
>
Something is clearly broken.
What operating system are you running? What version
of SQLite are you using? Did you compile it yourself
or did you obtain a pre
Hi sqliteUsers,
I have a simple question:
can you tell me why I obtain an error creating a simple table
in a new database ?
if I insert this simple command:
sqlite> create table tbl1(one varchar(10), two smallint);
sqlite> PRAGMA integrity_check;
*** in database main ***
Page 2 is never used
michael munson schrieb:
Type refers to an int value that represents an in-server datatype. The
main difference is that I realized that I wouldn't necessarily need a
row for EVERY property, only if a property is different than the value
stored on the parent object. If its the same, it can hav
28 matches
Mail list logo
