Hello Hans,

thanks for moving your question to this list here. I probably should
have made more explicit that English is spoken here :). So you said it's
spoken on your side, too, let me answer in English.

(And sorry for the delay in response, had some other pressing things on
the list ...)

For other readers: Hans asks for a problem with the CSV file he quoted,
which is imported improperly in Base.

> Unter SO8Upd5/OOorg2 erhält man bei der Verwendung der nachfolgenden
> CSV-/TXT-Datei folgende Ergebnisse:
> 1) Null-Werte für die Tabellen-Spalte GESCHLECHT;
> 2) beliebige numerische Werte für die Spalte ABTNR;
> 3) der Rest ist korrekt;

Normally I would say something like "could reproduce, do you mind
submitting an issue?". But given that my unresponsiveness already
delayed this, I submitted the issue myself this time:
http://www.openoffice.org/issues/show_bug.cgi?id=76645

> Weiteres Probleme mit SO8-/OO-Base sind:
> a) bei Entwurfsabfragen ist die Verwendung von Funktionen überhaupt nicht
> möglich.

Not sure what you mean with "Entwurfsabfragen" (probably simply
"Abfragen" aka queries). If we're still talking about text/CSV here:
Yes, this is a limitation of the respective driver, which simply cannot
cope with functions (except COUNT). There's no plans currently to change
this.

If you desperately need better CSV support in Base, try using the CSV
capabilities of HSQLDB, the integrated database engine. See the HSQLDB
documentation at http://hsqldb.org/web/hsqlDocsFrame.html, in particular
the link "Text Tables", which (sparsely, admitted) explains the concept
of "text tables" in HSQL. Text tables effectively are CSV files, which
can be linked from within any HSQL database (in particular the ones
embedded in an .ODB), and can use the full power of the HSQLDB engine.

Ciao
Frank

-- 
- Frank Schönheit, Software Engineer         [EMAIL PROTECTED] -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

  • [dba-users] Re: CSV Hans Beerhalter
    • Re: [dba-users] Re: CSV Frank Schönheit - Sun Microsystems Germa ny

Reply via email to