Re: [sqlite] tclsqlite.c errors

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

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

"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

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

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

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

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,

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

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

[sqlite] Finalize after a failed call to prepare

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

Re: [sqlite] basic problem...

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,

Re: [sqlite] error in Linux

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

[sqlite] error in Linux

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

Re: [sqlite] basic problem...

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

Re: [sqlite] Group by week

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:

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

Re: [sqlite] Group by week

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 >

Re: [sqlite] basic problem...

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

Re: [sqlite] basic problem...

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

Re: [sqlite] basic problem...

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

Re: [sqlite] basic problem...

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

Re: [sqlite] basic problem...

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] basic problem...

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.

Re: [sqlite] tclsqlite.c errors

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

[sqlite] tclsqlite.c errors

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

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

"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] Insertion and Updation using sqlite3_prepare()

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.

Re: [sqlite] Extraction SQL query from a sqlite3_stmt

-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

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

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 >

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

> 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