Re: [sqlite] again on sqlite as a standard, was: SQLite and OOo

2004-07-25 Thread Yves Chaufour
Le dimanche 25 Juillet 2004 21:28, [EMAIL PROTECTED] a écrit : > > Let me explain, I guess I did no express myself clear. > > There is quit some SQL-generating software (like MDA*-software, but also all kind > of GUI's for databases, and these kind of GUI's can be everywhere in many kinds >

Re: [sqlite] again on sqlite as a standard, was: SQLite and OOo

2004-07-25 Thread [EMAIL PROTECTED]
> The code is Cocoa-based, but could easily be adapted to other > languages. I could build a GUI environment to alter a table and to > generate the SQL statements as well, I don't see what the problem is. > As I said earlier, the issue with the workaround is that it has to > copy the entire table

Re: [sqlite] again on sqlite as a standard, was: SQLite and OOo

2004-07-25 Thread [EMAIL PROTECTED]
> Bert Verhees wrote: > > > > The workaround for ALTER TABLE is not useable in SQL-code generating > > environments. > > Sorry for being dense, but can you elaborate on the above? Why can't > such code be generated? Let me explain, I guess I did no express myself clear. There is quit some

Re: [sqlite] again on sqlite as a standard, was: SQLite and OOo

2004-07-25 Thread Bert Verhees
> These newly added features were long requested as well, and although > ALTER TABLE is indeed an important feature too, there are probably > other issues that require more attention right now. > > In any case, there is an entry on the FAQ section that shows you how to > do something like

Re: [sqlite] again on sqlite as a standard, was: SQLite and OOo

2004-07-25 Thread Tito Ciuro
On 25 jul 2004, at 5:47, Yves Chaufour wrote: Why has it not been added for SQLite 3 ? It's perhaps the more wanted SQLite feature, and we can't understand why it isn't yet implemented. Perhaps because you haven't you seen the tremendous amount of work that has been put into version 3. The

Re: [sqlite] again on sqlite as a standard, was: SQLite and OOo

2004-07-25 Thread Yves Chaufour
Le samedi 24 Juillet 2004 23:29, D. Richard Hipp a écrit : > M. Fioretti wrote: > > > >>The main drawback of SQLite is that it doesn't support ALTER > >>TABLE. It's a big limitation for simple users when building a > >>database. If this fonctionnality (and a few others) could be add in > >>a near

Re: [sqlite] again on sqlite as a standard, was: SQLite and OOo

2004-07-24 Thread koneill
I was wondering if internal functions saving to and from an XML data file (an XML file dumper?) might be sufficient to export/import from SQLite standard datafile (I mean without having all the data in the same file, but having multiple files); in any case, export/import functions might be part of

Re: [sqlite] again on sqlite as a standard, was: SQLite and OOo

2004-07-24 Thread M. Fioretti
On Sat, Jul 24, 2004 17:29:22 PM -0400, D. Richard Hipp ([EMAIL PROTECTED]) wrote: > ALTER TABLE will probably start appearing (in stages) over the > next several months. Duly noted, thanks. > Storing an SQLite database as part of a larger file is problematic. Well, even today, an OASIS

Re: [sqlite] again on sqlite as a standard, was: SQLite and OOo

2004-07-24 Thread D. Richard Hipp
M. Fioretti wrote: The main drawback of SQLite is that it doesn't support ALTER TABLE. It's a big limitation for simple users when building a database. If this fonctionnality (and a few others) could be add in a near future, SQLite would probably become the first choice for OOo. ALTER TABLE will