--- 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);
>
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
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
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
> > 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:
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
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
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
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?
"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 =
"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 =
> 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
"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
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
21 matches
Mail list logo