On Mon, 2005-09-05 at 08:43 +0200, Staffan Ek wrote: > Hi, > > I got the answer that I open office can't replace msaccess yet. > I cannot edit querys and so on with oo.base. >
Not sure what you mean. You certainly can edit queries. Perhaps the following excerpt from Help will give you the guidance you seek: "SQL Mode SQL stands for "Structured Query Language" and describes instructions for updating and administering relational databases. In OpenOffice.org you do not need any knowledge of SQL for most queries, since you do not have to enter the SQL code. If you create a query in the query design, OpenOffice.org automatically converts your instructions into the corresponding SQL syntax. If, with the help of the Switch Design View On/Off button, you change to the SQL view, you can see the SQL commands for a query that has been created previously. You can formulate your query directly in the SQL code. Note, however, that the special syntax is dependent upon the database system that you use. If you enter the SQL code manually, you can create SQL-specific queries that are not supported by the graphical interface in Query design. These queries must be executed in native SQL mode. By clicking the Run SQL command directly icon in the SQL view, you can formulate a query that is not processed by OpenOffice.org." -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
