Apologies for the below statement:
Seems the culprit is line 5's testlog.error. It doesn't seem to see a 3
level deep SELECT. Running from line 2.
I was trying to modify the query line and forgot to clean my email. But the
statement about "3 level deep" stays. :-)
Thanks,
John
Hello folks,
Not sure if I'm doing this right or not but...
.. I'm trying to query the total occurence of an error on the last status of
the unit. Anyways, my table contains at least these fields: sn (serial
number), error (error code), testend (test time).
Right now I'm doing this query:
On 7/13/06, zze-ContentLab MARTINEAU Y ext RD-SIRP-REN
<[EMAIL PROTECTED]> wrote:
I tried with the last version but I still have the same problems.
I'm not sure that the appropriated version of sqlite API is used in my
application
To find out which version of SQLite your application is
andrew gatt <[EMAIL PROTECTED]> wrote:
select 1 from table where id == 1 OR id == 2;
which will return:
1
1
if they both exist, but if one doesn't exist i can't tell which one
it is. Is there some way to get the statement to return a row with a
0 if the id doe not exist?
1
0
Or do i have to
> "andrew gatt" <[EMAIL PROTECTED]> writes:
>
> > I'm trying to come up with an SQL statement that works under sqlite that
can
> > return a list of rows depending if a list of ids exist. For individual
> > checking i'm using:
> >
> > select 1 from table where id == 1;
> >
> > which returns a 1 if
"andrew gatt" <[EMAIL PROTECTED]> writes:
> I'm trying to come up with an SQL statement that works under sqlite that can
> return a list of rows depending if a list of ids exist. For individual
> checking i'm using:
>
> select 1 from table where id == 1;
>
> which returns a 1 if there is a row
Hi all,
I'm trying to come up with an SQL statement that works under sqlite that can
return a list of rows depending if a list of ids exist.
For individual checking i'm using:
select 1 from table where id == 1;
which returns a 1 if there is a row or no rows if it doesn't exist. However i
have
Concurrency is the number of simultaneous, independent users of the
database, not the transaction rate. That is the criterion I would use
to select the appropriate tool.
Cesar David Rodas Maldonado wrote:
About the concurrence, i don't know... about 2000 queries per second...
Wich
db engine
Christian Smith wrote:
John Newby uttered:
Hi Martin, I'm not sure, I don't use VB that often, I just need to use it
for my Uni project at the moment.
With all due respect to your University, but VB sucks as a teaching
language IMO. Doesn't your Uni have better development tools? Any
Hi all, I would like to thank you all for helping me with my problems. I
have managed to obtain the details from the SQLite DBMS that I required.
The problems I am having now are predominantly VB.Net(and my lack of
understanding of the language) related so I will leave you all now as this
thread
On 7/13/06, Pedro J. Vivancos <[EMAIL PROTECTED]> wrote:
No, I'm no sure. How can I test it? I've just started to learn C/C++ and
I have no idea how to do it.
While it is theoretically possible to test the encoding of the string,
I'm not sure how practical it is. I think it would be easier to
I can't see anything obviously wrong with that code, but that's probably
because it's the only bit of VB I've ever looked at. :-/
You need to divide and conquer - does the combo box get filled properly
if you hard code the values in fieldNames in selectFieldNames()? If so,
print out the value
John Newby uttered:
Hi Christian,
Nope VB is the best they can come up with, and it's only version 2002, they
can't even get the latest edition so I have to work with an outdated wrapper
aswell.
The standards of education these days. Still, it's better than the F77 my
uni shoved down our
John Newby wrote:
Hi Fred, I am using vb.net 2002. I am not sure about dynamic arrays, I am
looking into it now
URLs may wrap
For dictionaries:
http://windowssdk.msdn.microsoft.com/en-us/library/x4k5wbx4.aspx
For dynamic arrays:
Jay Sprenkle uttered:
On 7/13/06, Christian Smith <[EMAIL PROTECTED]> wrote:
You can't use aggregate functions in WHERE clauses. Also, you can't use a
select as the value in an insert. You can insert from the results of an
insert.
uh...It seems to work:
The OP was trying to use a SELECT
If you're using VB.NET 2002, then look at the following classes:
System.Collections.ArrayList
System.Collections.SortedList
System.Collections.Hashtable
These are all dynamic container classes.
Mike
-Ursprüngliche Nachricht-
Von: John Newby [mailto:[EMAIL PROTECTED]
Gesendet:
Hi Mike, I am using vb.net 2002. I looked at the scripting.dictionary class
as suggested earlier in the thread, but I could not understand it. I would
think a count of the rows would be needed in order to know how many times
the while loop would need to be executed to add the name of each
Hi Fred, yes I am using vb.net. I have searched online for vb.net dynamic
arrays, and one site I came accross states the new features of the
2.0framework allows for dynamic arrays but sadly I am using the
1.1 version.
http://www.ondotnet.com/pub/a/dotnet/2004/05/25/whidbey_vbnet_pt2.html
I am
Hi Fred, I am using vb.net 2002. I am not sure about dynamic arrays, I am
looking into it now
Many thanks
John
On 13/07/06, Fred Williams <[EMAIL PROTECTED]> wrote:
What language are you using? Can't you do a dynamic array?
> -Original Message-
> From: John Newby [mailto:[EMAIL
If you're using VB6 your choices are VBs native Collection or the
Scripting.Dictionary class mentioned by Craig. Look them up in VBs online
help, there are examples on using them. I'd suggest get more familiar with
VB and its Container classes...
Mike
-Ursprüngliche Nachricht-
Von: John
Hi Martin, I'm not sure about the wrapper, and because it is an old wrapper,
there is no help pages for it and it no longer gets updated as there is now
a version for 2.0
My deadline is the end of the month for the project, but I also have to make
time to do my dissertation.
I think I am nearly
"Cesar David Rodas Maldonado" <[EMAIL PROTECTED]> wrote:
> Thanks for explain me that... so what do you think will be the solution?
Lots more RAM. Enough to hold the entire database.
--
D. Richard Hipp <[EMAIL PROTECTED]>
Hi Craig, thanks for your comments, but I can't seem to get that to work, it
says that add and count aren't part of the dictionaryBase or dictionaryEntry
(those being the only 2 dictionary things i could find in vb)
I think I'm nearly there with the array.
Thanks again for your help
John
On
VB always had dynamic containers. Starting with Arrays things such as ReDim
helped. Later Collection(s) (actually a Dictionary/Hashtable) were
introduced. In VB.NET you of course have all containers, which the .NET
framework supplies. In fact there are classes for Lists (ArrayList,
LinkedList and
Did not realize he was using VB when I sent my last message. I'd bet VB
still can't do anything dynamic. That's only one of the reasons I
walked away from VB's "Daddy" (Quick Basic) years ago.
> -Original Message-
> From: Martin Jenkins [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July
Richard Hipp :
Thanks for explain me that... so what do you think will be the solution?
what do you think about db in Clustering.
On 7/13/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
"Cesar David Rodas Maldonado" <[EMAIL PROTECTED]> wrote:
> About the concurrence, i don't know... about
What language are you using? Can't you do a dynamic array?
> -Original Message-
> From: John Newby [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 13, 2006 7:37 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] How do you find out the names of the
> fields within
> a table?
>
>
"Cesar David Rodas Maldonado" <[EMAIL PROTECTED]> wrote:
> About the concurrence, i don't know... about 2000 queries per second... Wich
> db engine will be good?... i have a server with 2 GB ram, AMD sempron
> 64bits,
>
You have 8 billion records and 2 billion bytes of ram.
So your data will not
At 17:22 13/07/2006, you wrote:
About the concurrence, i don't know... about 2000 queries per second... Wich
db engine will be good?... i have a server with 2 GB ram, AMD sempron
64bits,
First, i'll try PostgreSQL, Firebird and at last (very last) MySQL.
For commercial databases, Valentina
It depends (I know, not the answer you had hoped for!)
How are your query and parameter strings obtained (command line, compiled
static strings, files, gui, other)?
What encoding are these input strings?
Are you using sqlite3_exec, sqlite3_prepare or sqlite3_prepare16 to execute the
query?
About the concurrence, i don't know... about 2000 queries per second... Wich
db engine will be good?... i have a server with 2 GB ram, AMD sempron
64bits,
On 7/12/06, John Stanton <[EMAIL PROTECTED]> wrote:
Jay gave you the clue. You need to have software and hardware which
will address data
John Newby wrote:
I would still need to know how many times to go through the while
> loop to add the names of the fields?
John,
I haven't been following this thread that closely, but (based on other
wrappers I've used) I would have expected your sqlite wrapper to do one
of two things:
a)
John Newby wrote:
Hi Craig, I have looked into the dictionary that you suggested, but
wouldn't
this be the same as the array as I would still need to know how many times
to go through the while loop to add the names of the fields? Also I
need to
get the names of the fields back out to
Hi Christian,
Nope VB is the best they can come up with, and it's only version 2002, they
can't even get the latest edition so I have to work with an outdated wrapper
aswell.
I was reading your reply regarding the Max(id) thread, I was wondering if I
could use this for my query.
The pragma
On 7/13/06, Christian Smith <[EMAIL PROTECTED]> wrote:
You can't use aggregate functions in WHERE clauses. Also, you can't use a
select as the value in an insert. You can insert from the results of an
insert.
uh...It seems to work:
SQLite version 3.0.8
Enter ".help" for instructions
sqlite>
Lukas Kahwe Smith <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
>
> >> I am working on integrating pattern character escaping into PEAR::MDB2.
> >> I am using PHP's ext/sqlite which only supports SQLite version 2
> >> (version 3 is supported only through pecl::pdo_sqlite).
> >>
> >> Is it
John Newby uttered:
Hi Martin, I'm not sure, I don't use VB that often, I just need to use it
for my Uni project at the moment.
With all due respect to your University, but VB sucks as a teaching
language IMO. Doesn't your Uni have better development tools? Any
professor that advocates VB
Keiichi McGuire uttered:
I'm a bit stuck on this one problem
I have this simple table that has two fields: id and value.
What I want to do is to get the largest id (the last entry) and then add an
arbitrary number to the value that's in the same entry as that one, and put
the result in the
[EMAIL PROTECTED] wrote:
I am working on integrating pattern character escaping into PEAR::MDB2.
I am using PHP's ext/sqlite which only supports SQLite version 2
(version 3 is supported only through pecl::pdo_sqlite).
Is it possible to have literal % and _ in LIKE expressions in version 2?
Hi Nuno, I tried the select statement you recommended, it does not return
any value!!
No I dont think my wrapper returns the column names, it is too late to
change wrappers now, I am too close to my deadline to start again.
Many thanks
John
On 13/07/06, Nuno Lucas <[EMAIL PROTECTED]> wrote:
Lukas Kahwe Smith <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am working on integrating pattern character escaping into PEAR::MDB2.
> I am using PHP's ext/sqlite which only supports SQLite version 2
> (version 3 is supported only through pecl::pdo_sqlite).
>
> Is it possible to have literal % and _
Hi Craig, I have looked into the dictionary that you suggested, but wouldn't
this be the same as the array as I would still need to know how many times
to go through the while loop to add the names of the fields? Also I need to
get the names of the fields back out to populate a comboBox, which I
Hi Martin, I'm not sure, I don't use VB that often, I just need to use it
for my Uni project at the moment. I just know this was worked when I need
to create an array of all tables in the database, I just did a select count
statement on the master table and added that number to the size of the
On 7/13/06, John Newby <[EMAIL PROTECTED]> wrote:
Hi Nuno, I'm using VB.Net 2002 so I don't think I can use these commands.
And what about doing a "SELECT * FROM your_table_name LIMIT 0" ?
Does your sqlite wrapper returns the column names?
If it doesn't, maybe you should think in using
I tried with the last version but I still have the same problems.
I'm not sure that the appropriated version of sqlite API is used in my
application, because I have the following message when I run sudo make install :
PATH="$PATH:/sbin" ldconfig -n /usr/local/lib
Am 13.07.2006 um 14:31 schrieb Robert Wallner:
Hi all,
I have a software packages managing system that uses an sqlite
database. It's written in python using pysqlite2 as the wrapper. The
installed version of sqlite is 3.2.7.
After upgrading sqlite to the 3.3.x series, every operation against
Hi,
I am working on integrating pattern character escaping into PEAR::MDB2.
I am using PHP's ext/sqlite which only supports SQLite version 2
(version 3 is supported only through pecl::pdo_sqlite).
Is it possible to have literal % and _ in LIKE expressions in version 2?
Since when is ESCAPE
Am 13.07.2006 um 14:10 schrieb Christian Smith:
Inline.
ditto
Jens Miltner uttered:
Hi all,
I need to create a temporary table holding ID column values from a
number of tables, so that I have a unique way to access the data
for display purposes: say I have 2 related tables
[snip
John Newby wrote:
Yeah I can get the names, but I need to put them in an array, and to put
them in an array I need to know the size of the array to store them in,
so I
need to get a count first, then store this number as the size of the array
before I store the values into the array.
Are you
Yeah I can get the names, but I need to put them in an array, and to put
them in an array I need to know the size of the array to store them in, so I
need to get a count first, then store this number as the size of the array
before I store the values into the array.
Many thanks
John
On
Hi all,
I have a software packages managing system that uses an sqlite
database. It's written in python using pysqlite2 as the wrapper. The
installed version of sqlite is 3.2.7.
After upgrading sqlite to the 3.3.x series, every operation against
the database file eats all memory, untill being
Hi Nuno, I'm using VB.Net 2002 so I don't think I can use these commands.
Many thanks
John
On 12/07/06, Nuno Lucas <[EMAIL PROTECTED]> wrote:
On 7/12/06, John Newby <[EMAIL PROTECTED]> wrote:
> Hi, how can I find out the names of the fields within a given table?
>
> I've tried "pragma
Hi Kees, I'm writing it in VB.Net 2002.
I think I've got somethign nearly working now, but I need to somehow get a
count of how many fields is in the table, or how many rows the pragma
command brings back so that I can give the array a number before I can fill
it. Does anyone know the name of
Inline.
Jens Miltner uttered:
Hi all,
I need to create a temporary table holding ID column values from a number of
tables, so that I have a unique way to access the data for display purposes:
say I have 2 related tables
[snip schema]
When displaying a filtered subset of the persons with
"zze-ContentLab MARTINEAU Y ext RD-SIRP-REN" <[EMAIL PROTECTED]> wrote:
> Here is what I have been told regarding the application:
>
> "A newer version of sqlite3-dev ( > 3.2.1) would not work. This problem =
> is due to SQL requests threading. Newer versions force user to open a =
> new
Here is what I have been told regarding the application:
"A newer version of sqlite3-dev ( > 3.2.1) would not work. This problem is due
to SQL requests threading. Newer versions force user to open a new connection
for each Thread. We did not take the time to adapt our code."
That's true, it
"zze-ContentLab MARTINEAU Y ext RD-SIRP-REN" <[EMAIL PROTECTED]> wrote:
>
> I have to use sqlite 3.2.1 with an application (newer version of thread
> usage is not supported in the code).
Huh? What changed with the way SQLite uses threads?
--
D. Richard Hipp <[EMAIL PROTECTED]>
Hello,
I have to use sqlite 3.2.1 with an application (newer version of thread
usage is not supported in the code). I would like to use it on an ubuntu
6.06 server distribution of linux.
I must enable threads usage, so I added the --enable-threads to the
configure script.
This script gives a
No, I'm no sure. How can I test it? I've just started to learn C/C++ and
I have no idea how to do it.
Thanks again.
Pedro.
Will Leshner escribió:
On 7/12/06, Pedro J. Vivancos <[EMAIL PROTECTED]> wrote:
I'm developing a program using C++ and SQLite3 as database. I have a
problem with
See http://www.hwaci.com/sw/lemon/index.html
"Both the source code to lemon itself and the code that lemon generates are
in the public domain."
Ran
On 7/13/06, Arnav Kumar <[EMAIL PROTECTED]> wrote:
Hi,
I am currently exploring use of lemon parser generator for use in a
project.
I wanted to
Hi,
I am currently exploring use of lemon parser generator for use in a project.
I wanted to know if there are any licensing restrictions on the code
generated by the parser for e.g. whether the generated code itself has to be
under GPL or can be used in closed/proprietary programs without any
61 matches
Mail list logo