Re: Template tables source

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.
>
> Zoltan
>> - oj
>>
>>> Zoltan
>>>>
>>>> - oj
>>>>> Regards,
>>>>> Zoltan


-- 
Ocke Janssen                      Tel: +49 40 23646 661, x66661
Dipl. Inf(FH)                     Fax: +49 40 23646 550
Sun Microsystems Inc.
Nagelsweg 55                      mailto:[email protected]
D-20097 Hamburg                   http://www.sun.com/staroffice

Sitz der Gesellschaft:
Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB 161028
Geschaeftsfuehrer: Thomas Schr?der, Wolfgang Engels, Wolf Frenkel
Vorsitzender des Aufsichtsrates: Martin Haering