Re: [sqlite] How to get the RecNo ???

select rowid, * from TestTable Tom Tom Brodhurst-Hill BareFeetWare -- iPhone/iPad/iPod and Mac software development, specialising in databases develo...@barefeetware.com -- Follow us on Twitter: http://twitter.com/barefeetware/ Like us on Facebook: http://www.facebook.com/BareFeetWare On

Re: [sqlite] Saving ubyte[] zlib data in sqlite and calling it back

True... "Simon Slavin" wrote... On 12 Feb 2013, at 1:33am, jose isaias cabrera wrote: have you thought of including these as part of the normal sqlite core functions? I feel that zlib has nothing to do with SQL or databases. It doesn't belong in a database

Re: [sqlite] Saving ubyte[] zlib data in sqlite and calling it back

On 12 Feb 2013, at 1:33am, jose isaias cabrera wrote: > have you thought of including these as part of the normal sqlite core > functions? I feel that zlib has nothing to do with SQL or databases. It doesn't belong in a database library. Simon.

Re: [sqlite] Saving ubyte[] zlib data in sqlite and calling it back

"Richard Hipp" wrote... On Mon, Feb 11, 2013 at 1:45 PM, jose isaias cabrera wrote: Greetings. I have this table, CREATE TABLE Test (login primary key, password); and I would like to save zlib data using ubyte[] and also call it back in. Are you trying to store zlib-compressed content

Re: [sqlite] help with select

On 2/11/2013 10:45 AM, e-mail mgbg25171 wrote: Perhaps I'm making a meal of my question... "All" I want to do is select only records that have field f1 = '' where it's other field f2 matches the value of f3 only in other records (1 or more) which have a non-'' f1 value. select * from MyTable

Re: [sqlite] Saving ubyte[] zlib data in sqlite and calling it back

Hello jose, I compress/encrypt to a vector, then write the vector as a blob and reverse. Read the blob as a vector then reverse the process. Monday, February 11, 2013, 1:45:34 PM, you wrote: jic> Greetings. jic> I have this table, jic> CREATE TABLE Test (login primary key, password); jic>

Re: [sqlite] Saving ubyte[] zlib data in sqlite and calling it back

Richard Hipp wrote... On Mon, Feb 11, 2013 at 1:45 PM, jose isaias cabrera wrote: Greetings. I have this table, CREATE TABLE Test (login primary key, password); and I would like to save zlib data using ubyte[] and also call it back in. Are you trying to store

Re: [sqlite] Saving ubyte[] zlib data in sqlite and calling it back

On Mon, Feb 11, 2013 at 1:45 PM, jose isaias cabrera wrote: > > Greetings. > > I have this table, > > CREATE TABLE Test (login primary key, password); > > and I would like to save zlib data using ubyte[] and also call it back in. Are you trying to store zlib-compressed

[sqlite] Saving ubyte[] zlib data in sqlite and calling it back

Greetings. I have this table, CREATE TABLE Test (login primary key, password); and I would like to save zlib data using ubyte[] and also call it back in. I have things like this: 1. To save in SQLite, cmd = " UPDATE Test password = " ~

Re: [sqlite] Set Mode to HTML via VBScript

On Mon, 11 Feb 2013 05:42:17 -0800 (PST), Jeff Steffanina wrote: >  >Hello All, >During a sqlite3 session, I need to APPEN output to a FILE in the HTML mode. >  >Here is my SELECT:  Select * from Booking; >  >What I really want to say is Set the mode, Execute select and append

[sqlite] help with select

I think this does it sql_s = "select * from " & _ "(select * from tbl_tv a where new_tnode = '') " & _ "where pnode = 0 or pnode in " & _ "(select tnode from tbl_tv where new_tnode <> '' )" & _ "and anode = 0 or anode in " &

[sqlite] help with select

Perhaps I'm making a meal of my question... "All" I want to do is select only records that have field f1 = '' where it's other field f2 matches the value of f3 only in other records (1 or more) which have a non-'' f1 value. To explain the f1 field shows whether or not the record has been written

[sqlite] help with select

Here's a chopped down query that demonstrates my difficulty do sql_s = "select * from tbl_tv where id in " & _ "(" & _ "select id from tbl_tv where " & _ "new_tnode = '' and " & _ "pnode = 0 or " & _

Re: [sqlite] How to get the RecNo ???

On 11 Feb 2013, at 3:01pm, Clemens Ladisch wrote: > Igor Tandetnik wrote: >> INTEGER PRIMARY KEY simply introduces a named alias for ROWID; its >> presence doesn't make anything possible that wasn't already possible >> without it. > > If the ROWID isn't 'officially' made

Re: [sqlite] How to get the RecNo ???

Igor Tandetnik wrote: > INTEGER PRIMARY KEY simply introduces a named alias for ROWID; its > presence doesn't make anything possible that wasn't already possible > without it. If the ROWID isn't 'officially' made part of the table's columns by declaring some INTEGER PRIMARY KEY, then it can be

Re: [sqlite] How to get the RecNo ???

On 2/10/2013 11:55 PM, Mohit Sindhwani wrote: I just meant to say that ROWID is not a sequence number of insertion in the case when an INTEGER PRIMARY KEY is used - it comes across as a sequence number when we don't have an integer primary key. I'm pretty sure (but too lazy to check) that you

Re: [sqlite] How to get the RecNo ???

On 2/11/2013 6:51 AM, Simon Slavin wrote: On 11 Feb 2013, at 3:45am, Igor Tandetnik wrote: On 2/10/2013 10:06 PM, Mohit Sindhwani wrote: * You decide then to do a sort by ROWID ASC - expecting that ROWID is maintaining the sequence since when you do a general SELECT *

Re: [sqlite] Set Mode to HTML via VBScript

On 11 Feb 2013, at 1:42pm, Jeff Steffanina wrote: > During a sqlite3 session, I need to APPEN output to a FILE in the HTML mode. > > Here is my SELECT: Select * from Booking; > > What I really want to say is Set the mode, Execute select and append to > MySummary: > >

Re: [sqlite] MIN(x), MAX(x) confusion

On Mon, Feb 11, 2013 at 8:46 AM, Stephan Beal wrote: > Hiho, > > Summary: i'm getting an incorrect/unexpected MIN()/MAX() results and have > no clue why. After running these results by a colleague, we're both > confused, and thus this post. Here's my data (JMeter output)

Re: [sqlite] MIN(x), MAX(x) confusion

Probably because you're storing your numbers as text. How are you inserting them? Do a .dump from the shell and you'll see it in the record dump. So '7' > '20' but 7 < 20 -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of

[sqlite] MIN(x), MAX(x) confusion

Hiho, Summary: i'm getting an incorrect/unexpected MIN()/MAX() results and have no clue why. After running these results by a colleague, we're both confused, and thus this post. Here's my data (JMeter output) and results: SQLite version 3.7.16 2013-01-03 19:34:46 (built from sources updated an

[sqlite] Set Mode to HTML via VBScript

  Hello All, During a sqlite3 session, I need to APPEN output to a FILE in the HTML mode.   Here is my SELECT:  Select * from Booking;   What I really want to say is Set the mode, Execute select and append to MySummary:   mode html    Select * from Booking >> MySummary.html   Any help is greatly

Re: [sqlite] Sqlite and AS400

>> Hi all, I'm a new user in this list. >> >> Is possible to connect to a SQLITE database from AS400? > > Please read the mailing list you post to. > > Simon. Sorry, this was my mistake, a wrong double post that was approved today. Mauro ___

Re: [sqlite] Sqlite and AS400

On 10 Feb 2013, at 6:38pm, Stellar Solutions wrote: > Hi all, I'm a new user in this list. > > Is possible to connect to a SQLITE database from AS400? Please read the mailing list you post to. Simon. ___ sqlite-users

[sqlite] Sqlite and AS400

Hi all, I'm a new user in this list. Is possible to connect to a SQLITE database from AS400? Any help will be appreciated. Mauro ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite Trace Log

Hello, Not exactly the program language you asked for, but here it is how I have it in C for gtk: Call this function after opening the connection: sqlite3_trace ( sqliteconnection, sqlite_trace, NULL ); static void sqlite_trace ( void *arg, const char *query ) { FILE *file = fopen (