/text/shared/guide/data_enter_sql.xhp Sun Microsystems, Inc. fpe: changed to match new database interface SQL; executing commands Executing SQL Commands UFI: test when it's working in a build With the help of SQL commands you can control the database directly, and can also create and edit tables and queries. Not all database types support all SQL instructions. If necessary, find out which SQL commands are supported by your database system. Choose File - Open to open the database file of the database for which you want to enter an SQL query. Select the desired database file, and then click the Queries icon. Click the Create Query in SQL View icon Icon or Select an existing query from the list and click the Edit icon Icon . In the Query window, enter the SQL command that you want to execute, or edit an existing command according to your requirements. Click the Run icon Icon . The result of the query is displayed in the upper window. Click the Save or Save As icon Icon to save the query.

Query Design