Control: Picture

 Show all Hide all

A control used in grids and Info SQL to display pictures, either from database or disk. Used in NewEdit to upload pictures.

Start value:
Return value:

Control container: NewEdit

Supported in: NewEdit InfoSql Grid

SQL

SQL Call: Picture Information (mandatory)

Retrieves the information necessary to display the picture.
Supports custom errors: No
May modify database: No

Parameters:

@id mandatory string
@info mandatory bit
Identifies the Picture Information call.

Resultset: Picture Information

Repeat mode: repeated exactly once
Row count: exactly one row

Columns:

Alt optional string
A description of the picture, for blind users and those whose browsers do not download pictures. The browser may or may not display this as a tooltip for the image.
CustomHTML optional string
Customized HTML to display the image. The parameter {tag} is replaced by the whole image tag. {url} is replaced with the URL to the image. {alt}, {width} and {height} are replaced by the values from their corresponding columns.
Height optional int
The heightof the picture. Helps the web browser layout the page. The browser will resize the image to fit this height.
URL optional string
Either an URL relative to the project directory or an absolute URL.
Used when you want to display a picture from disk and not from the database.
Width optional int
The width of the picture. Helps the web browser layout the page. The browser will resize the image to fit this width.

SQL Call: Picture (mandatory)

Retrieves the image itself.
Supports custom errors: No
May modify database: No

Parameters:

@Id mandatory string

Resultset: Picture

Repeat mode:
Row count:

Columns:

<xxx> mandatory binary
The picture data
<xxx>ContentType optional string
Content MIME type

Default value

SQL Call: Default value

Retrieves the default value for the control.
Supports custom errors: No
May modify database: No

Resultset: Default value

Repeat mode: repeated exactly once
Row count: exactly one row

Columns:

<column with ordinal 1> mandatory string
The default value

Validation

SQL Call: Validation

Performs field validation when the user leaves the field or one of its dependencies is changed. This call is only made if there is a field validation of type SQL set for the field info.
Supports custom errors: No
May modify database: No

Parameters:

@Value mandatory string
The value of the field, the procedure will not be called if value is NULL.

Resultset: Validation messages

Repeat mode: repeated zero or one time
Row count: zero or one row

Columns:

Error optional string
Error message to display. Blocks the user from saving.
Info optional string
Informative message to display. Does not block saving.