OpenOffice.org OpenOffice - 3.0 Guía de inicio rápido descargar pdf (Pagina 269)

100

101

Tip

You should be able to copy and paste

SELECT "Type", "Type"

FROM "Payment Type"

from above directly into the

List content

box. Just make sure you copy from the

in SELECT to the

double quotation mark after the phrase

Payment Type

and no

more than this.

Note

What you wrote is called an SQL command. The words

SELECT

and

FROM

are written in capital letters because they are

commands. When the command SELECT is used, it requires a

field name within quotation marks and then the field’s alias, also

within quotation marks. In this case, the field and its alias are the

same. The FROM command requires the name of the table which

contains the field. Single-word table names do not require

quotation marks, but multiple-word table names do.

• Repeat these steps for the payment fields for Lunch, Supper,

Motel, Snacks, and Misc. The main form should look like

Figure 216 as far as where the controls are located. It also

shows what the Note control should look like. Those changes

are explained in the next step.

• Close the Properties window.

Figure 216: Position of controls in main form

Step 7: Change the Note field.

We want the Note control where it is located in Figure 216. Since it

has a memo field type, it needs a vertical scrollbar for additional text

space if desired.

Control+click

the

Note

field. The green handles should surround

the Note field but not its label.

2) Click the Control icon to open the Properties window (Figure 217).

Chapter 8 Getting Started with Base 269

1 2 ... 264 265 266 267 268 269 270 271 272 273 274 ... 432 433

Comentarios a estos manuales

Sin comentarios

OpenOffice.org OpenOffice - 3.0 Guía de inicio rápido Pagina 269

Comentarios a estos manuales

Relacionado con productos y manuales para Software De Gráficos OpenOffice.org OpenOffice - 3.0