Editors - Data Browsing

Previous  Index  Next  How To Use

 

 

Browsing Data

These settings are used in the SQL Editor and the View & Table Editor, Data tab.

 

Show NULL as

A textual representation of the SQL NULL value.

Use immediate data editing

If you turn this OFF, you have to press ENTER before being able to edit data in grids, this can also be modified using the tool bar button in the SQL Editor.

Warn while fetching large result sets into memory

This controls the Data Fetching Warning dialog: either always fetch large result sets without warning, or define parameters when to pop up.



 

Value Formatting

Integer base data and floating point based data use the formatting settings in the first two boxes. The following characters are accepted:

 

0

Digit placeholder. If the value being formatted has a digit in the position where the "0" appears in the format string, then that digit is copied to the output string. Otherwise, a "0" is stored in that position in the output string.

 

#

Digit placeholder. If the value being formatted has a digit in the position where the "#" appears in the format string, then that digit is copied to the output string. Otherwise, nothing is stored in that position in the output string.

 

.

Decimal point. The first "." character in the format string determines the location of the decimal separator in the formatted value; any additional "." characters are ignored. The actual character for the decimal separator is specified in the Number Format of the Regional Settings section in the Windows Control Panel.

 

,

Thousand separator. If the format string contains one or more "," characters, the output will have thousand separators inserted between each group of three digits to the left of the decimal point. The placement and number of "," characters in the format string does not affect the output, except to indicate that thousand separators are wanted. The actual character used as a the thousand separator in the output is determined by thousand separator is specified in the Number Format of the Regional Settings section in the Windows Control Panel.

 

Date & Time based data use the formatting settings in the next 3 boxes, if you clear them, Database Workbench will use the Windows Control Panel settings.

 

d or dd

The day as a number, using "dd" means it includes a leading zero.

 

ddd or dddd

The day as a textual representation, the short format means using an abbreviation, the long format means the full textual representation.

 

m or mm

The month as a number, using "mm" means it includes a leading zero.

 

mmm or mmmm

The month as a textual representation, the short format means using an abbreviation, the long format means the full textual representation.

 

yy or yyyy

The year as a two digit or four digit number.

 

h or hh

The hour as a number, using "hh" means it includes a leading zero.

 

n or nn

The minutes as a number, using "nn" means it includes a leading zero.

 

s or ss

The seconds as a number, using "ss" means it includes a leading zero.

 

/

The date separator as specified in the Windows Control Panel.

 

:

The time separator as specified in the Windows Control Panel.