Andrew Douglas Pitonyak wrote:
Dale Erwin wrote:
Here's an idea:
For each database, HSQLDB creates four files (I'm not sure
just where they will be located for OOo databases and if it's
a Windows system I'm not sure how you look at the extensions).
The files are named:
<DataBaseName>.backup
<DataBaseName>.data
<DataBaseName>.properties
<DataBaseName>.script
Wow Dale, you really do know your HSQLDB..... Perhaps I have a few
questions for you that I can not answer :-( Can't seem to figure out how
to embed an image, but that should be asked in a different post...
That said, there are no other files. Everything is embedded into the new
Base file format. The file ends with .odb I think. To find these files,
I did the following on my Linux computer:
[EMAIL PROTECTED] tmp]$ mv BadRel.odb bad.zip
[EMAIL PROTECTED] tmp]$ unzip bad.zip
Archive: bad.zip
extracting: mimetype
extracting: content.xml
inflating: database/script
inflating: database/backup
inflating: database/properties
inflating: database/data
creating: forms/Obj11/Configurations2/
creating: forms/Obj11/Pictures/
inflating: forms/Obj11/content.xml
inflating: forms/Obj11/styles.xml
inflating: forms/Obj11/settings.xml
extracting: settings.xml
inflating: META-INF/manifest.xml
[EMAIL PROTECTED] tmp]$
Dale, you win a prize I think... You can find these files under the
database directory inside of the OOo Base .odb file.
I've never actually used the OOo Base module, so I wasn't aware
of this structure. Seems like it just might be a little too
insulated from the user to be able to edit it like I suggested.
Also, I don't know much about Linux (read: absolutely nothing).
Is what you have done equivalent to a rename of the file?
Or is it more like a copy of the file?
OOo2.0beta is not available for my operating system (eCS/OS2),
so I guess I'm going to have to boot WinSux and play around
with Base.
When you say "imbed an image" do you mean store an image file
such as .jpg or .gif in a hsqldb database? I've never done
this, but I guess the column type would have to be "OTHER"
which is the same as "OBJECT." If I were doing this in Java,
I would create an Image() object of the file and store the
object, but I guess that can't be done with OOo Base, and I
don't know if the actual image file can be stored directly
or not. Like I said, I've got to go play around with this.
It's something I need to do anyway, because I want to create
a database to store audio files (.mp3 & .mp2).
--
Dale Erwin
Salamanca 116
Pueblo Libre
Lima 21 PERU
Tel. +51(1)461-3084
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
