Hi,
I don't know if I can help you with your problem, but I'm interested in what
you are trying to do, are u using uCos on a Z-World based system?
Kind regards,
Lodewijk Duymaer van Twist
Yes I am using a :memory: database created from 3 flash database that were
previously attached to it.
I am not quite sure of the amount of work that would be required for me to
port it to linux. I will try later today to build it under cygwin and see
if the same behavior occurs.
Regards,
Mar
[EMAIL PROTECTED] wrote:
>
> Anyone has an idea of what may be wrong ? Oh yeah, I am running of my own
> port using uCos and a memory database.
>
You say you are using a ":memory:" database and this
is happening?
Can you provide a test program running under Linux?
--
D. Richard Hipp <[EMAIL
I have created a database, this table has multiple tables. The tables are
accessed through APIs.
I have a particular problem with one of my table. I have written a few
APIs for it. One API is used to Set (add or update) a record to it, one is
used to retrieve the actual records in the table, o
Eric Bohlman <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
> > http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
> > http://www.sqlite.org/lang_expr.html#corefunctions
> >
> > I will admit that the SQLite website is not particularly
> > well indexed for human browsing. But you can
On Tue, 20 Jun 2006 15:34:21 +0200, Ralf Junker wrote:
>SQLiteSpy 1.5.4 is released. Changes include:
>* Updated to SQLite3 3.3.6.
>* The schema tree view did not automatically reflect if a table was emptied or
>initial records were being added.
>* The default text encoding for newly generat
[EMAIL PROTECTED] wrote:
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
http://www.sqlite.org/lang_expr.html#corefunctions
I will admit that the SQLite website is not particularly
well indexed for human browsing. But you can always find
things easily enough using google. Search exam
Mikey C <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I just wanted to ask for confirmation that my understanding on how the query
> optimiser works is correct.
>
> SQLite only uses one index for each table in a FROM?
SQLite uses *at most* one index for each table in the FROM clause.
Some tables in the F
At 14:25 20/06/2006, Mikey C wrote:
Hi,
I just wanted to ask for confirmation that my understanding on how the query
optimiser works is correct.
SQLite only uses one index for each table in a FROM?
Yes
What if tables are joined? Does an index get used for each joined table?
No, just one
Manzoor Ilahi Tamimy wrote:
Here Is The Schema For these Tables.
CREATE TABLE HVH (
Field1 VARCHAR(8), IDC VARCHAR(4),
Field3 VARCHAR(2), Field4 VARCHAR(4),
Field5 VARCHAR(7), Field6 VARCHAR(8),
Field7 VARCHAR(1), Field8 FLOAT);
CREATE TABLE ITM(
IDC VARCHAR(4),ITEMNAME VARCHAR(2
I've been using SQLite from Delphi. I found it easiest to use the native
API, and put my own wrappers around it when necessary. In general I've
kept it pretty simple, because I'm using SQLite as an intermediate
database to manage data conversions. For the main data store of an
application you'll
SQLiteSpy 1.5.4 is released. Changes include:
* Updated to SQLite3 3.3.6.
* The schema tree view did not automatically reflect if a table was emptied or
initial records were being added.
* The default text encoding for newly generated database files is now UTF-8.
* Fixed a nasty bug which c
Different tasks require different approaches. Therefore DISQLite3 offers three
levels of abstraction to Delphi developers:
1. The full SQLite3 API, all contained in a single Delphi unit. Best suited to
all who like direct access to the SQLite3 interface or want to write their own,
app-specific
At 03:30 20/06/2006, you wrote:
Here Is The Schema For these Tables.
CREATE TABLE HVH (
Field1 VARCHAR(8), IDC VARCHAR(4),
Field3 VARCHAR(2), Field4 VARCHAR(4),
Field5 VARCHAR(7), Field6 VARCHAR(8),
Field7 VARCHAR(1), Field8 FLOAT);
CREATE TABLE ITM(
IDC VARCHAR(4),
Hi,
I just wanted to ask for confirmation that my understanding on how the query
optimiser works is correct.
SQLite only uses one index for each table in a FROM?
What if tables are joined? Does an index get used for each joined table?
So if I have
SELECT *
FROM A
INNER JOIN B
ON A.COL1 = B
"Manzoor Ilahi Tamimy" <[EMAIL PROTECTED]> writes:
> Here Is The Schema For these Tables.
>
> CREATE TABLE HVH (
> Field1 VARCHAR(8),IDC VARCHAR(4),
> Field3 VARCHAR(2),Field4 VARCHAR(4),
> Field5 VARCHAR(7),Field6 VARCHAR(8),
> Field7 VARCHAR(1),Field8 FLOAT);
>
> CREATE TABL
> A lot of the time using the vanilla API keeps you from coding in the
> style most suited for a modern lang, which may only help introduce
> bugs which the dev isn't used to worrying about. I don't think it's
> right to recommend using it when there are wrappers tailored to keep
> the dev thinkin
"Cory Nelson" <[EMAIL PROTECTED]> wrote:
> > >
> > > I would certainly suggest to not
> > > use any library and use directly the sqlite procs.
> > >
> > I would endorse that approach. The Sqlite API is simple and easy to
> > use, so why not take advantage of that and KISS (Keep It Simple Senor)?
On 6/20/06, John Stanton <[EMAIL PROTECTED]> wrote:
Costas Stergiou wrote:
>>Hello,
>>
>>I need a server-less SQL engine. Unless someone recommends a better tool
>>(embedded FireBird? Something else?), I'm thinking of using SQLite.
>>
>>Problem is, several wrappers are listed in the SQLite wiki.
Costas Stergiou wrote:
Hello,
I need a server-less SQL engine. Unless someone recommends a better tool
(embedded FireBird? Something else?), I'm thinking of using SQLite.
Problem is, several wrappers are listed in the SQLite wiki. Can you
recommend one, ideally under active development, easy to
20 matches
Mail list logo
