Choose your database:
AnySQL
MySQL
MS SQL Server
Oracle
PostgreSQL
SQLite
Firebird
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Ran / Cole: "We bought the tool last week and want to say how much we love it. We've found it not only powerful, but very user friendly. We have used the tool to create an interface that manages our MySQL DB for different types of users".
Charles Phillips: "Just want to take a second to really thank you for all the great support you give – I think that’s by far the best feature you offer".

More

Add your opinion

PHP Generator for MySQL online Help

Prev Return to chapter overview Next

View properties

Use the View options to define the way the column data are represented on generated webpages.

 

 

Use Display properties to set the type of data representation and format options (text alignment, image size, and so on). The available representations with the corresponding format options are shown in the table below. Format options are specified within the corresponding dialog opened by the ellipsis button next to the Display properties. By default, the format is the same as it is set at the Project options.

 

Along with available format options you can define your own ones with the Custom attributes option. This option allows you to specify the content of standard HTML style tag applied to the column data. For example, to set the font color and size of the column, enter style="color:red;font-size:20px;" as Custom attributes. To implement more difficult data representation, especially for conditional data formatting, it's recommended to use the OnExtendedCustomDrawRow event.

 

Available representations

Additional options

Result

Text

It's possible to set such style attributes as text alignment, and font options (bold, italic). The Max length value is the max number of signs to be visible on the generated webpage. You can also allow to replace CR+LF by <BR>, to use HTML and Word wrapping and specify several format options to be applied to the column data depending of data type (Number, Percent, String, Currency).

DateTime

Select the type of date time format.

Image

If BLOB data will be represented as images, specify the size of all the column images with Resize type and Height and Width fields. Image hints are set with templates.

 

To resize images, you need to have the appropriate PHP extension installed.

File download

If BLOB data will be represented as file downloads, set a Download file name and a Content type using templates. The Content type value is optional. To change the download image, generate the project and change the download.gif file in the images folder.

Checkbox

There are three display types of boolean data: check box controls, custom images, custom text values. Select the necessary option and specify the custom information (TRUE/FALSE captions or images).

External file, External image

To represent data in such a way, specify the Source prefix and Source suffix.

 

Example

Suppose there is a 'product' column with such data:

firebird_maestro,

sqlite_maestro,

 

There are image files with the following paths:

D:\Images\firebird_maestro_62x62.jpg

D:\Images\sqlite_maestro_62x62.jpg

 

To represent these images at the 'product' column on the generated page, Select External Image as View Properties and set

Source prefix=D:\Images\

Source suffix=_62x62.jpg

 

Display as hyperlink

To represent the column's data as hyperlink, check the Display as hyperlink option and specify the HREF Template. Target controls where the new document is displayed when a user follows the link.

 

_blank

opens the new document in a new window.

_parent

is used in the situation where a frameset file is nested inside another frameset file. A link in one of the inner frameset documents which uses "_parent" will load the new document where the inner frameset file had been.

_self

puts the new document in the same window and frame as the current document. "_self" works the same as if you had not used TARGET at all.

_top

loads the linked document in the topmost frame... that is, the new page fills the entire window.

 

Use the Header hint field to specify the the column caption's hint. By default, it is a comment to the table/view column.

 

Fixed column width

To set a fixed width of the grid, check the Fixed width, specify the Width, and select the Units.

 

Units

Meaning

em

The 'font-size' of the relevant font.

px

(pixels) Relative to the viewing device.

in

(inches) 1 inch is equal to 2.54 centimeters.

cm

Centimeters

mm

Millimeters

pt

(points) The points used by CSS 2.1 are equal to 1/72nd of an inch.

pc

(picas) 1 pica is equal to 12 points.

 

The Totals option allows you to enable a grid footer to display summaries (Sum, Average, Count, etc) for all or selected grid columns.



Prev Return to chapter overview Next