Re: [libreoffice-users] Re: Base List Tables Questions

Andreas,

Wow!  Where to start.  First, Base (part of LibreOffice 3.3) is
described as a database program, and that is what I want.

As for the db engine, I have no clue, and could care less.

As for the query -- why???  I'm trying to follow along with the Getting
Started with Base guide, but it has left out a step or two.  So I need
someone to fill in the missing information based on what I have, not
what you have.

Don't mean to be fussy, but I don't see how this helps me in any way,
and I don't fully understand it.  So I would appreciate it if someone
could explain how I make the links so I can creat a form and some
reports.

Thanks again,
Dave

On Thu, 25 Aug 2011 14:14 -0700, "Andreas Säger" <villeroy@t-online.de>
wrote:
> Base is NOT a database program. Assuming that you are writing about a
> HSQLDB
> of version 1.8 I suggest the following query to be run in direct SQL
> mode.
> Dump the results of that query into a report, spreadsheet or whatever
> type
> of office document.
> HSQLDB 1.8 is documented fully at http://hsqldb.org/doc/guide/
>
> #######################################
> SELECT
>    A.table_type,  -- TABLE or VIEW
>    A.hsqldb_type,   -- CACHED or TEXT
>    A.table_name,
>    B.column_name,
>    B.type_name,
>    B.column_size
>
> FROM information_schema.system_tables as A,
> information_schema.system_columns as B
> --  information_schema.system_indexinfo  is index information
>
> WHERE A.table_schem = 'PUBLIC'
>    AND A.table_name = B.table_name
>
> ORDER by A.TABLE_TYPE, A.table_name, B.ordinal_position
> ###############################
>
> This one lists all indices, foreign keys included:
> -- Index information from all tables in database
>
> SELECT
>    A.table_type, 
>    A.table_name,
>    B.index_name,
>    B.column_name,
>    B.ordinal_position,
>    B.asc_or_desc,
>    B.non_unique
>
> FROM information_schema.system_tables as A, 
> information_schema.system_indexinfo as B
>
> WHERE A.table_schem = 'PUBLIC'
>    AND A.table_name = B.table_name
>
> ORDER by A.table_type, A.table_name, B.index_name, B.ordinal_position
> ########################################################
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/Base-List-Tables-Questions-tp3285031p3285089.html
> Sent from the Users mailing list archive at Nabble.com.
>
> -- 
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
-- 
  dave boland
  dboland9@fastmail.fm

-- 
http://www.fastmail.fm - Accessible with your email software
                          or over the web


-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted