|

»

openoffice - projects

»

openoffice - database access

»

openoffice - dba users

Template tables source

View: New views

8 Messages — Rating Filter: Alert me

	Template tables source by Reizinger Zoltán :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 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. Regards, Zoltan --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@...
	Re: Template tables source by Drew Jensen :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 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 > > OK Drew --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@...
	Re: Template tables source by Ocke Janssen :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 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. :-) - oj > Regards, > Zoltan > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscribe@... > For additional commands, e-mail: users-help@... > -- Ocke Janssen Tel: +49 40 23646 661, x66661 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:Ocke.Janssen@... 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 --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@...
	Re: Template tables source by Reizinger Zoltán :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 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? Zoltan > > - oj >> Regards, >> Zoltan >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscribe@... >> For additional commands, e-mail: users-help@... >> > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@...
	Re: Template tables source by Ocke Janssen :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 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 - oj > Zoltan >> >> - oj >>> Regards, >>> Zoltan >>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: users-unsubscribe@... >>> For additional commands, e-mail: users-help@... >>> >> >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscribe@... > For additional commands, e-mail: users-help@... > -- Ocke Janssen Tel: +49 40 23646 661, x66661 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:Ocke.Janssen@... 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 --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@...
	Re: Template tables source by Reizinger Zoltán :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 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> Zoltan > - oj > >> Zoltan >>> >>> - oj >>>> Regards, >>>> Zoltan >>>> >>>> --------------------------------------------------------------------- >>>> To unsubscribe, e-mail: users-unsubscribe@... >>>> For additional commands, e-mail: users-help@... >>>> >>> >>> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscribe@... >> For additional commands, e-mail: users-help@... >> > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@...
	Re: Template tables source by Ocke Janssen :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 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:Ocke.Janssen@... 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 --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@...
	Re: Template tables source by Reizinger Zoltán :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 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: users-unsubscribe@... For additional commands, e-mail: users-help@...