Re: [sqlite] SQL newbie, how to implement a delete correctly.

Simon, On Tue, Dec 30, 2014 at 1:41 PM, Simon Slavin wrote: > On 30 Dec 2014, at 6:19pm, Jonathan Leslie wrote: > >> C:\jon>cat t2.lis | gawk "/.*/ { print \"delete from \" $3 \" where \" $4 }" >> |cut -d"," -f1delete from "parent01" where

Re: [sqlite] SQL newbie, how to implement a delete correctly.

On 30 Dec 2014, at 6:19pm, Jonathan Leslie wrote: > C:\jon>cat t2.lis | gawk "/.*/ { print \"delete from \" $3 \" where \" $4 }" > |cut -d"," -f1delete from "parent01" where VALUES(1417556005delete from > "child01" where VALUES(1417626376delete from "child01" where >

Re: [sqlite] SQL newbie, how to implement a delete correctly.

"child01" where --- 1419259626; From: Jonathan Leslie <j...@jonathanleslie.com> To: Jonathan Leslie <j...@jonathanleslie.com>; General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Tuesday, December 30, 2014 1:19 PM Subject: Re: [sqlite] SQL n

Re: [sqlite] SQL newbie, how to implement a delete correctly.

sion of SQLite Database <sqlite-users@sqlite.org>; General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Tuesday, December 30, 2014 1:02 PM Subject: Re: [sqlite] SQL newbie, how to implement a delete correctly. Ok, I forgot to mention.  I had the presence of min

Re: [sqlite] SQL newbie, how to implement a delete correctly.

that have the id 1417556005 in it.  From: Jonathan Leslie <j...@jonathanleslie.com> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Tuesday, December 30, 2014 12:52 PM Subject: Re: [sqlite] SQL newbie, how to implement a delete correctly. thank

Re: [sqlite] SQL newbie, how to implement a delete correctly.

Decker <d3c...@gmail.com> To: Jonathan Leslie <j...@jonathanleslie.com>; General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Tuesday, December 30, 2014 12:47 PM Subject: Re: [sqlite] SQL newbie, how to implement a delete correctly. On Tue, Dec 30, 2014 at

Re: [sqlite] SQL newbie, how to implement a delete correctly.

lavin <slav...@bigfraud.org> > To: Jonathan Leslie <j...@jonathanleslie.com>; General Discussion of > SQLite Database <sqlite-users@sqlite.org> > Sent: Tuesday, December 30, 2014 11:14 AM > Subject: Re: [sqlite] SQL newbie, how to implement a delete corre

Re: [sqlite] SQL newbie, how to implement a delete correctly.

t; Sent: Tuesday, December 30, 2014 11:14 AM Subject: Re: [sqlite] SQL newbie, how to implement a delete correctly. On 30 Dec 2014, at 3:53pm, Jonathan Leslie <j...@jonathanleslie.com> wrote: > Sorry, I wasn't clear.  what if there are other child tables, say child02- > childxx

Re: [sqlite] SQL newbie, how to implement a delete correctly.

: Jonathan Leslie [mailto:j...@jonathanleslie.com] Gesendet: Dienstag, 30. Dezember 2014 16:53 An: General Discussion of SQLite Database Betreff: Re: [sqlite] SQL newbie, how to implement a delete correctly. Sorry, I wasn't clear.   what if there are other child tables, say child02- childxx

Re: [sqlite] SQL newbie, how to implement a delete correctly.

On 30 Dec 2014, at 3:53pm, Jonathan Leslie wrote: > Sorry, I wasn't clear. what if there are other child tables, say child02- > childxx, and you don't know the names of the table, you want to search the > entire database? SQLite has no command which will help it

Re: [sqlite] SQL newbie, how to implement a delete correctly.

.at> To: 'Jonathan Leslie' <j...@jonathanleslie.com>; 'General Discussion of SQLite Database' <sqlite-users@sqlite.org> Sent: Tuesday, December 30, 2014 10:35 AM Subject: Re: [sqlite] SQL newbie, how to implement a delete correctly. Select * from child01 where p01_id in (select r

Re: [sqlite] SQL newbie, how to implement a delete correctly.

Select * from child01 where p01_id in (select rowid from parent01 where ...); Or Select c.* from parent01 p join child01 c on p.rowid=c.p01_id where ...; -Ursprüngliche Nachricht- Von: Jonathan Leslie [mailto:jlesli...@yahoo.com] Gesendet: Dienstag, 30. Dezember 2014 15:58 An:

Re: [sqlite] Blob newbie problem

Black, Michael (IS) wrote: > > Do I understand you're still seeing a segfault? I assume you're not > seeing your "Year retrieved..." statement? > > You haven't showed us your table definition. > > Change your strcmp to strcasecmp and see if that fixes it for you. > > Michael D. Black > >

Re: [sqlite] Blob newbie problem

StyveA wrote: > I tried with your tips, and I've seen that I was missing the call of my > callback function, and now the segfault is in it.. Personally, I vastly prefer sqlite3_step / sqlite3_column* interface to sqlite3_exec. I never use the latter except for

Re: [sqlite] Blob newbie problem

on Systems Advanced Analytics Directorate From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of StyveA [styve.at...@technicolor.com] Sent: Thursday, May 12, 2011 7:39 AM To: sqlite-users@sqlite.org Subject: EXT :Re: [sqlite] Blob newb

Re: [sqlite] Blob newbie problem

Igor Tandetnik wrote: > > Prepare doesn't touch the database in any way. It just parses the text of > the statement, and prepares execution plan. Step is where the real work is > done. > > You need to issue BEGIN statement if you want to start an explicit > transaction (and then COMMIT or END

Re: [sqlite] Blob newbie problem

StyveA wrote: > For the COMMIT/END point, I though that sqlite_prepare(..) was sufficient > to do it, so Begin is mandatory? Prepare doesn't touch the database in any way. It just parses the text of the statement, and prepares execution plan. Step is where the real

Re: [sqlite] Blob newbie problem

Igor Tandetnik wrote: > > StyveA wrote: >> I'm a newbie using sqlite3, and i'm trying to save in a database some >> blob >> datas (just string and integer), >> but I can't get my data back.. I just obtain a segfault.. >> I have searched in forums, but did'nt find

Re: [sqlite] Blob newbie problem

StyveA wrote: > I'm a newbie using sqlite3, and i'm trying to save in a database some blob > datas (just string and integer), > but I can't get my data back.. I just obtain a segfault.. > I have searched in forums, but did'nt find anything that could help me.. > > int

Re: [sqlite] Embarassed Newbie

james630...@aol.com wrote, On 08/01/11 13:45: > Hi Peter, > > Thanks for your response. > > At the DOS command prompt I manually changed directory as suggested but to > no avail. > > I originally downloaded all 3 downloads as instructed by the download page. > Whilst I was able to unzip the

Re: [sqlite] Embarassed Newbie

Hi Peter, Thanks for your response. At the DOS command prompt I manually changed directory as suggested but to no avail. I originally downloaded all 3 downloads as instructed by the download page. Whilst I was able to unzip the first two folders my attempts to unzip the last results in

Re: [sqlite] Embarassed Newbie

Hello Michael, Yeah, sqlite3.exe runs everywhere. This problem is more basic. Sqlite3.exe is in some other path and not in the command line search path. Where did you unzip the files? Either do the test from the folder you unzipped the files to or use full path C:> C:\Unzipped\Sqlite3.exe

Re: [sqlite] Embarassed Newbie

Richard Hipp wrote, On 08/01/11 13:10: > On Sat, Jan 8, 2011 at 8:06 AM, Peter wrote: >> On 08/01/11 11:43, james630...@aol.com wrote: >>> sqlite3 test.db >> >> I assume by 'binaries' you mean sqlite-shell-win32... and >> sqlite-dll-win32...? You need both to run

Re: [sqlite] SQL Newbie problem I guess...

Thanks for the input. The 'Folder' vs 'Folders' problem was merely a spelling mistake here, not in the code. My problem was that '%' was being escaped in my code. Putting a '%%' fixed the problem. Regards, Jonas On Tue, Mar 11, 2008 at 5:37 PM, Dennis Cote <[EMAIL PROTECTED]> wrote: > > Jonas

Re: [sqlite] SQL Newbie problem I guess...

Jonas Sandman wrote: > > I must be missing something obvious here... > > I have created my database like this: > > CREATE TABLE Folders (folderid INTEGER PRIMARY KEY, parentid INTEGER, > rootid INTEGER, path VARCHAR(255))"; > > The database is filled with files and folders.. > > folderid

Re: [sqlite] SQL Newbie problem I guess...

Hi Jonas, It seems to me that you only need the path in your query: DELETE FROM Folders WHERE path LIKE 'C:\MP3\Albums\%'; Alternatively you could keep parentid and just the appended path, ie: folderid parentid path 1 0C:\MP3\Albums\ 2 1Abba - Definitive

RE: [sqlite] a newbie

-Original Message- From: gerardo cabero [mailto:[EMAIL PROTECTED] Sent: Friday, January 04, 2008 9:45 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] a newbie Sì yo hablo espanol. No Hablo espanol en muchos anos. Scott aLGUNO QUE HABLE ESPAÑOL??? SALUDOS GERARD On 1/3/08, Scott

Re: [sqlite] a newbie

aLGUNO QUE HABLE ESPAÑOL??? SALUDOS GERARD On 1/3/08, Scott Berry <[EMAIL PROTECTED]> wrote: > > Hey guys, > > My name is Scott Berry and I am totally blind and a newbie to Sqlite. I > have two questions concerning Sqlite. The questions I have is I have an > Excel file which will be going in to

RE: [sqlite] a newbie

Message- From: Christopher Smith [mailto:[EMAIL PROTECTED] Sent: Thursday, January 03, 2008 4:45 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] a newbie > From: [EMAIL PROTECTED] > To: sqlite-users@sqlite.org > Date: Thu, 3 Jan 2008 15:21:47 -0600 > Subject: [sqlite] a newbie &

RE: [sqlite] a newbie

> From: [EMAIL PROTECTED] > To: sqlite-users@sqlite.org > Date: Thu, 3 Jan 2008 15:21:47 -0600 > Subject: [sqlite] a newbie > > Hey guys, > > My name is Scott Berry and I am totally blind and a newbie to Sqlite. I > have two questions concerning Sqlite. The questions I have is I have an >

Re: [sqlite] Re: Newbie - can't create database but I can attach

Thank you Igor, I appreciate your time! I wasn't specific enough, here's what's happening in my DOS window... --- SQLite version 3.3.17 Enter ".help" for instructions sqlite> sqlite3 testdatabase //hard return ...> ; //hard return SQL error: near "sqlite3": syntax error sqlite> --- I was

Re: [sqlite] Re: Newbie question about LIKE and ESCAPE

- Original Message - From: "Igor Tandetnik" <[EMAIL PROTECTED]> To: "SQLite" <sqlite-users@sqlite.org> Sent: Sunday, March 04, 2007 12:59 AM Subject: [sqlite] Re: Newbie question about LIKE and ESCAPE > For example, this query retrieves all rows where

Re: [sqlite] Re: Newbie SQL question

Igor: Thank you very much for your's help A.J.Millan - Original Message - From: "Igor Tandetnik" <[EMAIL PROTECTED]> To: "SQLite" <sqlite-users@sqlite.org> Sent: Tuesday, February 06, 2007 10:50 PM Subject: [sqlite] Re: Newbie SQL qu

Re: [sqlite] Re: newbie ask saving

Can you give me sample code how to use it? I still not understand when I read capi3ref.html thx. On Mon, 5 Feb 2007 18:36:04 -0500 "Igor Tandetnik" <[EMAIL PROTECTED]> wrote: > Hariyanto <[EMAIL PROTECTED]> wrote: > > I have 2 table: > > > > 1. Table A : > > no INTEGER PRIMARY KEY, > > name

Re: [sqlite] Dumb Newbie Question - Comparison if sqlite index to STL

--- Ben Supnik <[EMAIL PROTECTED]> wrote: > I am porting my app's data model from C++/STL to sqlite. My goal is > scalability - even if I implement my data model in C++ using data > structures that give me good O(N) time (e.g. use trees, hash tables, > etc.) the whole thing has to be in

Re: [sqlite] Dumb Newbie Question - Comparison if sqlite index to STL

On 1/25/07, Ben Supnik <[EMAIL PROTECTED]> wrote: Hi Y'all, Please forgive what I think is probably a dumb question, but... I am porting my app's data model from C++/STL to sqlite. My goal is scalability - even if I implement my data model in C++ using data structures that give me good O(N)

Re: [sqlite] Re: Newbie sqlite questions: check existence of column

Thanks for this quick reply :) On 11/13/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote: Florent THIERY <[EMAIL PROTECTED]> wrote: > Some files have optional fields, so what i'd like to do is, whenever > such a file is scanned and parsed, i want my software to > - check first if the column

Re: [sqlite] A newbie question

Hello erw2, This is how I do it. HRESULT hr = Compile("INSERT OR IGNORE INTO Files_V1" "(" "FileOrder," "Filename," "Length," "Signature," "Date," "Topic, "

Re: [sqlite] Linux Newbie...

Bom dia, Maurício! Já estou trabalhando direitinho no Linux. Você está usando oSQLite com que propósitos? Até mais, Cláudio --- "Mauricio M. Maia" <[EMAIL PROTECTED]> escreveu: > Claudio, > > you need to execute like: > $ ./sqlite3-3.2.1.bin > > PS: If you want, send a private message to

Re: [sqlite] Linux Newbie...

> pwd is not in your path. > try ./sqlite3-3.2.1.bin Thanks toi everybody! It worked very well!!! Cláudio > also make sure it's got the right permissions: > > chmod a+x sqlite3-3.2.1.bin > > HTH, > B > > Claudio Bezerra Leopoldino wrote: > > Hi! > > > > I've used the windows command line

Re: [sqlite] Linux Newbie...

> I've used the windows command line SQLite utility > without problems, but the linux version GZ file > doesn't worked in mine tests. I extracted the file > with gunzip, but the binary file doesn't worked. It > can be a very basic problem to an esxperient linux > user, but i couldn't execute the

Re: [sqlite] Linux Newbie...

At 19:53 19/05/2005, you wrote: Hi! I've used the windows command line SQLite utility without problems, but the linux version GZ file doesn't worked in mine tests. I extracted the file with gunzip, but the binary file doesn't worked. It can be a very basic problem to an esxperient linux user, but

Re: [sqlite] Linux Newbie...

Claudio Bezerra Leopoldino <[EMAIL PROTECTED]> writes: > May someone tell me a clue to execute the SQLite > utility in linux environment? Or a need to compile the > source code to use the utility? > == > [EMAIL PROTECTED] SQLite]$ ls -l > total 372 >

Re: [sqlite] Linux Newbie...

pwd is not in your path. try ./sqlite3-3.2.1.bin also make sure it's got the right permissions: chmod a+x sqlite3-3.2.1.bin HTH, B Claudio Bezerra Leopoldino wrote: Hi! I've used the windows command line SQLite utility without problems, but the linux version GZ file doesn't worked in mine tests. I

Re: [sqlite] Desperate newbie: .def problem??

Clay Dowling wrote: Bill Henderson said: I have the Dev-Cpp IDE installed and have successfully compiled and linked several test programmes and am satisfied that dev-cpp is functioning correctly. Bill, You need to generate the libsqlite3.a library, which you can do with dlltool. I don't

Re: [sqlite] Desperate newbie: .def problem??

Bill Henderson said: > I have the Dev-Cpp IDE installed and have successfully compiled and > linked > several test programmes and am satisfied that dev-cpp is functioning > correctly. Bill, You need to generate the libsqlite3.a library, which you can do with dlltool. I don't remember the