Re: [sqlite] Comparing two tables column by column

2013-07-29 Thread Fehmi Noyan ISI
EXCEPT query gave the different rows in tables, but what I am after is the different values for existing records. The column names are exactly the same, however the number of rows may differ (with most of the records are the same). From: Simon Slavin

Re: [sqlite] Comparing two tables column by column

2013-07-29 Thread Fehmi Noyan ISI
: Stadin, Benjamin benjamin.sta...@heidelberg-mobil.com To: Fehmi Noyan ISI fnoyan...@yahoo.com; General Discussion of SQLite Database sqlite-users@sqlite.org Sent: Tuesday, July 30, 2013 9:00 AM Subject: Re: [sqlite] Comparing two tables column by column If you like ruby, I have another idea to get

[sqlite] Comparing two tables column by column

2013-07-28 Thread Fehmi Noyan ISI
Hi, I would like to compare two tables row by row having same primary keys. The comparison should take each row from TABLE1 and find relevant entry (based on KEY) from TABLE2 and compare value of EACH column. For the TABLE1 and TABLE2 below, the values of COL4 for KEY3 should be returned

Re: [sqlite] Comparing two tables column by column

2013-07-28 Thread Fehmi Noyan ISI
Thanks for the reply... One point I forgot to mention; the number of columns is unknown... Actually there are more than 40-50 tables that needs to be examined. From: Stephen Chrzanowski pontia...@gmail.com To: Fehmi Noyan ISI fnoyan...@yahoo.com; General

Re: [sqlite] DLL Size differences and other info requested

2013-07-03 Thread Fehmi Noyan ISI
As far as I remember, DevC++ does not have strip option enabled by default for release version of your binary. You may want to have a quick look at your project compile options to minimize your binary size. The -s option reduces binary size significantly in some cases.

Re: [sqlite] DLL Size differences and other info requested

2013-07-03 Thread Fehmi Noyan ISI
) From: Stephen Chrzanowski pontia...@gmail.com To: Fehmi Noyan ISI fnoyan...@yahoo.com; General Discussion of SQLite Database sqlite-users@sqlite.org Sent: Thursday, July 4, 2013 9:08 AM Subject: Re: [sqlite] DLL Size differences and other info requested I just reduced my built file

Re: [sqlite] Fw: problem sqlite3 c++ please

2013-05-30 Thread Fehmi Noyan ISI
Hi, The command you entered, starting with dot, are sqlite shell commands, i.e. if you need similar functionality, you either * need to check SQLite C/C++ API documentation for a fucntion  or * need to implement your own function From: Maxime Gerum

Re: [sqlite] Fw: problem sqlite3 c++ please

2013-05-30 Thread Fehmi Noyan ISI
specific to your question, if you want to import/export with C API, you can try these extensions https://github.com/fnoyanisi/sqlite3_capi_extensions From: Fehmi Noyan ISI fnoyan...@yahoo.com To: General Discussion of SQLite Database sqlite-users@sqlite.org

Re: [sqlite] Getting Started with Sqlite

2013-05-22 Thread Fehmi Noyan ISI
I do not have this issue with my sqlite 3.7.14 installation in Win7. Any more details? From: Sean Dzafovic sdzafo...@gmail.com To: sqlite-users@sqlite.org Sent: Wednesday, May 22, 2013 10:28 PM Subject: [sqlite] Getting Started with Sqlite I downloaded the

Re: [sqlite] Getting Started with Sqlite

2013-05-22 Thread Fehmi Noyan ISI
I think it depends on how you compiled sqlite. I my case, it is dynamically linked to dll, so I do need the dll file (with a smaller exe size). However, a static link seems suites better the case for sqlite (how big can its file size be!?) From: Adam DeVita

Re: [sqlite] Getting Started with Sqlite

2013-05-22 Thread Fehmi Noyan ISI
Oh my gosh! you are in business man... You run the sqlite without any problems, don't you? Have a look at the step-by-step cmd.exe example below As other guys pointed out in their previous posts, you supposed to use sqlite3 test.db command from the Windows Command line. Not inside the sqlite

Re: [sqlite] sqlite shell: arrow keys

2013-05-16 Thread Fehmi Noyan ISI
Depends on your system I think. Here is what is contained in shell.c readline.h is the thing making all those history and similar things you use in your linux command line shell available. #ifdef HAVE_EDITLINE # include editline/editline.h #endif #if defined(HAVE_READLINE) HAVE_READLINE==1 #

Re: [sqlite] Store sqlite database problem

2013-05-08 Thread Fehmi Noyan ISI
This question is more C related than SQlite... You were advised to use www.programming.com in your previous posts, portal has a good programming forum. From: Newbie89 sh_ta...@hotmail.com To: sqlite-users@sqlite.org Sent: Thursday, May 9, 2013 1:40 AM

Re: [sqlite] How to link the packet in C file then store in sqlite database?

2013-05-01 Thread Fehmi Noyan ISI
This seems to be a C programming question rather than sqlite related issue. You even did not mention which information you would like to store, we only have a code snippet that processes a captured network packet. something like this would work sqlite3_prepare_v2() // use a template with ?

Re: [sqlite] import with quotation mark

2013-04-23 Thread Fehmi Noyan ISI
Did you try explicitly declaring your separator via .separator command? You should be able to importing the line with quotas included in it. http://www.sqlite.org/cvstrac/wiki?p=ImportingFiles From: Spora sp...@email.it To: sqlite-users@sqlite.org Sent: