On Thu, 2009-08-13 at 23:39 -0400, Igor Tandetnik wrote:
> Kermit Mei wrote:
> > The mostly useful SQL sentence is (MyDevId is known by user):
> >
> > SELECT * FROM KeyItem WHERE HomeDevId=MyDevId order by pageNum;
> >
> > Now, the items of this table may be more than 100,000 lines. If I use
> > th
Kermit Mei wrote:
> The mostly useful SQL sentence is (MyDevId is known by user):
>
> SELECT * FROM KeyItem WHERE HomeDevId=MyDevId order by pageNum;
>
> Now, the items of this table may be more than 100,000 lines. If I use
> the following Index, can it improve the previous query's speed?
>
> CREAT
Hello, I have I table like this:
CREATE TABLE KeyItem (icon_y int, icon_x int, id INTEGER PRIMARY KEY,
pos_x int, pos_y int, size_x int, size_y int, type int, text
varchar(15), icon varchar(50), background varchar(50), HomeDevId int,
pageNum int);
The mostly useful SQL sentence is (MyDevId is kno
2009/8/13 Simon Slavin :
>
> On 13 Aug 2009, at 12:47pm, Otto Grunewald wrote:
>
>> on the website at the following address:
>>
>> http://www.sqlite.org/c3ref/exec.html
>>
>> The second paragraph states the following:
>>
>> The error message passed back through the 5th parameter is held in
>> memor
On Thu, 13 Aug 2009, Mike Frysinger wrote:
> On Thursday 13 August 2009 12:25:39 Hugh Sasse wrote:
> > Well, I've found out why the tests aren't included in the amalgamated
> > version. I think it is because it has taken over 5 hours to run the full
> > test suite on the Solaris9 box I have, and
Our approach in the 1980s was to make the compiler.
Interestingly you mention a Databus to C product wich did not flourish
(as one would expect for a translator).. We produced a complete Databus
compiler to a target code like Java. This product sold well and is
still viable thanks to the larg
I think you are talking "Open Source" world now. In the late 80's, early
90's things like Open Source Databas/Datashare compilers weren't even in
anyone's dreams. What you saw was what you got. With no open source
compilers to monkey with you just did what you had to, pretty or not.
Somebody di
In this situation it has been our approach to never try to translate
source in one language into another. It is a pointlesss activity when
you think about it. Much better to have the C or whatever compiler have
a different code generator, for example Java target code.
You are not rev locked
On 13 Aug 2009, at 12:47pm, Otto Grunewald wrote:
> on the website at the following address:
>
> http://www.sqlite.org/c3ref/exec.html
>
> The second paragraph states the following:
>
> The error message passed back through the 5th parameter is held in
> memory obtained from sqlite3_malloc(). To
Well, I've found out why the tests aren't included in the amalgamated version.
I think it is because it has taken over 5 hours to run the full test suite
on the Solaris9 box I have, and they are not finished yet. I've not noticed
any failures yet though; hopefully I can give a report tomorrow.
That's all you are suppose to get when querying the Master table for table
names.
You ask how to get a list of tables. That is what you got.
What you are asking for now is more complex.
Try:
Select Name, SQL from "SQLite_master";
for even more fun try:
Select * from "SQLite_master"
Fred
--
I have tested an archive under a multithread (32) application. Every thread
appends a new record in a unique table. After the thread updates only own
records. On exit the thread verifies that all own records are be updated but
somethimes some records are not be updated correctly.
The insert an
Otto Grunewald wrote:
> When an error message is returned by sqlite3_exec the documentation
> states that you have to call sqlite3_free (sqlite3_free(void*)).
>
> My question is the following:
>
> Where do I get the void pointer from?
You do sqlite3_free(errmsg), of course.
Igor Tandetnik
Hello,
It is on the website at the following address:
http://www.sqlite.org/c3ref/exec.html
The second paragraph states the following:
The error message passed back through the 5th parameter is held in
memory obtained from sqlite3_malloc(). To avoid a memory leak, the
calling application should
On Aug 13, 2009, at 7:27 AM, Otto Grunewald wrote:
>
> When an error message is returned by sqlite3_exec the documentation
> states that you have to call sqlite3_free (sqlite3_free(void*)).
>
That sounds like a bug in the documentation. Where are you seeing
this, exactly. I can't find it any
Hello,
I apologize for posting the message on the development mailing list.
Yes, it was a mistake in transcribing the code : the line actually looks
like this:
sqlite3_open("/var/ptudata/ptu.db", &db_handle);
I think I found the problem though.
If you have a look at the while loop it was coded
Hello,
I would like to pass cookies back and forth between a search script I have
written that runs on the local system, and javascript pages displaying the
forms and results in Firefox. I'll forego all the gory details here, it is
working pretty well, but being able to pass cookies back and for
On Aug 13, 2009, at 5:30 AM, Otto Grunewald wrote:
> Hello,
> The following is what my code looks like :
> sqlite3 *db_handle;
> char* errmsg;
> char cStr(255);
>
> sqlite3_open(&db_handle);
>
sqlite3_open() takes two parameters. Did you make a mistake in
transcribing your code?
D. Richar
On Thu, 13 Aug 2009, Dan Kennedy wrote:
> On Aug 13, 2009, at 4:58 PM, Hugh Sasse wrote:
>
> > Thanks. I think even if they don't change this, and they clearly
> > have reasons for how things are, then clarity about maintenance
> > would be useful.
>
> It works at present. It is tested inform
On Aug 13, 2009, at 4:58 PM, Hugh Sasse wrote:
> On Thu, 13 Aug 2009, Mike Frysinger wrote:
>
>> On Thursday 13 August 2009 05:04:26 Hugh Sasse wrote:
>>> On Wed, 12 Aug 2009, Mike Frysinger wrote:
On Monday 10 August 2009 11:51:40 Hugh Sasse wrote:
> Make check doesn't do anything. My r
On Thu, 13 Aug 2009, Mike Frysinger wrote:
> On Thursday 13 August 2009 05:04:26 Hugh Sasse wrote:
> > On Wed, 12 Aug 2009, Mike Frysinger wrote:
> > > On Monday 10 August 2009 11:51:40 Hugh Sasse wrote:
> > > > Make check doesn't do anything. My reading of Makefile{,.in,.am}
> > > > suggests this
Hello,
The following is what my code looks like :
sqlite3 *db_handle;
char* errmsg;
char cStr(255);
sqlite3_open(&db_handle);
while (sqlite3_exec(db_handle, cStr, NULL, 0, &errmsg) != SQLITE_OK)
{
printf("sqlite3_exec: %s - retry cnt: %i\n", sqlite3_errmsg(db_handle),
++cnt
Hi,
As of today, we are still enjoying our Informatica tool but in a few months
we will need to change. Basically we do not use our software at its full
capacity and don't feel we need it anymore.
So we are trying to find a less expensive solution that would have the same
features (or almost...
On Wed, 12 Aug 2009, Mike Frysinger wrote:
> On Monday 10 August 2009 11:51:40 Hugh Sasse wrote:
> > On Mon, 10 Aug 2009, D. Richard Hipp wrote:
> > > SQLite version 3.6.17 is now available on the SQLite website:
> > [...]
> > > This is the first release of SQLite after 100% branch test co
En/na Simon Slavin ha escrit:
> We no longer have the heritage of ubiquitous high-level languages.
> Fortran, Pascal, Structured Basic, and everything like that have
> gone.
I don't know about the situation of fortran right now and I don't really
care about basic, but pascal is alive and ki
On Tue, 11 Aug 2009 11:35:16 +0100, Simon Slavin
wrote:
>SELECT sql FROM sqlite_master WHERE type='table'
Thanks Simon.
To get only the name of the tables instead of the SQL command that was
used to create them:
SELECT tbl_name FROM sqlite_master WHERE type="table"';
__
26 matches
Mail list logo