Ocke Janssen írta:

On 10/27/09 12:53, Reizinger Zoltán wrote:
Ocke Janssen írta:
On 10/27/09 07:33, Reizinger Zoltán wrote:
Moin Ocke,

Ocke Janssen írta:
Moin Zoltan,

On 10/26/09 10:53, Reizinger Zoltán wrote:
Hi,
I prepare for OOo Base Guide some source documents.
I found Standards Distributed Schema wiki page:
http://wiki.services.openoffice.org/wiki/Standard_Distributed_Schema

My question that how can I easily retrieve the tables definitions. I need fields, data types and sizes etc.
Create a new db and start the table wizard and create the table you are interested in. :-)
This way is known for me.  ;-)
I like to see all data in one text file, to pick up what me needs. It is possible?
Yes. Do you like xml?
http://svn.services.openoffice.org/opengrok/xref/Current%20(trunk)/officecfg/registry/data/org/openoffice/Office/TableWizard.xcu

Not so much, can live with it.
One question only, where can I find Type value decipher.
For example, what data type value 4 meas, my guess is integer, because it is an ID field :

    64                             <prop oor:name="Type">
    65                                 <value>4</value>
    66                             </prop>
Yes, you are right. Please have a look at http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/DataType.html
- oj

PS: By the way. Another way to create a list of all tables for hsqldb could be to create all tables with the wizard and after that just copy the script file.
This is the best solution. I did it with hsqldb19 version yesterday, when checked it.
I think this part not changed when csw hsqldb19 was created.

Zoltan

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to