Documentation
Back to website >

Client.RenderData (iScript)

Function Client.RenderData(Data, Options): string

With RenderData, a data set can be converted into a text in the form of an ADO recordset object. There are many more ways to influence the output format than with the GetString method of the Recordet object.

Example

set rs = Client.ExecuteSql("SELECT TOP 100 Match, PLZ, Ort FROM Adresse")
ellib.ShowStrings Client.RenderData(rs, "CSV")

 

Parameter

Description

Return

String

Data

ADO-Recordset

Options

Default (Preset) -Name or option string
 

Preset

Description

(empty) or CSV

Standard = semicolon and double quotation marks

TAB

TAB delimiter, no quotation marks, TABS will be replaced by SPACE

XML

 

HTMLLIST

 

HTMLROWS

 

HTMLTABLE

 

SQLSELECT

 

SQLVALUES

 

Options

A list of multiple options. Each option is listed as a pair of names and values separated by an equals sign. Multiple options are separated by semicolons. The values must be enclosed in quotation marks if they themselves contain semicolons or line breaks.

Example:

TrueValue=YES;FalseValue=NO

Name
Type
Standard value
Comment

RowDelimiter

string

CR LF

 

Delimiter

     

NullValue

string

empty

 

ErrorValue

string

****

 

TrueValue

string

TRUE

 

FalseValue

string

FALSE

 

QuoteChar

char

" (double quotation mark)

 

IncludeHeader

bit

1

Print column headers in first line

MaxRows

int

-1

Maximum number of lines or "-1" for all

SkipColumns

int

0

(BETA!) The first n columns are skipped

ClipString

bit

0

If a value contains a line break, only the content up to this line break is output. The rest is truncated

MultiLine

Bit

 

Special handling for multiline data. These are distributed over several lines. However, only in its own column. All other columns are output as blank lines 

RepeatColumns

int

0

When Multiline is used, the n first columns of the respective main row are repeated

Date and number formats

Name
Type
Standard value
Comment

Locale

string

En-en

 

NumberFormat

 

0.00##

 

DateFormat

 

Automatic by "Locale"

 

DecimalSeparator

char

dito

 

ThousandSeparator

char

dito

 

DateSeparator

char

dito

 

TimeSeparator

char

dito

 

Binary data options

Name
Type
Standard value
Comment

HexPrefix

string

0x

 

HexPostfix

string

leer

 

MaxBinary

int

100

Maximum number of bytes or "-1" if no restriction is to be made

Coding

Name
Type
Standard value
Comment

Escape

"XML", "PRINTF" oder leer für keine spezielle Kodierung

empty

 

FilterChars

string

empty

All specified characters are deleted from the output

MaskChars

string

empty

All characters occurring here will be replaced by the corresponding character from "MaskToChars"

MaskToChars

string

empty

See"MaskChars"

Trim

"RIGHT","LEFT","YES" oder "NO"

RIGHT

Remove spaces at the beginning or end, or both