[libreoffice-users] Re: Base record access unacceptably slow

Am 30.07.2011 23:07, Jean-Francois Nifenecker wrote:
> Le 29/07/2011 10:41, Andreas Säger a écrit :
> > As a matter of fact you can disable/remove Java, hit F4 ... connect,
> > query, edit and dump.
> > If I would convert our Java databases and remove Java from our systems
> > nobody would notice the change.
>
> Could you elaborate, please?
>
> If I remove Java, can I open the Base module and create a query in
> design mode? I happen to think I can't but I might be mistaken.

Stop thinking. Start trying. It takes 15 seconds.

1) There is a completely useless query wizard. This is the only query 
generator depending on Java.

2) There is an almost useless query designer which supports baby SQL 
only. You can learn that level of SQL for all databases within a day and 
use 3 with more features and less errors:
3) The SQL editor knows 2 modes:
3a) The "parsed mode" which works well in most cases and which may be 
viewed in the design view (which may destroy your valid SQL then).
3b) Direct SQL which always works properly when handled by a mature 
RDBMS such as HSQLDB. Unfortunately, Base makes these row sets read-only 
and parameter queries don't work.


--
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