Filter
Top Products
Using the Database painter
58 DataWindow .NET
Modifying database preferences
To modify database preferences, select Design>Options from the menu bar.
Some preferences are specific to the database connection; others are specific to
the Database painter.
Preferences on the
General property page
The Connect To Default Profile, Shared Database Profiles, Keep Connection
Open, Use Extended Attributes, and Read Only preferences are specific to the
database connection.
The remaining preferences are specific to the Database painter. For information
about modifying these preferences, see Connecting to Your Database.
Table 3-4: Database painter preferences
Build, execute or explain
SQL
Use the ISQL view to build SQL statements. Use the
Paste SQL button to paste SELECT, INSERT, UPDATE,
and
DELETE statements or type them directly into the
view’s workspace. To execute or explain SQL, select
Execute SQL and Explain SQL from the Design or
pop-up menu.
Define or modify
extended attributes
Select from the Object>Insert menu the type of extended
attribute you want to define or modify, or highlight the
extended attribute from the list in the Extended
Attributes view and select New or Properties from the
pop-up menu.
Specify extended
attributes for a column
Drag the column to the Object Details view and select
the Extended Attributes tab.
Access database utilities Double-click a utility in the Objects view to launch it.
Log your work Select Design>Start Log from the menu bar. To see the
SQL syntax generated, display the Activity Log view.
To Do this
Database
preference
What DataWindow Designer does with the specified
preference
Columns in the
Table List
When DataWindow Designer displays tables graphically, eight
table columns display unless you change the number of
columns.
SQL Terminator
Character
DataWindow Designer uses the semicolon as the SQL
statement terminator unless you enter a different terminator
character in the box. Make sure that the character you choose
is not reserved for another use by your database vendor. For
example, using the slash character (/) causes compilation errors
with some DBMSs.