Ok, I see.
Thanks for your response.
Taking into account the SQLite restriction (and the restriction over other
RDBMS as well), I was thinking in allowing something as a Compatibility
Mode, in which it should be defined a set of SQL statments, actions and
functions that can be emulated in various database motors.
One of this is allowing a "transparent alter table" by doing the trick that
you exposed.
I know that could create a non-standard standard, but it will allow the
developers to deploy faster.
It could even have a port helper which could port the SQL to the specific
database.
What do you think about this?
On Jan 8, 2008 8:26 AM, archimede <[EMAIL PROTECTED]> wrote:
> ciao a tutti (hi there)
>
> for abignone:
>
> why you try not to install knoda 8.3? is a bug fix release (so is
> wrinting in the news)
> perhaps is a bug solved: i never met this matter; me too i used knoda
> from four years
> further i works on linux debian (i came before suse 8.2 and after the
> accomodation suse-microsoft
> i migrate to other distro choosing debian discovering its works better
> and faster)
>
> for camilo
>
> alter table and outer join is not a knoda problem it depends from sqlite
> that don't
> include this two functions; you can see this on the sqlite site
> (www.sqlite.org) in the documentation and
> in the syntax sections.
> At the beginnings (me too i use sqlite) also for me it was a problem
> because i came from access
> were this problem does not exist. But now this problem for me not
> exixst: is a different way to construct
> your applications.
> Sometimes if i need to modify my tables i create a copy of them, i
> delete all records
> and i modify them; therefore i copy datas using sql instructions with
> query designer using QBE (this way is easier
> and faster the python scripts; the sqlite site sintax show to manipulate
> sql instructions).
> Another way is to export table on an another db created with knoda in
> Mysql modify the table and there
> reimport table in sqlite.
>
> best regards (sorry for my bad english!)
>
>
> Livio
> [EMAIL PROTECTED]
> Italy
>
>
>
>
--
Camilo Andrés Jiménez Cruz
Físico
Universidad Nacional de Colombia
Bogotá
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Hk-classes-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss
