Re: Template tables source

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