John Jason Jordan wrote:
On Mon, 11 Feb 2008 09:40:31 -0800
I'll keep poking at things. Thanks for the suggestions. I'm slowly
making progress.
I'll put up an example of using the current files to connect to Kexi ,
under Kubuntu - today, if it would help.
I chose to leave the data n the Kexi ( SQLite ) format and attached Base
to this - it is rather nice actually. If you really wanted to you should
be able to simple drag and drop the tables from the attached Base file
to a Base native database file and not have any of the data loss problems.
Base is rather agnostic when it comes to data sources, so for example I
was able to create queries using Base that use all of the SQLite
conventions direclty - Base asks the back end what is allowed and what
not in other words - Which should mean, although I did not fully tested
this yet - that I can then move the queries back and forth between the
two by transferring the SQL generated from either. A simple copy paste
in other words.
Truth is the last time I used Kexi was with their first Windows release
- I was not impressed - but yesterday I was quite happy with it under
Gutsy...quite. Although I still prefer the SDI paradigm of Base over MDI
used by Kexi, but that is personal preference. As for SQLite - it is
fast that is for sure and with Base connected to the Kexi datastore
using ODBC I could not discern any loss in performance - I am using the
MS northwind dataset for testing but will be using a Baseball statistics
data set for testing later...things sometimes change when the record
sets start hitting 150,000 versus 2,000.
What I did get a chance to do was use the Report Builder extension
against the Kexi database via Base and that went quite well - setting a
basic invoice took only a few minutes and no surprises...nice.
Anyway let me know if you want that example today - other wise I will
not be working on it till this weekend - but I can carve out an hour or
so later.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
