RE: OpenOffice Base Abfrage NATURAL JOIN

2021-11-09 Thread Jan-Christian Wienandt
Moin, ich gehe davon aus, dass Du die eingebettete Datenbank von OpenOffice nutzt. Dies ist HSQLDB Version 1.8. Version 1.8 unterstützt den SQL-Befehl natural join nicht. Eine Alternative ist folgender SQL-Befehl (Beispiel): Select * from tabelle1, tabelle2 where tabelle1.ID = tabelle2.ID; Es

Aw: Re: OpenOffice Base Abfrage NATURAL JOIN

2021-11-09 Thread gross_jule
Hallo Mechtilde, soweit ich weiß, verwende ich die Oracle Database. Und danke für die schnelle Antwort!     ___ Gesendet: Montag, 08. November 2021 um 20:06 Uhr Von: "Mechtilde" An: users-de@openoffice.apache.org Betreff: Re:

Re: OpenOffice Base Abfrage NATURAL JOIN

2021-11-08 Thread Mechtilde
Hallo, welches Datenbank-Management (DBMS) nutzt Du? Wahrscheinlich wird diese Syntax von dem verwendeten DBMS unterstützt. Viele Grüße Mechtilde Am 08.11.21 um 19:04 schrieb gross_j...@web.de: > Hallo :) > Leider konnte ich das Problem nicht selbst lösen, deshalb wende ich mich > jetzt an

Re: OpenOffice Base

2016-08-21 Thread Andrea Pescetti
On 19/08/2016 Richard Green wrote: Hi. I am interested in using OpenOffice’s Base product for database management. Will it work on a Mac with El Capitan (version 10.11.6)? It will, but OpenOffice 4.1.2 has a known bug affecting Java-based operations:

Re: OpenOffice Base - running time of a query

2016-05-09 Thread Rory O'Farrell
On Mon, 9 May 2016 16:37:28 +0200 Gábor Szepes wrote: > Dear Support, > > I would like to know how to set visible the running time of a query. > If I execute or perform a query I would like to see the amount of time that > needed for this (preferably in milliseconds). > Thank

Re: openoffice base

2015-10-30 Thread Günter Feierabend
Hallo Werner, Am 30.10.2015 um 13:35 schrieb Stooss : > Sehr geehrte Damen und Herren, > > ich habe in MAC OS X Yosemite eine Datenbank erstellt, wobei ich zuvor eine > Java-Datei geladen habe (hat das System automatisch für mich gemacht). > Jetzt habe ich MAC OS X EL

Re: OpenOffice Base Problems

2015-10-26 Thread Martin Groenescheij
On 25-Oct-15 03:27, Ian Gow wrote: Hi I’ve just spent the last 5 days putting constructing a database for my business accounts and persevered despite the many problems I’ve had with V4 on my iMac. The most common is the crashing without reason in various areas. I put up with this as I

Re: Openoffice Base

2015-04-04 Thread technik
Hallo, wenn es nur einmalig ist, kopiere die hälfte und dann die nächste Hälfte. Horst Am 30.03.2015 um 16:29 schrieb Adolf Dick web: Ich kopiere eine Tabelle aus Openoffice Base nach Openoffice Calc (wie in der Hilfe beschrieben). Das Problem: Von den ca. 4.500 Datensätzen werden nur ca.

Re: OpenOffice Base

2014-09-03 Thread Alexandro Colorado
I would recomend to use links so that the link field will go into the picture object. I will recomend to read the thread about it from our forums: https://forum.openoffice.org/en/forum/viewtopic.php?f=83t=44124 There are many good base builders and also some free to use models for verticals. On

Re: Openoffice-Base

2014-08-14 Thread NoOp
On 08/13/2014 07:44 AM, Dewald Barnard wrote: Good afternoon I need assistance in templates that will work for a small business. All I need is something to issue (make out delivery notes with automated delivery note numbers), receive stock, stock availability and automated stock reorders.

RE: Openoffice-Base

2014-08-13 Thread elderdanlewis
     Simply put,  you must first  create the database including its tables and fields. What you want in your template has to be created in a query.  Then use the query as the basis for a report.  Dan Original message From: Dewald Barnard dewaldath...@gmail.com

Re: Openoffice-Base

2014-08-13 Thread Martin Groenescheij
Base is nothing more than a front-end to a database, what you ask is an warehouse / inventory application. If you understand SQL and Base you can write your own application, but it can take much of your time. On 14-8-2014 0:44, Dewald Barnard wrote: Good afternoon I need assistance in

Re: OpenOffice Base

2014-03-15 Thread Wolfgang Keller
ONLY ONE answer. Start again but this time DO NOT use the embedded Database engine - use MySQL or equivalent!! It's the only thing to do and I can tell you the difference is amazing!! Abslutely NEVER, I repeat N-E-V-E-R use MySQL if you want your data to be safe. MySQL was made by people who

Re: OpenOffice Base 4.0 Ebauche de table

2014-01-31 Thread david96
: david96 [mailto:davi...@libertysurf.fr] Envoyé : vendredi 31 janvier 2014 15:02 À : users-fr@openoffice.apache.org Objet : Re: OpenOffice Base 4.0 Ebauche de table C'est en effet étonnant, j'ai moi même la version 4.0.1. Je ne rencontre pas de souci d'enregistrement. Je suis sous Debian wheezy (64

Re: OpenOffice Base

2013-08-01 Thread E.J.Minhorst
Guten Tag Namo! EXCEL nach OO geht in 2 Minuten - und zwar ohne ACCESS - nur mit Copy+Paste - einfach genial, oder? Schritt für Schritt: Starte OO und neue Datenbank = es öffnet sich der Datenbank-Assistent. Der 1. Punkt Datenbank auswählen bietet die Optionen Neue Datenbank erstellen und

Re: Openoffice Base Feature

2013-06-23 Thread Andrea Pescetti
On 05/06/2013 TCNS Customer Service - Gigi Baxter wrote: This information may only relate to Open Office Base software. ... Since version 2.4.0 when you click in the record search box, search for text box the contents of the field are not selected. With version 2.4.0 when you open the dialog