Re: [sqlite] convert sql for sqlite 2.8.17

[Jonas Sandman]

Shouldn't it be

select f.type, f.variety, f.price
from
fruits f
where
rowid in (select rowid from fruits where type = f.type order by
price desc limit 1)

?

No need for the 'AS' there.

/Jonas

On Tue, Dec 9, 2008 at 12:54 AM, Hariyanto Handoko <[EMAIL PROTECTED]> wrote:
> I want to get one result from that query.
> It ok if run under sqlite3.
>
> But when I try with with sqlite 2.8.17, I got this error.
> SQL error: no such column: f.type
> I tried add AS (Alias) but still got that errror message.
>
> select f.type, f.variety, f.price
> from
>  fruits AS f
> where
>  rowid in (select rowid from fruits where type = f.type order by
> price desc limit 1)
>
> order by f.type asc, f.price desc;
>
> I got  from this old message : (
> Re: [sqlite] Select the top N rows from each group)
>
> create table fruits (type text, variety text, price number);
> create index fruit_type_price on fruits (type, price);
> insert into fruits values ('apple', 'gala', 2.79);
> insert into fruits values ('apple', 'fuji', 0.24);
> insert into fruits values ('apple', 'limbertwig', 2.87);
> insert into fruits values ('orange', 'valencia', 3.59);
> insert into fruits values ('orange', 'navel', 9.36);
> insert into fruits values ('pear', 'bradford', 6.05);
> insert into fruits values ('pear', 'bartlett', 2.14);
> insert into fruits values ('cherry', 'bing', 2.55);
> insert into fruits values ('cherry', 'chelan', 6.33);
>
> result from query sqlite3 :
> apple|limbertwig|2.87
> cherry|chelan|6.33
> orange|navel|9.36
> pear|bradford|6.05
>
> How I can fix that sql so I can get same result in sqlite 2.8.17
> tx
>
>
> On Tue, Dec 9, 2008 at 2:12 AM, Martin Engelschalk
> <[EMAIL PROTECTED]> wrote:
>>
>> Hi,
>>
>> i thought that too, at first, but i think he wants to select one record
>> for every type of fruit, namely the record with the highest price within
>> one value of 'type' (I have difficulty saying what I mean in english.)
>>
>> However, the longer i look at the statement, the less sense it makes to
>> me. Perhaps  Hariyanto Handoko would like to post what the statement is
>> supposed to achieve.
>>
>> Martin
>>
>>
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Deactivation of Manifest Typing

[John Stanton]

In one of our Sqlite applications the gratuitous type changes of Sqlite 
were incompatible and it took only a very few patches to the Sqlite 
source to disable the detection and change code.

Clay Dowling wrote:
> Simon de Hartog wrote:
> 
>>SQLite has a feature called Manifest typing. As with many features of
>>software I run, I wonder whether this feature can be disabled. I prefer
>>to use static typing in my databases to prevent stored values not being
>>what my code (C++) expects them to be. So in short: is it possible to
>>use static typing instead of manifest typing in SQLite?
> 
> If you access the database strictly through your software, this is 
> trivially easy if you are using a strongly typed language like Pascal or 
> C.  Simply force the data to be of the appropriate type in your program 
> and it will be stored as the appropriate type in your database.
> 
> If you are allowing direct access to the database via SQL, you can 
> probably assume that any user smart enough to write their own 
> insert/update queries can probably also work out the correct data 
> types.  If not, you may wish to reconsider allowing direct SQL access.
> 
> Clay
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] convert sql for sqlite 2.8.17

[Hariyanto Handoko]

I want to get one result from that query.
It ok if run under sqlite3.

But when I try with with sqlite 2.8.17, I got this error.
SQL error: no such column: f.type
I tried add AS (Alias) but still got that errror message.

select f.type, f.variety, f.price
from
  fruits AS f
where
  rowid in (select rowid from fruits where type = f.type order by
price desc limit 1)

order by f.type asc, f.price desc;

I got  from this old message : (
Re: [sqlite] Select the top N rows from each group)

create table fruits (type text, variety text, price number);
create index fruit_type_price on fruits (type, price);
insert into fruits values ('apple', 'gala', 2.79);
insert into fruits values ('apple', 'fuji', 0.24);
insert into fruits values ('apple', 'limbertwig', 2.87);
insert into fruits values ('orange', 'valencia', 3.59);
insert into fruits values ('orange', 'navel', 9.36);
insert into fruits values ('pear', 'bradford', 6.05);
insert into fruits values ('pear', 'bartlett', 2.14);
insert into fruits values ('cherry', 'bing', 2.55);
insert into fruits values ('cherry', 'chelan', 6.33);

result from query sqlite3 :
apple|limbertwig|2.87
cherry|chelan|6.33
orange|navel|9.36
pear|bradford|6.05

How I can fix that sql so I can get same result in sqlite 2.8.17
tx


On Tue, Dec 9, 2008 at 2:12 AM, Martin Engelschalk
<[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> i thought that too, at first, but i think he wants to select one record
> for every type of fruit, namely the record with the highest price within
> one value of 'type' (I have difficulty saying what I mean in english.)
>
> However, the longer i look at the statement, the less sense it makes to
> me. Perhaps  Hariyanto Handoko would like to post what the statement is
> supposed to achieve.
>
> Martin
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3 and incrblob

[D. Richard Hipp]

On Dec 8, 2008, at 4:35 PM, D.M.P.Davies wrote:

> I'm having great difficulty using incrblob from tcl to a pre  
> existingcre
> in the database blob as indicated at /www.sqlite.org/tclsqlite.html  .
> I don't know where to get information on how to do it.
> My master table says I'e got such a blob definition and I've
> successfully inserted a record with  a type blob.
>
> Does anyone have any examples of using the incrbob method-please?
>

The regression tests for incrblob are written in TCL.  Perhaps you can  
deduce what you need from them.  The file of interest is incrblob.test.



D. Richard Hipp
[EMAIL PROTECTED]



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite3 and incrblob

[D.M.P.Davies]

I'm having great difficulty using incrblob from tcl to a pre existingcre 
in the database blob as indicated at /www.sqlite.org/tclsqlite.html  .  
I don't know where to get information on how to do it.
My master table says I'e got such a blob definition and I've 
successfully inserted a record with  a type blob.

Does anyone have any examples of using the incrbob method-please?

Dave Davies
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Adobe AIR SQLite - error 3132

[Ben Marchbanks]

I believe I found the problem.

I attempted to update a date field 2008.12.07 which was being 
interpretted as a number -

 apparently AIR version of SQLite enforces data types more stringently.

*Ben Marchbanks*

www.magazooms.com 
Signature
Email: [EMAIL PROTECTED] 
Phone: (864) 284.9918


Ben Marchbanks wrote:
> I am getting an exception # 3132 as I try to update a record in my AIR 
> runtime application.
>
> This error only occurs on  my WinXP test machine and not on my iMac 
> running OS 10.5.5 ( my development machine).
>
> Any resource for getting full list of error codes ?
>
>   
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Adobe AIR SQLite - error 3132

[Ben Marchbanks]

I am getting an exception # 3132 as I try to update a record in my AIR 
runtime application.

This error only occurs on  my WinXP test machine and not on my iMac 
running OS 10.5.5 ( my development machine).

Any resource for getting full list of error codes ?

-- 
*Ben Marchbanks*

www.magazooms.com 
Signature
Email: [EMAIL PROTECTED] 
Phone: (864) 284.9918
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] convert sql for sqlite 2.8.17

[Martin Engelschalk]

Hi,

i thought that too, at first, but i think he wants to select one record 
for every type of fruit, namely the record with the highest price within 
one value of 'type' (I have difficulty saying what I mean in english.)

However, the longer i look at the statement, the less sense it makes to 
me. Perhaps  Hariyanto Handoko would like to post what the statement is 
supposed to achieve.

Martin

Ribeiro, Glauber wrote:
> This should return only one record, right? So you shouldn't need the
> second order by ("order by f.type asc, f.price desc"). 
>
> -Original Message-
> From: Martin Engelschalk [mailto:[EMAIL PROTECTED] 
> Sent: Monday, December 08, 2008 8:15 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] convert sql for sqlite 2.8.17
>
> Hi,
>
> I don't know what your problem is, exactly. However, I suspect that you 
> have to alias the second "fruits" as well:
>
> select f.type, f.variety, f.price
> from
>   fruits f
> where
>   f.rowid in (select f1.rowid from fruits f1 where f1.type = f.type
> order by
> f2.price desc limit 1)
> order by f.type asc, f.price desc;
>
> Martin
>
> Hariyanto Handoko wrote:
>   
>> I still sqlite 2.8.17. Can someone help me to convert this sql?
>> tx
>>
>> select f.type, f.variety, f.price
>> from
>>   fruits f
>> where
>>   rowid in (select rowid from fruits where type = f.type order by
>> price desc limit 1)
>> order by f.type asc, f.price desc;
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>>   
>> 
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>   
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] newie question

[Roger Binns]

Oscar Alejandro Alvarado Prieto wrote:
> Thanks for all your answers and suggestions and sorry for my message, this
> was my very first one.As Martin already answer me don't worry any more.
> Thanks again, next time I will do better.

This document has many good suggestions on how to ask questions:

  http://www.catb.org/~esr/faqs/smart-questions.html

Roger
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] newie question

[Oscar Alejandro Alvarado Prieto]

Thanks for all your answers and suggestions and sorry for my message, this
was my very first one.As Martin already answer me don't worry any more.
Thanks again, next time I will do better.

2008/12/8 P Kishor <[EMAIL PROTECTED]>

> On 12/8/08, Oscar Alejandro Alvarado Prieto <[EMAIL PROTECTED]>
> wrote:
> > how can I retrieve the result of a "SELECT COUNT(*) FROM atable"
> statemen?
> >  thanks
> >
> >
>
> Hi Oscar,
>
> As MikeW mentioned, please use a subject line more descriptive than
> "newie question." Additionally, please pose a better question as well.
> Martin already explained some of the basics, but your question, as is,
> doesn't make any sense. "SELECT COUNT(*) FROM atable" *is* the way to
> retrieve the result. If you run that query in the sqlite3 shell, or
> through the interface of your choice, you will get back a count of
> rows in atable. Perhaps you want to provide some additional
> information about where and how you want to "retrieve" the desired
> result.
>
> --
> Puneet Kishor
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Oscar A. Alvarado
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] convert sql for sqlite 2.8.17

[Ribeiro, Glauber]

This should return only one record, right? So you shouldn't need the
second order by ("order by f.type asc, f.price desc"). 

-Original Message-
From: Martin Engelschalk [mailto:[EMAIL PROTECTED] 
Sent: Monday, December 08, 2008 8:15 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] convert sql for sqlite 2.8.17

Hi,

I don't know what your problem is, exactly. However, I suspect that you 
have to alias the second "fruits" as well:

select f.type, f.variety, f.price
from
  fruits f
where
  f.rowid in (select f1.rowid from fruits f1 where f1.type = f.type
order by
f2.price desc limit 1)
order by f.type asc, f.price desc;

Martin

Hariyanto Handoko wrote:
> I still sqlite 2.8.17. Can someone help me to convert this sql?
> tx
>
> select f.type, f.variety, f.price
> from
>   fruits f
> where
>   rowid in (select rowid from fruits where type = f.type order by
> price desc limit 1)
> order by f.type asc, f.price desc;
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>   


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Question about sqlite3_clear_bindings

[Tito Ciuro]

On 8 Dec 2008, at 11:54 AM, Igor Tandetnik wrote:

> Tito Ciuro <[EMAIL PROTECTED]> wrote:
>> On 8 Dec 2008, at 11:29 AM, Igor Tandetnik wrote:
>>
 I'd like to know why sqlite3_clear_bindings
 () exists in the first place.
>>>
>>> I don't know. It doesn't look particularly useful to me, either.
>>
>> Looking through the docs, it seems that sqlite3_clear_bindings() is a
>> convenience function for int sqlite3_bind_null(sqlite3_stmt*, int).  
>> So
>> if you have N columns, instead of clearing them one by one
>> sqlite3_clear_bindings() does that for you in one call.
>
> Well, yes. I know this. The question is, when, in practice, would you
> want to set all parameters to NULL?

Well, probably never :-)

However, if the majority of the columns need to be cleared, it's  
probably easier to clear all of them and rebind the ones needed...

-- Tito

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Question about sqlite3_clear_bindings

[Igor Tandetnik]

Tito Ciuro <[EMAIL PROTECTED]> wrote:
> On 8 Dec 2008, at 11:29 AM, Igor Tandetnik wrote:
>
>>> I'd like to know why sqlite3_clear_bindings
>>> () exists in the first place.
>>
>> I don't know. It doesn't look particularly useful to me, either.
>
> Looking through the docs, it seems that sqlite3_clear_bindings() is a
> convenience function for int sqlite3_bind_null(sqlite3_stmt*, int). So
> if you have N columns, instead of clearing them one by one
> sqlite3_clear_bindings() does that for you in one call.

Well, yes. I know this. The question is, when, in practice, would you 
want to set all parameters to NULL?

Igor Tandetnik 



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Question about sqlite3_clear_bindings

[Tito Ciuro]

Hi Igor,

On 8 Dec 2008, at 11:29 AM, Igor Tandetnik wrote:

>> I'd like to know why sqlite3_clear_bindings
>> () exists in the first place.
>
> I don't know. It doesn't look particularly useful to me, either.

Looking through the docs, it seems that sqlite3_clear_bindings() is a  
convenience function for int sqlite3_bind_null(sqlite3_stmt*, int). So  
if you have N columns, instead of clearing them one by one  
sqlite3_clear_bindings() does that for you in one call. I'm just  
guessing...

-- Tito
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Question about sqlite3_clear_bindings

[Igor Tandetnik]

Tito Ciuro <[EMAIL PROTECTED]> wrote:
>>> If step 5 is incorrect, when should I be calling
>>> sqlite3_clear_bindings ()?
>>
>> You don't have to, if you don't want to.
>
> I'm curious as to why it's not needed. Is it because the latter bind
> overrides the former one?

Yes.

> I'd like to know why sqlite3_clear_bindings
> () exists in the first place.

I don't know. It doesn't look particularly useful to me, either.

Igor Tandetnik



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] number of term occurances in fts3

[Jos van den Oever]

Hi all,

Can one retrieve the number of times a certain term occurs in an fts table?
This can be useful for autocompletion comboboxes. An example query
could look like this:

  select term, count(term) c from myfts3table where myfts3table match 'h*';

term|c
hi|10
hello|20

The snippet function is not exactly what I want.

Cheers,
Jos
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Question about sqlite3_clear_bindings

[Tito Ciuro]

Hi Igor,

On 7 Dec 2008, at 10:49 PM, Igor Tandetnik wrote:

> You might want to if most of your parameters are NULL, and you just  
> bind
> a some of them.

I didn't read your reply carefully enough. It makes sense, thank you.

-- Tito
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Question about sqlite3_clear_bindings

[Tito Ciuro]

Hello Igor,

On 7 Dec 2008, at 10:49 PM, Igor Tandetnik wrote:

> "Tito Ciuro" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
>> 1 • Create the object using sqlite3_prepare_v2() or a related
>> function. 2 • Bind values to host parameters using the
>> sqlite3_bind_*() interfaces.
>> 3 • Run the SQL by calling sqlite3_step() one or more times.
>> 4 • Reset the statement using sqlite3_reset().
>> 5 • Clear bindings using sqlite3_clear_bindings() then go back to  
>> step
>> 2. Do this zero or more times.
>
> This step is optional. You don't need to call sqlite3_clear_bindings.
> You might want to if most of your parameters are NULL, and you just  
> bind
> a some of them.
>
>> 6 • Destroy the object using sqlite3_finalize().
>>
>> If step 5 is incorrect, when should I be calling
>> sqlite3_clear_bindings ()?
>
> You don't have to, if you don't want to.

I'm curious as to why it's not needed. Is it because the latter bind  
overrides the former one? I'd like to know why sqlite3_clear_bindings 
() exists in the first place. Is it being kept around for backwards  
compatibility?

Thank you,

-- Tito
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] newie question

[P Kishor]

On 12/8/08, Oscar Alejandro Alvarado Prieto <[EMAIL PROTECTED]> wrote:
> how can I retrieve the result of a "SELECT COUNT(*) FROM atable" statemen?
>  thanks
>
>

Hi Oscar,

As MikeW mentioned, please use a subject line more descriptive than
"newie question." Additionally, please pose a better question as well.
Martin already explained some of the basics, but your question, as is,
doesn't make any sense. "SELECT COUNT(*) FROM atable" *is* the way to
retrieve the result. If you run that query in the sqlite3 shell, or
through the interface of your choice, you will get back a count of
rows in atable. Perhaps you want to provide some additional
information about where and how you want to "retrieve" the desired
result.

--
Puneet Kishor
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] newie question

[MikeW]

Oscar Alejandro Alvarado Prieto <[EMAIL PROTECTED]> writes:

> 
> how can I retrieve the result of a "SELECT COUNT(*) FROM atable" statemen?
> thanks
> 

Please use a better Subject line !!




___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] convert sql for sqlite 2.8.17

[Martin Engelschalk]

Hi,

I don't know what your problem is, exactly. However, I suspect that you 
have to alias the second "fruits" as well:

select f.type, f.variety, f.price
from
  fruits f
where
  f.rowid in (select f1.rowid from fruits f1 where f1.type = f.type order by
f2.price desc limit 1)
order by f.type asc, f.price desc;

Martin

Hariyanto Handoko wrote:
> I still sqlite 2.8.17. Can someone help me to convert this sql?
> tx
>
> select f.type, f.variety, f.price
> from
>   fruits f
> where
>   rowid in (select rowid from fruits where type = f.type order by
> price desc limit 1)
> order by f.type asc, f.price desc;
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>   

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] convert sql for sqlite 2.8.17

[Hariyanto Handoko]

I still sqlite 2.8.17. Can someone help me to convert this sql?
tx

select f.type, f.variety, f.price
from
  fruits f
where
  rowid in (select rowid from fruits where type = f.type order by
price desc limit 1)
order by f.type asc, f.price desc;
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Too many warnings

[barabbas]

Hi all,

I prefer disabling particular warnings by project setting of Visual 
Studio, i.e. the compiler argument /wd 
(http://msdn.microsoft.com/en-us/library/thxezb7y.aspx), instead of 
modifying the source code of SQLite by adding #pragma, which means you 
don't have to ask SQLite to change, just choose your own policy for 
specific purpose.

Regards,
/Mike/

Ti Ny wrote:
> I compile SQLite3 using Visual Studio 2008 SP1 and I have too many warnings 
> (103)
>
> 1>.\sqlite3.c(50675) : warning C4244: '=' : conversion from 'i64' to 'int', 
> possible loss of data
> ...
> 1>.\sqlite3.c(78136) : warning C4244: '=' : conversion from 'u16' to 
> 'unsigned char', possible loss of data
> and others
>
> Are there plans to cleanup the code please or any other solution?
>
> Ti Ny
>
> _
> Discover the new Windows Vista
> http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>   

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Too many warnings

[Roger Binns]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Ti Ny wrote:
> I compile SQLite3 using Visual Studio 2008 SP1 and I have too many warnings 
> (103)

http://www.sqlite.org/cvstrac/tktview?tn=3526

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkk8/C0ACgkQmOOfHg372QRjWwCghdNGa8tx41nGBGTXr6t781Il
09UAniDHY+FueQnvOFUQuG8I9NYn1ywN
=Agom
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Too many warnings

[Ti Ny]

I compile SQLite3 using Visual Studio 2008 SP1 and I have too many warnings 
(103)

1>.\sqlite3.c(50675) : warning C4244: '=' : conversion from 'i64' to 'int', 
possible loss of data
...
1>.\sqlite3.c(78136) : warning C4244: '=' : conversion from 'u16' to 'unsigned 
char', possible loss of data
and others

Are there plans to cleanup the code please or any other solution?

Ti Ny

_
Discover the new Windows Vista
http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] newie question

[Martin Engelschalk]

Hi,

this is a normal select statement, you can retrieve the result in the 
same way as for 'select foo from bar' - Statement.
The tecnical way depends on the interface you use.

If you need a name of the result field, you can use 'SELECT COUNT(*) as 
MyField FROM atable'; the result field is the named "MyField".

HTH
Martin

Oscar Alejandro Alvarado Prieto wrote:
> how can I retrieve the result of a "SELECT COUNT(*) FROM atable" statemen?
> thanks
>
>   

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] newie question

[Oscar Alejandro Alvarado Prieto]

how can I retrieve the result of a "SELECT COUNT(*) FROM atable" statemen?
thanks

-- 
Oscar A. Alvarado
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users