WithSpace (Function)

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

WLanguage

Management of databases

Generalizing the management of spaces

Replication and WithSpace function

HCreateMoveableReplica

HCreateSubscriberReplica

HDeactivateAutoFilter

HDescribeFullTextIndex

HErrorStatusModification

HFilterIncludedBetween

HMigrateLinkedCompositeKey

HRecreateSubscriberReplica

Generalizing the management of spaces
Replication and WithSpace function

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

WithSpace (Function)

In French: EspaceSignificatif

Not available with these kinds of connection

Adds or deletes the spaces found on the right of a text item when reading it.

Caution: This function is taken into account for the data files for which "5.5-compatible mode: text items filled with spaces" was checked in the data model editor ("Details" tab of the description of the data file).

Versions 18 and later

This function is now available in Windows Store apps mode.

New in version 18

This function is now available in Windows Store apps mode.

Versions 21 and later

This function is now available in Universal Windows 10 App mode.

New in version 21

This function is now available in Universal Windows 10 App mode.

Note: From version 19, HFSQL is the new name of HyperFileSQL.

Example

See additional examples

// Manages the significant spaces (adds spaces) for all the files
WithSpace(True)

Syntax

<Result> = WithSpace([<File Name> , ] [<Item Name> , ] <Options>)

<Result>: Boolean

Former management mode of significant spaces.

<File Name>: Optional character string (with or without quotes)

Name of data file used. If this parameter is not specified, WithSpace handles all the data files.
This parameter is ignored.

<Item Name>: Optional character string (with or without quotes)

Name of item used. If this parameter is not specified, WithSpace handles all the items found in the specified data file.
This parameter is ignored.

<Options>: Boolean

True: the content of the text items is filled with spaces on the right.
False: the spaces found on the right of the text items are removed.
The management of significant spaces will be performed for all the data files and for all the text items found in these data files.

Remarks

Generalizing the management of spaces

To apply the management mode of spaces to all the items found in a data file, the <Item Name> parameter must be equal to "*".
Example:

WithSpace(<File Name>, "*", <Options>)
To apply the management mode of spaces to all the items of all the data files, the <File Name> and <Item Name> parameters must be equal to "*".
Example:

WithSpace("*", "*", <Options>)

In this case, WithSpace returns False if the management of spaces was different for at least one of the relevant items.
If only the <Options> parameter is specified, the specified management mode is applied to all the data files and to all the items.

Replication and WithSpace function

The replication is not compatible with WithSpace in the code of the client application. This function changes the nehavior of HFSQL. Using this function in the client application can affect the efficiency of replication.

Versions 21 and later
From version 21 update 3 (version 210065), the synchronization functions (programmed or assisted universal replication) return an error to the client application if WithSpace was applied to at least one of the replicated files.

New in version 21
From version 21 update 3 (version 210065), the synchronization functions (programmed or assisted universal replication) return an error to the client application if WithSpace was applied to at least one of the replicated files.

From version 21 update 3 (version 210065), the synchronization functions (programmed or assisted universal replication) return an error to the client application if WithSpace was applied to at least one of the replicated files.

Components

wd230hf.dll

wp230hf.dll

wd230hf.so