ajay bonde wrote:
I am new user of base application. Previously i was using MS Access as data
base. In that totalling or multiplication of columns etc was done by writing
SQL from the ready made window provided by MS Access. I am using
Openoffice.base on Linux platform. I have no knowledge of writing SQL query.
Please guide me whether openoffice.base has any readymade window for writing
SQL?
You can create queries in one of three modes: using the designer, using
the wizard, or via SQL
You may modify queries using the designer or in SQL mode
Once in the Designer or the SQL mode, you may switch back and forth
between these modes at will. If you wish, you can create a simple query
with the designer or wizard, then add calculated fields by opening the
query in SQL mode. It will show you something like this:
SELECT "field-name", "field-name", "field-name" FROM "table-name"
"table-alias";
Each field-name may optionally be followed by AS "alias-name".
This leads to how to do calculated columns. Suppose you have a table
named Stock with columns named SKU, Desc, QtyOnHand, and Price. You can
calculate the value of the quantity on hand by making your SELECT
statement read as follows:
SELECT "SKU", "ItemDesc", "QtyOnHand", "Price", "QtyOnHand" * "Price" AS
"ValueOnHand" FROM "Stock" "Stock";
You can get as complex as you need be in your calculated columns, even
using constants and parentheses and built-in functions, like ROUND(),
INT(), and so on.
You may also add a clause to the statement to order it by any particular
column, e.g.,
SELECT "SKU", "ItemDesc", "QtyOnHand", "Price", "QtyOnHand" * "Price" AS
"ValueOnHand" FROM "Stock" "Stock" ORDER BY "ValueOnHand" DESC;
You can do the same type of thing on reports, BTW.
Hope this little tutorial was helpful.
Matt Needles
Please guide me the name of book and publisher in India which deale with
openofffice.base only. or whether online help is available on any site.
with regards from
Ajay Bonde
[EMAIL PROTECTED]
---------------------------------
Find out what India is talking about on - Yahoo! Answers India
Send FREE SMS to your friend's mobile from Yahoo! Messenger Version 8. Get it NOW
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
