Dear all,
Why a VIEW doesn't contain a ROWID field. Even though if it is
accessed, it contains (null) value. How to initialise this or how to
make it work as in TABLE.
-
To unsubscribe, send email to [EMAIL PROTECTED]
---
Dear all,
After doing some SELECT operation on a TABLE, say we get 100 result
items out of 1000 records, Is there any way where I can iterate
through this result set. i.e., Get N items out of 100, say get
previous 10, get next 10, etc,
This should be done without creating a temporary table or vir
I have read some of the postings/faq about the difficulties with the round
function, when certain numbers do not have a finite representation in
binary, which SQLite uses. eg 9.95 is actually 9.9499...etc so that round(
9.95, 1) rounds down.
But, I have found several numbers which don't get rounde
can anybody tell me which database formats are supported by sqlite3
and the dependencies if i export my database to another system.
regards
Nishit
On 8/31/07, nishit sharma <[EMAIL PROTECTED]> wrote:
>
> hey buddy can u tell me how to compile the C source code in which i have
> used
> sqlite3_op
Serena Lien wrote:
I have read some of the postings/faq about the difficulties with the round
function, when certain numbers do not have a finite representation in
binary, which SQLite uses. eg 9.95 is actually 9.9499...etc so that round(
9.95, 1) rounds down.
But, I have found several numbers
Why a VIEW doesn't contain a ROWID field. Even though if it is
accessed, it contains (null) value. How to initialise this or how
to make it work as in TABLE.
To have your view include a rowid, you can include it in the select.
For instance, if you have a simple table:
create table People
Hi,
I am working on a 16 bit processor.
In windows the maximum value of unique id is 2 power 63 -1
I want to restrict the maximum value of the unique id to 2 power 15 -1
Can anyone help me in this?.
Best Regards,
A.Sreedhar.
Jasmin Infotech Pvt. Ltd.
Plot 119, Velachery Tambaram Road,
(O
Okay, but even if the rounded result does not have a finite binary
representation, shouldn't the displayed (human readable) representation be
at least truncated to the number of decimal places that were requested in
the round function? Not that I am confusing round with truncate, but surely
it is a
This I know, but the thing is, I want the ROWID in VIEW to be
sequential even after a SELECT with some condition has been executed,
ie., from 1 to n. Just like in normal table. In your case it is not
like that.
By the way, what I mean to say is, why don't we have default ROWID in
VIEW like as in n
You should link the library when you compile .It should be gcc
test.c-l
library name should be your sqlite shared library. Just check in /usr/lib
directory
Thanks,
Pavan.
On 8/31/07, nishit sharma <[EMAIL PROTECTED]> wrote:
>
> hey buddy can u tell me how to compile the C source code in whi
Serena Lien wrote:
Okay, but even if the rounded result does not have a finite binary
representation, shouldn't the displayed (human readable) representation be
at least truncated to the number of decimal places that were requested in
the round function? Not that I am confusing round with trunca
#ifdef SQLITE_INT64_TYPE
typedef SQLITE_INT64_TYPE sqlite_int64;
typedef unsigned SQLITE_INT64_TYPE sqlite_uint64;
#elif defined(_MSC_VER) || defined(__BORLANDC__)
typedef __int64 sqlite_int64;
typedef unsigned __int64 sqlite_uint64;
#else
typedef long long sqlite_int64;
typedef unsigne
This I know, but the thing is, I want the ROWID in VIEW to be
sequential even after a SELECT with some condition has been executed,
ie., from 1 to n. Just like in normal table. In your case it is not
like that.
Ah, OK, I asked a similar question a week or two ago, and had to come
up with my ow
thanks for this help. i have done this...
my another problem is that i have multiple columns in my database and on the
basis of
two columns( has integer values) i have to read the database.
but i m unable to make a loop in C.
can u help me.
regards
Nishit
On 9/3/07, Pavan <[EMAIL PROTECTED]> wro
Thanks Tom,
I wanted to know how SQLITE works internally. Assume I am doing
"select *" and "select column1, column2" for some row. In both the cases
it will have to go through the B-Tree to reach that row. I believe this
is done when sqlite3_step is called.
Now assume I have reached the no
Thanks for pointing out the implementation issues. I was thinking only in
the case where I am asking for a string result, not all the time, ie
sqlite3_column_text, where I would want the string representation of the
rounded number in this format, and did not realize this would require
storing all t
prepare sql query and pass it to sqlite3_exec
Thanks,
Pavan.
On 9/3/07, nishit sharma <[EMAIL PROTECTED]> wrote:
>
> thanks for this help. i have done this...
> my another problem is that i have multiple columns in my database and on
> the
> basis of
> two columns( has integer values) i have to
In the sql query use AND operator for the two columns you want to compare.
Ex:select * from table_name where col1=="value" AND col2 == "value";
-Original Message-
From: nishit sharma [mailto:[EMAIL PROTECTED]
Sent: Monday, September 03, 2007 3:41 PM
To: sqlite-users@sqlite.org
Subject: Re:
--- "B V, Phanisekhar" <[EMAIL PROTECTED]> wrote:
> I wanted to know how SQLITE works internally. Assume I am doing
Try using the EXPLAIN command on your queries:
EXPLAIN SELECT foo from bar;
EXPLAIN SELECT * from bar;
http://www.sqlite.org/lang_explain.html
> But if SQLITE uses some othe
On 9/3/07, Serena Lien <[EMAIL PROTECTED]> wrote:
> Okay, but even if the rounded result does not have a finite binary
> representation, shouldn't the displayed (human readable) representation be
> at least truncated to the number of decimal places that were requested in
> the round function? Not t
On 9/2/07, Babu, Lokesh <[EMAIL PROTECTED]> wrote:
> Why a VIEW doesn't contain a ROWID field. Even though if it is
> accessed, it contains (null) value. How to initialise this or how to
> make it work as in TABLE.
The rowid field exposes SQLite's internal storage mechanism for table
rows. It ha
On 9/3/07, Babu, Lokesh <[EMAIL PROTECTED]> wrote:
> After doing some SELECT operation on a TABLE, say we get 100 result
> items out of 1000 records, Is there any way where I can iterate
> through this result set. i.e., Get N items out of 100, say get
> previous 10, get next 10, etc,
>
> This shou
On Sun, 2 Sep 2007 23:23:43 -0400, you wrote:
>Hi,
>
>Does sqlite offer the ability to connect to a sqlite db file on a
>remote machine? I've been using it locally for awhile and it's great.
>Wanted to see if it could be used remotely for some simple tasks.
It does, but there are restrictions:
ht
On Monday, September 03, 2007 Arjen Markus wrote:
> Serena Lien wrote:
>>round(98926650.5, 1) -> 98926650.501
>>round(85227887.01, 1) -> 85227887.001
> They are in fact rounded, but the internal binary representation can
> not be turned into the appropriate decimal (and human readable)
On Monday, September 03, 2007 Arjen Markus wrote:
> Serena Lien wrote:
>>Okay, but even if the rounded result does not have a finite binary
>>representation, shouldn't the displayed (human readable) representation be
>>at least truncated to the number of decimal places that were requested in
>>t
Hi Lokesh,
On Mon, 3 Sep 2007 15:30:10 +0530, you wrote:
> This I know, but the thing is, I want the ROWID
> in VIEW to be sequential even after a SELECT with
> some condition has been executed, ie., from 1 to n.
> Just like in normal table.
> In your case it is not like that.
If you delete r
On 9/3/07, Doug Currie <[EMAIL PROTECTED]> wrote:
> On Monday, September 03, 2007 Arjen Markus wrote:
>
> > Serena Lien wrote:
>
> >>round(98926650.5, 1) -> 98926650.501
> >>round(85227887.01, 1) -> 85227887.001
>
> > They are in fact rounded, but the internal binary representation can
> >
On Monday, September 03, 2007 Nuno Lucas wrote:
> This made me to remember there was a bug some time ago about the
> rounding algorithm (but can't remember at what version it was fixed),
> so I just tested it.
> "official" amalgamated sqlite 3.4.0 downloaded from the site some time ago:
> SQLit
On Mon, 3 Sep 2007 18:29:55 +0100, you wrote:
>This made me to remember there was a bug some time ago about the
>rounding algorithm (but can't remember at what version it was fixed),
>so I just tested it.
>
>"official" amalgamated sqlite 3.4.0 downloaded from the site some time ago:
>
>SQLite vers
On 9/2/07, Babu, Lokesh <[EMAIL PROTECTED]> wrote:
> Does anyone help me out, What is FTS1, How to use FTS1, If any sample
> programs to use FTS1 and understand better.
The "fts" modules are "fulltext search" modules for SQLite. "Fulltext
search" meaning that it builds an index based on terms in
Hello -
I tried to use an older version of the sqlite3 executable on Mac OS X
with a data file from a newer version. No joy resulted.
Looking at http://www.sqlite.org/changes.html, I do not see any notes
about whether any version breaks binary compatibility with any older
version.
Shou
Hi Ray,
Look at version 3.4.0 (2007 june 18), third item.
- Added explicit upper bounds on the sizes and quantities of things
SQLite can process. *This change might cause compatibility problems* for
applications that use SQLite in the extreme, which is why the current
release is 3.4.0 instead of
Hi Kees,
He is telling about the Rowid the unique number that represents each row
in the table, not about a table column named "ID" or anything else, or
the primary key of the table.
[]'s,
Marco Antonio Abreu
IT Quality Systems
[EMAIL PROTECTED]
http://www.itquality.com.br
Kees Nuyt wrote:
>
On Monday, September 03, 2007 Nuno Lucas wrote:
> Maybe some OS specific error? Wasn't there some discussion earlier
> about the Microsoft compiler not using the full double precision by
> default?
Microsoft C compilers store long doubles in 64 bits, just like
doubles http://msdn2.microsoft.com/
On Sep 3, 2007, at 1:56 PM, Marco Antonio Abreu wrote:
Hi Ray,
Look at version 3.4.0 (2007 june 18), third item.
- Added explicit upper bounds on the sizes and quantities of things
SQLite can process. *This change might cause compatibility
problems* for
applications that use SQLite in the
Ray Kiddy <[EMAIL PROTECTED]> wrote:
> Hello -
>
> I tried to use an older version of the sqlite3 executable on Mac OS X
> with a data file from a newer version. No joy resulted.
>
> Looking at http://www.sqlite.org/changes.html, I do not see any notes
> about whether any version breaks binar
Hi folks,
Nokia uses SQLite on Windows to exchange data between PC and a
cellphone using what they call Nokia PC Suite.
Not very surprising, as Symbian is the OS on Mokia high end
phones, but SQLite is also used in exchanges with its 6233
model, which doesn't run Symbian, but Nokia OS, with Ser
On Mon, 03 Sep 2007 18:05:05 -0300, you wrote:
>Hi Kees,
>
>He is telling about the Rowid the unique number that represents each row
>in the table, not about a table column named "ID" or anything else, or
>the primary key of the table.
>
>[]'s,
>
>Marco Antonio Abreu
>IT Quality Systems
>[EMAIL PR
On 4/09/2007 7:13 AM, Doug Currie wrote:
On Monday, September 03, 2007 Nuno Lucas wrote:
Maybe some OS specific error? Wasn't there some discussion earlier
about the Microsoft compiler not using the full double precision by
default?
Microsoft C compilers store long doubles in 64 bits, just li
You could always use rails and get to your database through an html
connection. You can take your choice of web servers though the built in
mongrel-rails server will easily handle 20-30 concurrent connections.
Scott
Kees Nuyt wrote:
On Sun, 2 Sep 2007 23:23:43 -0400, you wrote:
Hi,
Does s
On 9/4/07, Scott Derrick <[EMAIL PROTECTED]> wrote:
> You could always use rails and get to your database through an html
> connection. You can take your choice of web servers though the built in
> mongrel-rails server will easily handle 20-30 concurrent connections.
>
> Scott
>
> Kees Nuyt wrote:
Hi Scott,
Thanks for the information.
One more question, As you said, Full text builds an index of data, so
I hope you have done some memory analysis too, could you please tell
me the memory usage based on your analysis.
On 9/4/07, Scott Hess <[EMAIL PROTECTED]> wrote:
> On 9/2/07, Babu, Lokesh
Hai,
I am having 4 distinct Albums in one table.
To display all the 4 Albums in sorted order.I used the following
statement
"select distinct Albums from TableName order by Albums;"
To display first 50 Albums in sorted order.I used the following statement
"select distinct Albums fr
43 matches
Mail list logo