Using Data Editor

From DBArtisan
Jump to: navigation, search

Go Up to Data Editor

Data Editor lets you edit data in your tables with any editable datatype without leaving the parent application. Data Editor lets you use your new data immediately.

Caution: Data Editor is a real-time editor. Changes in your data using Data Editor are permanent.

The table below describes the functions and options of the Data Editor:

Option Description

Live

Edits data one row at a time. You must execute when you leave the row.

Batch

Edits data in multiple rows before executing.

Note: You can also use the Data Editor to edit date and time functions in a table. For details, see Editing Date and Time Functions.
Note: If you make an incorrect edit in a cell, Data Editor displays the error on the Error Tab of the ISQL Editor. Data Editor does not incorporate this error(s) in data into the table. Data Editor saves any changes in data prior to the error message.
Caution: Data Editor is a real-time editor. Changes in your data using Data Editor are permanent.

Editing Date and Time Functions

The Data Editor lets you edit date and time functions in a table. Data Editor uses a calendar tool to guarantee accurate input for date and time data. You can also change the display of date and time using the Date/Time Format Builder.

For more information, see:

Date/time Format Builder

The Date/Time Format Builder lets you customize your date/time display. The Data Editor uses this format to display your dates and times. You control how the Data Editor displays the dates and time by using predefined formats, or by customizing a format to fit your needs.

The Data Editor uses the default date/time format of your Operating System. If you do not make any global changes, the Date/Time Format Builder displays dates and times using the default formats of your operating system.If you make changes to dates and times in the Data Editor, the changes are committed in the format used by the database.

Note: The changes you make using the Date/Time Format Builder do not affect the way your database stores dates and times.

Editing the Date/time Display

You can edit the date/time display on a global, table, or column level. The table below describes the different ways you can edit your date/time format display:

Option Description Access

Global

Lets you make global changes to the Data Editor date display from the Data Editor Tab of the Options Editor. For details, see Editing date/time globally.

Options Editor

Grid

Lets you make changes to the date display of the entire Data Editor grid for that session only. For details, see Editing grid date/time.

Data Editor grid

Column

Lets you make changes to the date display of a single column in the Data Editor for that session only. For details, see Editing column date/time.

Data Editor column

Note: Date/Time formats changed on a table or column level are valid for that session only.

Editing date/time globally

You can use the Options Editor to make global changes to your date/time display in the Data editor. When you change the date/time format, using the Options Editor, the Data Editor displays all dates and times in the global manner. To change the date/time display for a particular session, see Editing grid date/time or Editing column date/time.

To edit the date and time globally, do the following:

  1. On the File menu, click Options.
    The Options Editor opens.
  2. On the Options Editor, click the Data Editor Tab.
  3. On the Data Editor Tab, click ...
    The Date/Time Format Builder dialog box opens.
  4. On the Date/Time Format Builder dialog box, click the Date/Time Format list, and then click the target predefined date/time format.
  5. To customize the date/time format to your specifications, click Customize.
    The Date/Time Format Builder dialog box opens.
  6. On the Date/Time Format Builder dialog box, select the appropriate Date/Time Format Options:
Option Description

Date/Time Format

Displays the predefined Date/Time format.

Day Format

Lets you choose the day display.

Separator

Lets you choose the display separator between the day, month, and year.

Month Format

Lets you choose the month display.

Year Format

Lets you choose the year display.

Date Order

Lets you choose the date order display.

Hour Format

Lets you choose the hour display.

Minute

Lets you choose the minute display.

Sec Format

Lets you choose the second display.

AM/PM

Lets you choose the AM/PM display.

Date/Time Order

Lets you choose the date/time order display.

Format Display

Displays the current format.

Sample

Displays a sample of the current format.

7. When you have finished selecting the Date/Time format options, click OK.
The date/time format changes are accepted the Date/Time Format Builder dialog box closes.
8. On the Options Editor, select the appropriate Default Date/Time Format options:
Option Description

Use Calendar Control as default

If selected, the Calendar Control window is used. For details, see Editing Date and Time Functions.

Two-digit year system setting warning

If selected, a warning is sent when you use a two-digit year system setting.

9. Click OK.
The Default Date/Time Format changes are accepted the Options Editor closes.
Note: To use a different format for a particular session, change the date/time at the session level.

Editing grid date/time

You can change the date/time display for a particular session when working in the Data Editor.

The Data Editor does not maintain the format changes once you close your session. To make this display permanent, use the Editing Global Date/Time Format. For details, see Editing date/time globally.

To edit the grid date and time, do the following:

  1. On the Datasource Navigator/Explorer, select the target table.
  2. Right-click the table, and then click Edit Data.
    The Data Editor opens.
  3. On the Data Editor tool bar, click Date/Time Format Builder.
    The Date/Time Format Builder opens.
  4. On the Date/Time Format Builder, click the Date/Time Format list, and then click the target predefined date/time format.
  5. To customize the date/time format to your specifications, click Customize.
    The Date/Time Format Builder dialog box opens.
  6. On the Date/Time Format Builder dialog box, select the appropriate Date/Time Format Options:
Option Description

Date/Time Format

Displays the predefined Date/Time format.

Day Format

Lets you choose the day display.

Separator

Lets you choose the display separator between the day, month, and year.

Month Format

Lets you choose the month display.

Year Format

Lets you choose the year display.

Date Order

Lets you choose the date order display.

Hour Format

Lets you choose the hour display.

Minute

Lets you choose the minute display.

Sec Format

Lets you choose the second display.

AM/PM

Lets you choose the AM/PM display.

Date/Time Order

Lets you choose the date/time order display.

Format Display

Displays the current format.

Sample

Displays a sample of the current format.

7. When you have finished selecting the Date/Time format options, click OK.
The date/time format changes are accepted and the Date/Time Format Builder dialog box closes.
  • To undo changes, on the Data Editor tool bar, click Undo Change.
  • To redo changes, on the Data Editor tool bar, click Redo Change.
Note: Date/Time formats changed on a table level are valid for that session only.

Editing column date/time

You can change the date/time display for a particular column when working in the Data Editor.

The Data Editor does not maintain the format changes once you close your session. To change the format for the entire grid, see Editing Grid Date/Time Format. For details, see Editing grid date/time.

To make this display permanent, Editing Global Date/Time Format. For details, see Editing date/time globally.

To edit the column date and time, do the following:

  1. On the Datasource Navigator/Explorer, select the target table.
  2. Right-click the table, and click Edit Data.
    The Data Editor opens.
  3. On the Data Editor, click the column header to select the column.
  4. Right-click the column and click Format.
    The Date/Time Format Builder opens.
  5. On the Date/Time Format Builder dialog box, click the Date/Time Format list, and then click the target predefined date/time format.
  6. To customize the date/time format to your specifications, click Customize.
    The Date/Time Format Builder dialog box opens.
  7. On the Date/Time Format Builder dialog box, select the appropriate Date/Time Format Options:
Option Description

Date/Time Format

Displays the predefined Date/Time format.

Day Format

Lets you choose the day display.

Separator

Lets you choose the display separator between the day, month, and year.

Month Format

Lets you choose the month display.

Year Format

Lets you choose the year display.

Date Order

Lets you choose the date order display.

Hour Format

Lets you choose the hour display.

Minute

Lets you choose the minute display.

Sec Format

Lets you choose the second display.

AM/PM

Lets you choose the AM/PM display.

Date/Time Order

Lets you choose the date/time order display.

Format Display

Displays the current format.

Sample

Displays a sample of the current format.

8. When you have finished selecting the Date/Time format options, click OK.
The date/time format changes are accepted and the Date/Time Format Builder dialog box closes.
  • To undo changes, on the Data Editor tool bar, click Undo Format.
  • To redo changes, on the Data Editor tool bar, click Redo Format.
Note: Date/Time formats changed on a column level are valid for that session only.

Default Value Handling

When adding new records, when the transaction committing a row occurs, if no value has been entered for a column defined as having a default value, the default value is used for that column and validation is not required. The default value is not visible in the Data Editor grid until you commit the record and use the Reload Data button to refresh the grid.

In the case of tables with all columns defined as having default values, for example, you can add multiple records by repeatedly clicking the Insert New Record and Save Current Row buttons.

Page setup

The table below describes the options and functionality on the Page Setup dialog box:

Option Functionality

Margins

Lets you select the size of the left, right, top, and bottom margins.

Titles and Gridlines

Lets you select options.

Preview

Displays how the table will appear when printed.

Page Order

Lets you specify when to print columns and rows.

Center on Page

Lets you select how table floats on the page.