Re: [sqlite] tclsqlite.c errors

[mkrajachandru]

But I have copiled the same files for x86 target its working fine

I can able to run all the test files.

And I am trying to compile the TCL8.4.19 for ARM target

Its giving the following error

bLib.o tclTimer.o tclUtf.o tclUtil.o tclVar.o tclUnixChan.o tclUnixEvent.o
tclUn
ixFCmd.o tclUnixFile.o tclUnixPipe.o tclUnixSock.o tclUnixTime.o
tclUnixInit.o t
clUnixThrd.o tclUnixCompat.o tclUnixNotfy.o  tclLoadDl.o
ld: regcomp.o: Relocations in generic ELF (EM: 40)
ld: regcomp.o: Relocations in generic ELF (EM: 40)
regcomp.o: *could not read symbols: File in wrong format
*make[2]: *** [libtcl8.4.so] Error 1
make[2]: Leaving directory `/tcl_arm/tcl8.4.19/unix/nto-arm-o.le'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/tcl_arm/tcl8.4.19/unix'
make: *** [all] Error 2

If i solve that error i can install TCL successfully.


On Thu, Feb 5, 2009 at 6:45 PM, D. Richard Hipp  wrote:

>
> On Feb 5, 2009, at 8:05 AM, mkrajachan...@gmail.com wrote:
>
> > Hello All,
> >
> > I am compiling sqlite-3.6.7 to ARM target
> >
> > make fulltest (I need testfixture binary)
> >
> >While compiling its giving lots of errors in tclsqlite.c
> > file
> >
> >How can I getrid of this problem
>
> testfixture and tclsqlite.c require TCL (http://www.tcl.tk/).  You
> need to get a working TCL development environment for your target
> platform.
>
> If your goal is to test SQLite on your embedded platform, there are
> other options.  There are two other test harnesses for SQLite now.
> See http://www.sqlite.org/testing.html for additional information.
>
>
> >
> >
> >Please help me
> >
> > Thanks in advance
> >
> > Chandru K
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
> D. Richard Hipp
> d...@hwaci.com
>
>
>
> ___
> 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] Insertion and Updation using sqlite3_prepare()

[Igor Tandetnik]

"hussainfarzana"
 wrote in
message news:21866676.p...@talk.nabble.com
> Below is the query we used where all the fields are numeric and it is
> prepared once:
>
> INSERT INTO ShopDataNum values(?,?,?,?,?,?,?,?,?,?,?)
>
> When we bind the values the steps were returning the correct value
> but the record is not found in the DB.
>
> Then we tried by passing the static value for the first field in
> sqlite3_prepare and we bind the values.
> INSERT INTO ShopDataNum values(960002,?,?,?,?,?,?,?,?,?,?)
> The steps were executed correctly and the record is inserted
> correctly in the DB.
>
> Again we tried the first query and assigned the static value for the
> first field while binding the values, the steps were executed
> correctly but the record is not found in the DB.

Can you show a small complete code sample that reproduces the problem?

Igor Tandetnik 



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

Re: [sqlite] Insertion and Updation using sqlite3_prepare()

[hussainfarzana]

Thanks for your reply Igor.

We checked and we have commited the transaction.

Below is the query we used where all the fields are numeric and it is
prepared once:

INSERT INTO ShopDataNum values(?,?,?,?,?,?,?,?,?,?,?)

When we bind the values the steps were returning the correct value but the
record is not found in the DB.

Then we tried by passing the static value for the first field in
sqlite3_prepare and we bind the values.
INSERT INTO ShopDataNum values(960002,?,?,?,?,?,?,?,?,?,?)
The steps were executed correctly and the record is inserted correctly in
the DB.

Again we tried the first query and assigned the static value for the first
field while binding the values, the steps were executed correctly but the
record is not found in the DB.

Please guide us how to proceed further.

Thanks and Regards,
Farzana.


Igor Tandetnik wrote:
> 
> "hussainfarzana"
>  wrote in
> message news:21849799.p...@talk.nabble.com
>> We are using the sqlite3_prepare() and sqlite3_bind() methods for
>> insertion and updation of the records in the database.Everything
>> works fine and sqlite3_step() returns 101 which is SQLITE_DONE.When
>> we check the DB, the records are not inserted.
> 
> Do you, by any chance, start a transaction and then forget to commit it?
> 
> Igor Tandetnik 
> 
> 
> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Insertion-and-Updation-using-sqlite3_prepare%28%29-tp21849799p21866676.html
Sent from the SQLite mailing list archive at Nabble.com.

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

[sqlite] [ANN] IPLocation.db (20090201)

[Petite Abeille]

Hello,

IPLocation.db provides access to MaxMind's GeoLite City data as a - 
rather hefty- SQLite3 database.

http://alt.textdrive.com/assets/public/Nanoki/IPLocation.20090201.tar.bz2 
  (42.5 MB)

Usage example:

% sqlite3 IPLocation.db

select  location.start as start,
 location.end as end,
 city.name as city,
 region.name as region,
 region.code as region_code,
 country.name as country,
 country.code as country_code
fromlocation
joincity on city.id = location.city_id
joinregion on region.id = city.region_id
joincountry on country.id = region.country_id
where   location.start <= 1658712019
order bylocation.start desc
limit   1;

 > 1658711808,1658712063,Annandale,New Jersey,NJ,United States,US

There is also a Lua [2] front-end for it:

#!/usr/bin/env lua

local IPLocation = require( 'IPLocation' )
local aLocation = IPLocation[ '128.112.155.165' ]

print( aLocation.city, aLocation.region, aLocation.country  )

 > PrincetonNew Jersey  United States

Cheers,

--
PA.
http://alt.textdrive.com/nanoki/

[2] http://www.lua.org/about.html

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

Re: [sqlite] Finalize after a failed call to prepare

[Igor Tandetnik]

Nathan Biggs  wrote:
> Do you ever need to call finalize if prepare is not successful.
> Prepare does not seem to return anything if not successful
> (SQLITE_OK).

If prepare fails, you don't get a valid sqlite3_stmt* so you don't have 
anything to call finalize on.

Igor Tandetnik 



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

[sqlite] Finalize after a failed call to prepare

[Nathan Biggs]

Do you ever need to call finalize if prepare is not successful.  Prepare 
does not seem to return anything if not successful (SQLITE_OK).



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

Re: [sqlite] basic problem...

[Thomas Briggs]

   I think the answer depends on the poster's actual experience with
SQLite.  There are plenty of people that use SQLite without any kind
of programming tool (think SQLiteExplorer), so for them it's a
database.  There are plenty of people who have used SQLite as a simple
data store for PHP apps, and for them I'd argue that it's a database.
And then there are some people who have written wrappers on top of
SQLite, coded directly against the C API, have written virtual table
handlers, etc. and for those people I think it's a programming tool.

   So, I think the real question is, what have you done with SQLite? :)

On Thu, Feb 5, 2009 at 2:00 PM, Simon  wrote:
> On a resume, i would rather mention the programing skills (ie.
> languages) and then database skills (ie. SQL).  Mention in the
> database part that you have experience with different database systems
> like MySQL, MSSQL, SQLite... and in another section, you can mention
> that you made a project that combined programming skills and database
> using SQLite...
>
> Happy job seeking and good luck! =D
>
> On Thu, Feb 5, 2009 at 10:07 AM, Jonas Sandman  
> wrote:
>> I'd think it's more a programming skill if you can "use SQLite". You
>> need some basic knowledge of SQL though which I guess would be
>> considered "a database skill". But that's just imho...
>>
>> On Thu, Feb 5, 2009 at 3:48 PM, Mihai Limbasan  wrote:
>>> Oh, I understand now. Probably in the Database section.
>>>
>>> vade wrote:
 Hello

 Thank you Mihai Limbasan.
 For your clarification, Now I'm Preparing my Profile(cv or resume). I just
 want to know where to show this sqlite3 skill.
 whether in Programing skill section or database skill section or web
 technology skill section.

 thank you


 Mihai Limbasan wrote:

> vade wrote:
>
>> is sqlite3 is web skill OR database skill?
>> can anybody please tell me...
>>
>> thank you in advance
>>
>>
> SQLite 3 is a database engine - a library. Part of a computer program.
> It's not a skill. A skill is an abstract concept.
>
> Could you perhaps rephrase your question?
> ___
> 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
>>
>
>
>
> --
> When Earth was the only inhabited planet in the Galaxy, it was a
> primitive place, militarily speaking.  The only weapon they had ever
> invented worth mentioning was a crude and inefficient nuclear-reaction
> bomb for which they had not even developed the logical defense. -
> Asimov
> ___
> 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] error in Linux

[Simon]

I am not familiar with Java, but I am familiar with compatibility
differences between Linux and Windows.
According to the errors, I think SQLite is having trouble opening the
file that contains the DB.
Have you verified the file is there? And you may have to adjust the
PATH to the file on disk
windows path style: C:\some\directory\file.db
linux path style: /some/directory/file.db

Good luck!

On Thu, Feb 5, 2009 at 2:01 PM, João Claudio  wrote:
> hi, i am from Brazil.
> I a beginner in SQLite (and English)
> But i will try explain my problem.
> I have a application in Java (i use the IDE NetBeans)..
> I test my application (jar file) in the Linux and Windows XP.
> In Windows it's OK, BUT in Linux i have a error message.
> I think the error happen when the application try to create the database.
> The error message:
> Exception in thread "main" java.lang.UnsatisfiedLinkError: 
> org.sqlite.NativeDB._open(Ljava/lang/String;)V
> at org.sqlite.NativeDB._open(Native Method)
> at org.sqlite.DB.open(DB.java:77)
> at org.sqlite.Conn.(Conn.java:88)
> at org.sqlite.JDBC.connect(JDBC.java:64)
> at java.sql.DriverManager.getConnection(DriverManager.java:620)
> at java.sql.DriverManager.getConnection(DriverManager.java:222)
> at persistencia.Conexao.setUp(Conexao.java:12)
>
> The line-code of the error:
> Connection con = 
> DriverManager.getConnection("jdbc:sqlite:.joaomoro-desktop-base.db");
>
> I can connect in databse through of window SERVICES, but I can't understand 
> because my
> aplication can't connect.
>
> It occurs in Linux (in Windows is all OK).
>
>
>  Veja quais são os assuntos do momento no Yahoo! +Buscados
> http://br.maisbuscados.yahoo.com
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
When Earth was the only inhabited planet in the Galaxy, it was a
primitive place, militarily speaking.  The only weapon they had ever
invented worth mentioning was a crude and inefficient nuclear-reaction
bomb for which they had not even developed the logical defense. -
Asimov
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] error in Linux

[João Claudio]

hi, i am from Brazil.
I a beginner in SQLite (and English)  
But i will try explain my problem.
I have a application in Java (i use the IDE NetBeans)..
I test my application (jar file) in the Linux and Windows XP.
In Windows it's OK, BUT in Linux i have a error message.
I think the error happen when the application try to create the database.
The error message:
Exception in thread "main" java.lang.UnsatisfiedLinkError: 
org.sqlite.NativeDB._open(Ljava/lang/String;)V
    at org.sqlite.NativeDB._open(Native Method)
    at org.sqlite.DB.open(DB.java:77)
    at org.sqlite.Conn.(Conn.java:88)
    at org.sqlite.JDBC.connect(JDBC.java:64)
    at java.sql.DriverManager.getConnection(DriverManager.java:620)
    at java.sql.DriverManager.getConnection(DriverManager.java:222)
    at persistencia.Conexao.setUp(Conexao.java:12)

The line-code of the error:
Connection con = 
DriverManager.getConnection("jdbc:sqlite:.joaomoro-desktop-base.db");

I can connect in databse through of window SERVICES, but I can't understand 
because my 
aplication can't connect.

It occurs in Linux (in Windows is all OK).


  Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] basic problem...

[Simon]

On a resume, i would rather mention the programing skills (ie.
languages) and then database skills (ie. SQL).  Mention in the
database part that you have experience with different database systems
like MySQL, MSSQL, SQLite... and in another section, you can mention
that you made a project that combined programming skills and database
using SQLite...

Happy job seeking and good luck! =D

On Thu, Feb 5, 2009 at 10:07 AM, Jonas Sandman  wrote:
> I'd think it's more a programming skill if you can "use SQLite". You
> need some basic knowledge of SQL though which I guess would be
> considered "a database skill". But that's just imho...
>
> On Thu, Feb 5, 2009 at 3:48 PM, Mihai Limbasan  wrote:
>> Oh, I understand now. Probably in the Database section.
>>
>> vade wrote:
>>> Hello
>>>
>>> Thank you Mihai Limbasan.
>>> For your clarification, Now I'm Preparing my Profile(cv or resume). I just
>>> want to know where to show this sqlite3 skill.
>>> whether in Programing skill section or database skill section or web
>>> technology skill section.
>>>
>>> thank you
>>>
>>>
>>> Mihai Limbasan wrote:
>>>
 vade wrote:

> is sqlite3 is web skill OR database skill?
> can anybody please tell me...
>
> thank you in advance
>
>
 SQLite 3 is a database engine - a library. Part of a computer program.
 It's not a skill. A skill is an abstract concept.

 Could you perhaps rephrase your question?
 ___
 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
>



-- 
When Earth was the only inhabited planet in the Galaxy, it was a
primitive place, militarily speaking.  The only weapon they had ever
invented worth mentioning was a crude and inefficient nuclear-reaction
bomb for which they had not even developed the logical defense. -
Asimov
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Group by week

[Brad Dewar]

Something like this seems the most obvious way:

SELECT strftime('%Y%W', date_col) AS w, other_data FROM my_table GROUP
BY w

See http://sqlite.org/lang_datefunc.html for usage.  That doc also
includes some caveats related to precision and locale, etc.

Brad



-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Tom Longbotham
Sent: Thursday, February 05, 2009 1:05 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Group by week

Hi Moshe,

  There are probably a number of ways to do this.  One possibility would
be
to store your dates in binary date value within the sqlite database,
which I
believe is so many seconds since some date in 1969.  You could then use
a
constant such as:

#define SecondsInWeek 60*60*24*7

You could then use the starting date also in this format to select where
the
value in the database was greater than the starting day and less than
the
starting day plus SecondInWeek.  To select the next week add
SecondsInWeek
to your starting value and reiterate...

-Tom

On Thu, Feb 5, 2009 at 8:43 AM, John Stanton 
wrote:

> You need a function which gives the week number.  Note that this is
> calculated differently in the USA and Europe., so you need to use the
> correct rules to write the function.
>
> Moshe Sharon wrote:
> > Hi
> >
> > How can I select group by week
> >
> > moshe
> > ___
> > 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
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Group by week

[Tom Longbotham]

Hi Moshe,

  There are probably a number of ways to do this.  One possibility would be
to store your dates in binary date value within the sqlite database, which I
believe is so many seconds since some date in 1969.  You could then use a
constant such as:

#define SecondsInWeek 60*60*24*7

You could then use the starting date also in this format to select where the
value in the database was greater than the starting day and less than the
starting day plus SecondInWeek.  To select the next week add SecondsInWeek
to your starting value and reiterate...

-Tom

On Thu, Feb 5, 2009 at 8:43 AM, John Stanton  wrote:

> You need a function which gives the week number.  Note that this is
> calculated differently in the USA and Europe., so you need to use the
> correct rules to write the function.
>
> Moshe Sharon wrote:
> > Hi
> >
> > How can I select group by week
> >
> > moshe
> > ___
> > 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] Group by week

[John Stanton]

You need a function which gives the week number.  Note that this is 
calculated differently in the USA and Europe., so you need to use the 
correct rules to write the function.

Moshe Sharon wrote:
> Hi
>
> How can I select group by week
>
> moshe
> ___
> 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] basic problem...

[Jonas Sandman]

I'd think it's more a programming skill if you can "use SQLite". You
need some basic knowledge of SQL though which I guess would be
considered "a database skill". But that's just imho...

On Thu, Feb 5, 2009 at 3:48 PM, Mihai Limbasan  wrote:
> Oh, I understand now. Probably in the Database section.
>
> vade wrote:
>> Hello
>>
>> Thank you Mihai Limbasan.
>> For your clarification, Now I'm Preparing my Profile(cv or resume). I just
>> want to know where to show this sqlite3 skill.
>> whether in Programing skill section or database skill section or web
>> technology skill section.
>>
>> thank you
>>
>>
>> Mihai Limbasan wrote:
>>
>>> vade wrote:
>>>
 is sqlite3 is web skill OR database skill?
 can anybody please tell me...

 thank you in advance


>>> SQLite 3 is a database engine - a library. Part of a computer program.
>>> It's not a skill. A skill is an abstract concept.
>>>
>>> Could you perhaps rephrase your question?
>>> ___
>>> 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] basic problem...

[Mihai Limbasan]

Oh, I understand now. Probably in the Database section.

vade wrote:
> Hello
>
> Thank you Mihai Limbasan.
> For your clarification, Now I'm Preparing my Profile(cv or resume). I just
> want to know where to show this sqlite3 skill.
> whether in Programing skill section or database skill section or web
> technology skill section.
>
> thank you
>
>
> Mihai Limbasan wrote:
>   
>> vade wrote:
>> 
>>> is sqlite3 is web skill OR database skill?
>>> can anybody please tell me...
>>>
>>> thank you in advance
>>>   
>>>   
>> SQLite 3 is a database engine - a library. Part of a computer program. 
>> It's not a skill. A skill is an abstract concept.
>>
>> Could you perhaps rephrase your question?
>> ___
>> 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] basic problem...

[P Kishor]

On Thu, Feb 5, 2009 at 9:09 AM, vade  wrote:
>
> Hello
>
> Thank you Mihai Limbasan.
> For your clarification, Now I'm Preparing my Profile(cv or resume). I just
> want to know where to show this sqlite3 skill.
> whether in Programing skill section or database skill section or web
> technology skill section.

heh... the fact that you can't figure out where to put that "skill" in
your resumé tells me that you shouldn't be putting that "skill" in
that resumé.

but, thanks for being so candid.

>
> thank you
>
>
> Mihai Limbasan wrote:
>>
>> vade wrote:
>>> is sqlite3 is web skill OR database skill?
>>> can anybody please tell me...
>>>
>>> thank you in advance
>>>
>> SQLite 3 is a database engine - a library. Part of a computer program.
>> It's not a skill. A skill is an abstract concept.
>>
>> Could you perhaps rephrase your question?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] basic problem...

[vade]

Hello

Thank you Mihai Limbasan.
For your clarification, Now I'm Preparing my Profile(cv or resume). I just
want to know where to show this sqlite3 skill.
whether in Programing skill section or database skill section or web
technology skill section.

thank you


Mihai Limbasan wrote:
> 
> vade wrote:
>> is sqlite3 is web skill OR database skill?
>> can anybody please tell me...
>>
>> thank you in advance
>>   
> SQLite 3 is a database engine - a library. Part of a computer program. 
> It's not a skill. A skill is an abstract concept.
> 
> Could you perhaps rephrase your question?
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 
> 

-- 
View this message in context: 
http://www.nabble.com/basic-problem...-tp21851726p21852079.html
Sent from the SQLite mailing list archive at Nabble.com.

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

Re: [sqlite] basic problem...

[Mihai Limbasan]

vade wrote:
> is sqlite3 is web skill OR database skill?
> can anybody please tell me...
>
> thank you in advance
>   
SQLite 3 is a database engine - a library. Part of a computer program. 
It's not a skill. A skill is an abstract concept.

Could you perhaps rephrase your question?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] basic problem...

[vade]

is sqlite3 is web skill OR database skill?
can anybody please tell me...

thank you in advance
-- 
View this message in context: 
http://www.nabble.com/basic-problem...-tp21851726p21851726.html
Sent from the SQLite mailing list archive at Nabble.com.

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

Re: [sqlite] tclsqlite.c errors

[D. Richard Hipp]

On Feb 5, 2009, at 8:05 AM, mkrajachan...@gmail.com wrote:

> Hello All,
>
> I am compiling sqlite-3.6.7 to ARM target
>
> make fulltest (I need testfixture binary)
>
>While compiling its giving lots of errors in tclsqlite.c  
> file
>
>How can I getrid of this problem

testfixture and tclsqlite.c require TCL (http://www.tcl.tk/).  You  
need to get a working TCL development environment for your target  
platform.

If your goal is to test SQLite on your embedded platform, there are  
other options.  There are two other test harnesses for SQLite now.   
See http://www.sqlite.org/testing.html for additional information.


>
>
>Please help me
>
> Thanks in advance
>
> Chandru K
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

D. Richard Hipp
d...@hwaci.com



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

[sqlite] tclsqlite.c errors

[mkrajachandru]

Hello All,

 I am compiling sqlite-3.6.7 to ARM target

 make fulltest (I need testfixture binary)

While compiling its giving lots of errors in tclsqlite.c file

How can I getrid of this problem

Please help me

Thanks in advance

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

Re: [sqlite] Insertion and Updation using sqlite3_prepare()

[Igor Tandetnik]

"hussainfarzana"
 wrote in
message news:21849799.p...@talk.nabble.com
> We are using the sqlite3_prepare() and sqlite3_bind() methods for
> insertion and updation of the records in the database.Everything
> works fine and sqlite3_step() returns 101 which is SQLITE_DONE.When
> we check the DB, the records are not inserted.

Do you, by any chance, start a transaction and then forget to commit it?

Igor Tandetnik 



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

[sqlite] Insertion and Updation using sqlite3_prepare()

[hussainfarzana]

Dear All,

We are using SQLite version 3.6.10.

We are using the sqlite3_prepare() and sqlite3_bind() methods for insertion
and updation of the records in the database.Everything works fine and
sqlite3_step() returns 101 which is SQLITE_DONE.When we check the DB, the
records are not inserted.

Please help us in this regard.

Thanks and Regards,
Farzana.
-- 
View this message in context: 
http://www.nabble.com/Insertion-and-Updation-using-sqlite3_prepare%28%29-tp21849799p21849799.html
Sent from the SQLite mailing list archive at Nabble.com.

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

Re: [sqlite] Extraction SQL query from a sqlite3_stmt

[Roger Binns]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

aditya siram wrote:
> Once a sqlite3_stmt has been prepared and variables bound, is there some way
> of extracting the SQL query? 

http://www.sqlite.org/c3ref/sql.html

> So something in the way I am
> binding the variables is returns zero rows. I would like to see the final
> SQL before it is run.

You may be thinking that somehow the SQL query has the bound values
applied into it as text.  That is not the case - SQLite works with the
query and the bound values as is (separately).

Some common gotchas that may be the underlying cause:

- - Not checking the result of every call

- - Bound variable numbering starts at one not zero

- - Bound variables default to null until you override them

- - Null values can give unexpected results (eg null is not equal to null)

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkmKz30ACgkQmOOfHg372QSqdQCbBGW+xsDusCoVye6X3Ls91Xm0
I8cAnjO73Q+Q22VTQ3LHJoycjv0bnKRs
=df0M
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Error message This program cannot be run in DOS

[Martin.Engelschalk]

Hi,

what is your "DOS Prompt"? There are "command.com" and "cmd.exe". Try 
using "cmd.exe".

Martin

Richard Hardwick schrieb:
>> selecting the UNBLOCK button from the window displayed,  and unzip and
>> 
> Well I dont seem to have an unblock button
> Here is what I did
>
> I downloaded
> sqlite-3_6_10.zip  245,575  bytes
> which unzipped to
> sqlite3.exe501,456
>
> The start of file sqlite3.exe looks like this
> 4D 5A 90 00 03 00 00 00 04 00 00 00 FF FF 00 00
> B8 00 00 00 00 00 00 00 40 00 00 00 00 00 00 00
> 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> 00 00 00 00 00 00 00 00 00 00 00 00 80 00 00 00
> 0E 1F BA 0E 00 B4 09 CD 21 B8 01 4C CD 21 54 68
> 69 73 20 70 72 6F 67 72 61 6D 20 63 61 6E 6E 6F
> 74 20 62 65 20 72 75 6E 20 69 6E 20 44 4F 53 20
> 6D 6F 64 65 2E 0D 0D 0A 24 00 00 00 00 00 00 00
>
> That is
>
> MZ..
> .
> .
> .
> ...Th
> is program canno
> t be run in DOS
> mode
>
> And indeed "sqlite3.exeEX1.DB" at the dos prompt returns
> "This program cannot be run in DOS mode".
> I'm still stuck
>
> Richard H
>
>   
>> Message: 4
>> Date: Wed, 4 Feb 2009 17:28:35 +0530
>> From: Rajesh Nair 
>> Subject: Re: [sqlite] Error message This program cannot be run in DOS
>> mode
>> To: General Discussion of SQLite Database 
>> Message-ID:
>> 
>> Content-Type: text/plain; charset=ISO-8859-1
>>
>> Is it sqlite3.ex1 or sqlite3.exe ?
>>
>> Before unziping, Unlock the downloaded file by righ-clicking it an
>> selecting the UNBLOCK button from the window displayed,  and unzip and
>> then try. Unblock the EXE and the DLL file also, if needed.
>>
>> Rajesh Nair.
>>
>> On 2/4/09, Richard Hardwick  wrote:
>> 
>>> Stupid Newbie problem. I'm running WinXP.
>>> I want to make a little database.
>>> So at http://www.sqlite.org/download.html
>>> (Precompiled Binaries For Windows)
>>> I downloaded  sqlite-3_6_10.zip
>>>
>>> Unzipped it to sqlite3.exe.
>>> At DOS prompt I did
>>> sqlite3 ex1
>>> And I got
>>> "This program cannot be run in DOS mode".
>>>
>>> Googled for help and found
>>> http://jroller.com/obie/entry/installing_sqlite_3_on_windows
>>> Followed their suggestion.
>>> Downloaded sqlitedll-3_6_10.zip and unzipped to
>>> sqlite3.def and sqlite3.dll
>>>
>>> But still 'sqlite3 ex1' gives me "This program cannot be run in DOS mode".
>>> I'm stuck.
>>> Your help much appreciated
>>> rch
>>>
>>>
>>>
>>> ___
>>> sqlite-users mailing list
>>> sqlite-users@sqlite.org
>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>
>>>   
>> --
>> Regards
>> Rajesh Nair
>>
>>
>>
>>
>> 
>
>
>
>   
> ___
> 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] Error message This program cannot be run in DOS

[Richard Hardwick]

> selecting the UNBLOCK button from the window displayed,  and unzip and
Well I dont seem to have an unblock button
Here is what I did

I downloaded
sqlite-3_6_10.zip  245,575  bytes
which unzipped to
sqlite3.exe501,456

The start of file sqlite3.exe looks like this
4D 5A 90 00 03 00 00 00 04 00 00 00 FF FF 00 00
B8 00 00 00 00 00 00 00 40 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 80 00 00 00
0E 1F BA 0E 00 B4 09 CD 21 B8 01 4C CD 21 54 68
69 73 20 70 72 6F 67 72 61 6D 20 63 61 6E 6E 6F
74 20 62 65 20 72 75 6E 20 69 6E 20 44 4F 53 20
6D 6F 64 65 2E 0D 0D 0A 24 00 00 00 00 00 00 00

That is

MZ..
.
.
.
...Th
is program canno
t be run in DOS
mode

And indeed "sqlite3.exeEX1.DB" at the dos prompt returns
"This program cannot be run in DOS mode".
I'm still stuck

Richard H

> Message: 4
> Date: Wed, 4 Feb 2009 17:28:35 +0530
> From: Rajesh Nair 
> Subject: Re: [sqlite] Error message This program cannot be run in DOS
> mode
> To: General Discussion of SQLite Database 
> Message-ID:
> 
> Content-Type: text/plain; charset=ISO-8859-1
>
> Is it sqlite3.ex1 or sqlite3.exe ?
>
> Before unziping, Unlock the downloaded file by righ-clicking it an
> selecting the UNBLOCK button from the window displayed,  and unzip and
> then try. Unblock the EXE and the DLL file also, if needed.
>
> Rajesh Nair.
>
> On 2/4/09, Richard Hardwick  wrote:
> > Stupid Newbie problem. I'm running WinXP.
> > I want to make a little database.
> > So at http://www.sqlite.org/download.html
> > (Precompiled Binaries For Windows)
> > I downloaded  sqlite-3_6_10.zip
> >
> > Unzipped it to sqlite3.exe.
> > At DOS prompt I did
> > sqlite3 ex1
> > And I got
> > "This program cannot be run in DOS mode".
> >
> > Googled for help and found
> > http://jroller.com/obie/entry/installing_sqlite_3_on_windows
> > Followed their suggestion.
> > Downloaded sqlitedll-3_6_10.zip and unzipped to
> > sqlite3.def and sqlite3.dll
> >
> > But still 'sqlite3 ex1' gives me "This program cannot be run in DOS mode".
> > I'm stuck.
> > Your help much appreciated
> > rch
> >
> >
> >
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
> --
> Regards
> Rajesh Nair
>
>
>
>



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