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,
[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
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
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
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
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
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
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
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 =
"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
> 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
"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
17 matches
Mail list logo