View source for Using Data Editor

{{Parent|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:

{|
|- valign="top"
! Option
! Description
|- valign="top"
|
Live
|
Edits data one row at a time. You must execute when you leave the row.
|- valign="top"
|
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|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:

* [[#Editing Date and Time Functions|Editing Date and Time Functions]]

== 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:

{|
|- valign="top"
! Option
! Description
! Access
|- valign="top"
|
Global
|
Lets you make global changes to the Data Editor date display from the Data Editor Tab of the <span class="Link">Options Editor</span>. For details, see [[#Editing date/time globally|Editing date/time globally]].
|
Options Editor
|- valign="top"
|
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|Editing grid date/time]].
|
Data Editor grid
|- valign="top"
|
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|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|Editing grid date/time]] or [[#Editing column date/time|Editing column date/time]].

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

#On the '''File''' menu, click '''Options'''.
#: The Options Editor opens.
#On the Options Editor, click the Data Editor Tab.
#On the Data Editor Tab, click ...
#: The Date/Time Format Builder dialog box opens.
#On the Date/Time Format Builder dialog box, click the Date/Time Format list, and then click the target predefined date/time format.
#To customize the date/time format to your specifications, click Customize.
#: The Date/Time Format Builder dialog box opens.
#On the Date/Time Format Builder dialog box, select the appropriate Date/Time Format Options:

{|
|- valign="top"
! Option
! Description
|- valign="top"
|
Date/Time Format
|
Displays the predefined Date/Time format.
|- valign="top"
|
Day Format
|
Lets you choose the day display.
|- valign="top"
|
Separator
|
Lets you choose the display separator between the day, month, and year.
|- valign="top"
|
Month Format
|
Lets you choose the month display.
|- valign="top"
|
Year Format
|
Lets you choose the year display.
|- valign="top"
|
Date Order
|
Lets you choose the date order display.
|- valign="top"
|
Hour Format
|
Lets you choose the hour display.
|- valign="top"
|
Minute
|
Lets you choose the minute display.
|- valign="top"
|
Sec Format
|
Lets you choose the second display.
|- valign="top"
|
AM/PM
|
Lets you choose the AM/PM display.
|- valign="top"
|
Date/Time Order
|
Lets you choose the date/time order display.
|- valign="top"
|
Format Display
|
Displays the current format.
|- valign="top"
|
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:

{|
|- valign="top"
! Option
! Description
|- valign="top"
|
Use Calendar Control as default
|
If selected, the '''Calendar Control '''window is used. For details, see [[#Editing Date and Time Functions|Editing Date and Time Functions]].
|- valign="top"
|
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|Editing date/time globally]].

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

#On the Datasource {{DatasourceWindow}}, select the target table.
#Right-click the table, and then click Edit Data.
#: The Data Editor opens.
#On the Data Editor tool bar, click Date/Time Format Builder.
#: The Date/Time Format Builder opens.
#On the Date/Time Format Builder, click the Date/Time Format list, and then click the target predefined date/time format.
#To customize the date/time format to your specifications, click Customize.
#: The Date/Time Format Builder dialog box opens.
#On the Date/Time Format Builder dialog box, select the appropriate Date/Time Format Options:

{|
|- valign="top"
! Option
! Description
|- valign="top"
|
Date/Time Format
|
Displays the predefined Date/Time format.
|- valign="top"
|
Day Format
|
Lets you choose the day display.
|- valign="top"
|
Separator
|
Lets you choose the display separator between the day, month, and year.
|- valign="top"
|
Month Format
|
Lets you choose the month display.
|- valign="top"
|
Year Format
|
Lets you choose the year display.
|- valign="top"
|
Date Order
|
Lets you choose the date order display.
|- valign="top"
|
Hour Format
|
Lets you choose the hour display.
|- valign="top"
|
Minute
|
Lets you choose the minute display.
|- valign="top"
|
Sec Format
|
Lets you choose the second display.
|- valign="top"
|
AM/PM
|
Lets you choose the AM/PM display.
|- valign="top"
|
Date/Time Order
|
Lets you choose the date/time order display.
|- valign="top"
|
Format Display
|
Displays the current format.
|- valign="top"
|
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|Editing grid date/time]].

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

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

#On the Datasource {{DatasourceWindow}}, select the target table.
#Right-click the table, and click Edit Data.
#: The Data Editor opens.
#On the Data Editor, click the column header to select the column.
#Right-click the column and click Format.
#: The Date/Time Format Builder opens.
#On the Date/Time Format Builder dialog box, click the Date/Time Format list, and then click the target predefined date/time format.
#To customize the date/time format to your specifications, click Customize.
#: The Date/Time Format Builder dialog box opens.
#On the Date/Time Format Builder dialog box, select the appropriate Date/Time Format Options:

{|
|- valign="top"
! Option
! Description
|- valign="top"
|
Date/Time Format
|
Displays the predefined Date/Time format.
|- valign="top"
|
Day Format
|
Lets you choose the day display.
|- valign="top"
|
Separator
|
Lets you choose the display separator between the day, month, and year.
|- valign="top"
|
Month Format
|
Lets you choose the month display.
|- valign="top"
|
Year Format
|
Lets you choose the year display.
|- valign="top"
|
Date Order
|
Lets you choose the date order display.
|- valign="top"
|
Hour Format
|
Lets you choose the hour display.
|- valign="top"
|
Minute
|
Lets you choose the minute display.
|- valign="top"
|
Sec Format
|
Lets you choose the second display.
|- valign="top"
|
AM/PM
|
Lets you choose the AM/PM display.
|- valign="top"
|
Date/Time Order
|
Lets you choose the date/time order display.
|- valign="top"
|
Format Display
|
Displays the current format.
|- valign="top"
|
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:

{|
|- valign="top"
! Option
! Functionality
|- valign="top"
|
Margins
|
Lets you select the size of the left, right, top, and bottom margins.
|- valign="top"
|
Titles and Gridlines
|
Lets you select options.
|- valign="top"
|
Preview
|
Displays how the table will appear when printed.
|- valign="top"
|
Page Order
|
Lets you specify when to print columns and rows.
|- valign="top"
|
Center on Page
|
Lets you select how table floats on the page.
|}