Hello Marc, Frank, *,
happy new year! (late but...)
Marc Santhoff escribió:
Hi Frank,
Am Freitag, den 04.01.2008, 21:32 +0100 schrieb Frank Schönheit - Sun
Microsystems Germany:
Hi Marc,
Sub Main
Dim oDestDesc as Object
oDestDesc = createDataAccessDescriptor()
oDestDesc.DataSourceName = "Spielwiese"
' oSourceDesc.ConnectionResource =
"sdbc:dbase:file://g:/office/dba24d/user/database/biblio"
oDestDesc.CommandType = com.sun.star.sdb.CommandType.TABLE
oDestDesc.Command = "Masse"
Dim oSourceDesc as Object
oSourceDesc = createDataAccessDescriptor()
oSourceDesc.DatabaseLocation =
"file:///e:/Daten/Dokumente/OOo_DB/Massendaten/datagen7.txt"
DatabaseLocation has to be the URL of an .odb file. If you want to
specify the text file as source, use ConnectionResource and "sdbc:file:...".
That was a good laugh, when I saw the "biblio"-thingy right before my
eyes after you mentioned it. :D
But after all I'couldn't make it run that easy:
...
Dim oSourceDesc as Object
oSourceDesc = createDataAccessDescriptor()
oSourceDesc.ConnectionResource =
"sdbc:file:file:///e:/Daten/Dokumente/OOo_DB/Massendaten/"'datagen7.csv"
oSourceDesc.CommandType = com.sun.star.sdb.CommandType.TABLE
'oSourceDesc.Command = "datagen7"
oSourceDesc.Command = "datagen7.csv"
...
I tried that way iterating over some variants and got an
uno.RuntimeException saying:
"invalid attempt to assign an empty interface of type
css.sdbc.XConnection!"
Still something missing?
o yeah.... a lot!
read my mail "UNOized Copy Table Wizard: FLAT SOURCE" from 2007-12-03
http://dba.openoffice.org/servlets/ReadMsg?list=dev&msgNo=3155
and browse the thread.
IIRC Frank "promised" to wrap everything in a new property in the
DataAccessDescriptor so that there won't be any need for a client to
provide a connection.
I tried to find his answer but that week I wrote a lot and ATM I do not
have much time to search every message: as this week we had here 41ºC,
I'm combining the swimming pool in my backyard with intensive C++ UNO
language binding learning
Side comments: idiot me I thought I knew C++, it turned out that I knew
Standard C++, but now I had to learn the whole C++ UNO ref., and read
again the Dev's Guide 2-4.
First impression: when turning from OOo Basic to Java I asked myself
what the f*ck all that queryInterface(), now I asked myself what the f*
all the OUString::createFromAscii("AnyName") every time I want to use a
string. But things are not that bad: at least for me, getting an
interface reference is much simpler in C++ with the template class
Reference<T> than Java, and the Any thing is simpler implemented with
the overloaded operators.
To Frank, just for curiosity: what C++ IDE do you use? I have to admit
that I ended using the MS Visual C++ Express, sorry me free-soft.
lover's/Emacs funs/ etc.
Regards
Ariel.
--
Ariel Constenla-Haile
La Plata, Argentina
[EMAIL PROTECTED]
[EMAIL PROTECTED]
http://www.ArielConstenlaHaile.com.ar/ooo/
"Aus der Kriegsschule des Lebens
- Was mich nicht umbringt,
macht mich härter."
Nietzsche Götzendämmerung, Sprüche und Pfeile, 8.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
