OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Some Roadmap items for Base

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
DrewJensen
Super User
Super User


Joined: 06 Jul 2005
Posts: 2616
Location: Cumberland, MD

PostPosted: Tue Nov 06, 2007 10:13 pm    Post subject: Some Roadmap items for Base Reply with quote

HI,

Thought I would pass along a few of the things coming down the road for the Base Module, per the developer group announcements.

Version 2.4
GUI changes
Form data input checks for required fields
query designer also available for "native" SQL commands
query designer now also available for list box content
views in HSQLDB database can be edited


API changes
(Added in 2.3 )
Ability to enumerate sub frames in Base document. Query Window, Data View Window - Also allows then custom menu, toolbar items to be added to these sub-windows.


Version 2.4
Add getSelection for main Base window - allows to find which Table, Query, Form or Report item is currently selected in the respective lists.

Add API to launch the Copy Table Wizard - Allows script to start Copy Table Wizard and pass in Source, Target and Connnection objects. Offers call back listeners for, Record Ready to update, Record Updated and Error on Update - This API will allow creation of import / export extensions or custom import / export scripts.




Form data input checks for required fields
Quote:
For databases, there exists a per-database setting which controls
whether forms check for required fields when entering data.

That is, when the user enters a new record, or updates an existing
one, in a form, and leaves a field empty which is bound to a database
column which requires input, then the form runtime would normally
complain that this field needs input. This is the behaviour up to OOo
2.2, and the default in 2.3 unless some macro will be run manually.

Now, there exists a setting named "Form data input checks for required
fields", on the "Special Settings" tab page of the advanced database
properties ("Edit"/"Database"/"Advanced Settings". Yes, we need to
rework the names here.).

When this is checked (the default for all existing and newly created
databases), then the behaviour in forms will be as described above.

If it is not checked, then forms (all forms in this DB, that is) will
not check for required fields. As a consequence, the DB designer can
specify server-side default values for fields, which up to now was
hardly possible since there is not way Base can generically read
server-side default values, thus it always assumed there're none.

The setting is available in all data source types which (potentially)
support write access to their data, which means it does not exist for
Spreadhseet, Text/CSV, and the various read-only flavours of address
books.


query designer also available for "native" SQL commands

Quote:
>From within the property browser for a database form, you can open the
query designer, to graphically design the SQL command underlying the form.

With the integration of CWS dba24c, this is also possible when the
"Escape processing" property of the form is set to "No", which is
usually done when you enter a SQL command which is not understood by
Base's parser, but by the database engine.
In such a case, the designer is opened in SQL mode (as opposed to
graphical mode), where you can enter the mere SQL command somewhat
more conveniently than in the property browser. The "Run SQL command
directly" setting in the designer's toolbar will be ON then.

Adequately, changing the "Run SQL command directly" setting will be
reflected in the "Escape processing" property of the form whose
command is currently being designed.

Also, the same functionality is available for list boxes, whose list
content, in case of a list content type "SQL command (native)", can
also be edited in the query designer's SQL view.


query designer now also available for list box content
Quote:

With the integration of CWS dba24c, you will be able to invoke the
query designer not only for the "Content" property of a database form
(if it's content type is "SQL command"), but also for the list content
of a list box control (or grid column), if its list content type is "SQL".

The SQL command which you design in the query designer will, when
saving it, be set as the respective property at the list box.


views in HSQLDB database can be edited

Quote:
With the integration of CWS dba24c, you will be able to edit views in
embedded HSQL databases.

In the context menu of views (as well as in the Edit menu of the main
window, as usual), the entry "Edit" will be available, which opens the
same UI as used when creating a new view, or creating or editing
queries (vulgo: The Query Designer).

As a consequence, when you create a new view and save it, the query
designer will *not* automatically close itself after saving (which was
previously done since altering the view statement was not possible
anymore).

With this, views now behave more like queries than before.

One notable difference is that the UI information of the view design -
table window layout, column widths, and the like - are not preserved.
That is, after changing this UI layout, and saving and re-opening the
view design, the UI layout will be lost. This is due to the fact that
it cannot be stored (in opposite to the view's statement, naturally)
in the underlying database.

_________________
Blog - http://baseanswers.spaces.live.com/
Back to top
View user's profile Send private message Send e-mail Visit poster's website
mobi-doc
OOo Enthusiast
OOo Enthusiast


Joined: 30 Jan 2007
Posts: 130
Location: Thessaloniki

PostPosted: Wed Nov 07, 2007 12:09 am    Post subject: Reply with quote

Is there any way with OOo 2.3 to enumerate open form or report windows?
I can not find a UNO method to do this. Can you give an example?

Thank you.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group