ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Generalizing the management of spaces
  • Replication and WithSpace function
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
WithSpace (Function)
In french: EspaceSignificatif
ODBCOLE DBNot available with these kinds of connection
Adds or deletes the spaces found on the right of a text item when reading it.
Please note This function is only available for data files for which the "5.5 compatible mode: text fields with spaces" option has been checked in the data model editor ("Details" tab of the data file description).
// Manage significant spaces (add 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
Name of the data file used. If this parameter is not specified, WithSpace will handle all data files.
<Item name>: Optional character string
Name of the item used. If this parameter is not specified, WithSpace will handle all items in the specified data file.
<Options>: Boolean
  • True: the content of text headings is completed with spaces to the right.
  • False spaces to the right of text headings are removed.
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 on 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.
Starting with version 21 update 3 (version 210065), the synchronization functions (programmed or assisted universal replication) return an error to the client application if WithSpace is used on at least one of the replicated files.
Component: wd300hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 11/23/2024

Send a report | Local help