HFSQL

PositionToLine FirstDayOfWeek FirstDayOfMonth Power Root RegistrySeek RegistryNextKey RegistryCreateKey RegistrySetValue RegistryExist RegistryListValue RegistryQueryValue RegistryFirstSubKey RegistryDeleteKey RegistryDeleteValue RegistryValueType Replace RepeatString NetworkConnect NetworkDisconnect NetworkDomainName NetworkDirName NetworkUser RGB RGBBlue RGBRed RGBToHTML RGBGreen NoAccent NoCharacter NoRightCharacter NoLeftCharacter NoSpace sComputeCrc16 sComputeCrc32 WeekToDate SexagesimalToDecimal Sin SysColor SysColorRes SysEnvironment SysSpace SysInstance SysNameExe SysDir SysWindowsVersion SysXRes SysYRes Length CommonLength LengthToString Tangent TextToRTF Truncate TSL UnicodeToAnsi URLDecode URLEncode URLExtractPath UTF8ToAnsi UTF8ToString UTF8ToUnicode UUDecode UUEncode Val MatchRegularExpression WindowsVersion LIST OF WLANGUAGE COMMANDS The WLanguage commands let you program cursors, or program all the processes you want. The 5GL WLanguage programming is very powerful and very in- tuitive. For example, searching for a row (a record), and all the associated processes (opening the table, assigning data, etc.) is done in one simple, powerful line of code: HReadSeek(CUSTOMER,NAME,”DOE”) The source programs are clear, easy to write and especially easy to maintain; this reduces the chance for errors, and makes the appli- cations you develop more reliable, and faster. Plain word commands make it easier to use: the code is self-com- mented! The HReadSeek command can be understood by any developer, even rookies! Other example, the creation of a table is done in 1 line of code, without any script: hCreate . Non-exhaustive list of WLanguage functions (5GL used by WINDEV, WEBDEV and WINDEV Mobile), with summary of their action. ScreenToFile Automatically initializes: - the memory value of the items of a data file with the value of the controls found in the window or in the page. - the value of the WLanguage variables with the value of the controls found in the window or in the page. ScreenToSource Automatically initializes: - the memory value of the items of a data file with the value of the controls found in the window or in the page. - the value of the WLanguage variables with the value of the controls found in the window or in the page. FileToScreen Automatically initializes the controls found in a window or in a page with: - the values of the associated items in the current record (loaded in memory) of the data file. - the values of the associated WLanguage variables. SourceToScreen Automatically initializes the controls found in a window or in a page with: - the values of the associated items in the current record (loaded in memory) of the data file. - the values of the associated WLanguage variables. WithSpace Adds or deletes the spaces found on the right of a text item when reading it. HAccelerateSpeed Reorganizes the internal structure of the indexes to optimize the speed for accessing the data. HActivateFilter Enables the filter that was previously created for the specified data file (view or query). HActivateAutoFilter Enables an automatic filter on the linked files when browsing an XML file. HActivateTrigger Re-enables a trigger that was disabled by HDeactivateTrigger. HActivateServerTrigger Re-enables a server trigger that was previously disabled by HDeactivateServerTrigger. HAdd Adds the record found in memory into the data file (query or view). HAddGroup Adds a group of users. HAddLink Adds an integrity rule between two files on the server. HAddScheduledOptimization Adds an optimization task of HFSQL Client/Server data files. HAddScheduledBackup Adds a scheduling for full backup (with or without differential backup) on the server defined by the connection. HAddTask Adds a scheduled task on the server defined by the connec- tion. HAddUser Adds a user to a database. HAlias Creates a logical alias of data file (or query) or cancels all exist- ing aliases. HCancelAlias Cancels an alias that was previously declared by HAlias. HCancelDeclaration Deletes a declaration performed by HDeclare, HDeclareExter- nal or HDescribeFile HCancelSeek Cancels the current search criterion. HCancelBackup Cancels a current backup. HStopServer Stops a HFSQL server. HLinkMemo Used to associate a file with a binary memo item or to cancel the existing link between a file and a binary item. HForward Moves several records forward from the current position in the data file, according to a specified item. HLockFile Locks a data file and restricts the access to this data file for all other sites or applications. HLockRecNum Locks a record and restricts the access to this record for all the other applications. HChangeKey Changes the search key. HChangeConnection Dynamically changes the connection associated with a data file. HChangeLocation Modifies the search mode of data files. HChangePassword Changes the password of a HFSQL Client/Server data file. HChangeName Modifies the physical name of a data file. HChangeDir Modifies the access path to a data file (which means the direc- tory where the file will be used). HChangeLogDir Modifies the location of log files corresponding to a HFSQL data file. HLoadParameter Reads a parameter that was saved from a stored procedure by HSaveParameter. HClusterAddNode Enables a node in a HFSQL cluster. HClusterStop Suspends the execution of a HFSQL cluster. HClusterStart Starts a HFSQL cluster. HClusterState Returns the status of a HFSQL cluster by interrogating its coordina- tor HClusterIgnoreSynchro Defines a node of the HFSQL cluster as data source to perform the cluster synchronization. HClusterNodeInfo Returns the status of each cluster node by interrogating the co- ordinator. HClusterParameter Reads and modifies the parameters of a HFSQL cluster. HClusterDeleteNode Disables a node in a HFSQL cluster. HConnect Redefines one or more parameters of a connection to a specific table or to a set of tables. HConnectRemoteAccess Opens an analysis in HFSQL Classic format via a remote access HBuildKeyValue Builds the value of a composite key to create a filter or to per- form a search. HBuildKeyValueANSI On a Unicode platform, used to build the value of a composite key. HConvert Converts a numeric value into a binary string in order to per- form a search on a numeric key. HCopyRecord Copies the content of the current record (loaded in memory) into the current record of a data file. HCopyFile Copies a HFSQL file. HCreation Creates an empty data file with the index file and the memo file if necessary. HCreationIfNotFound Creates an empty data file (if the file does not exist) or opens a data file (if the file exists). HCreateServerTrigger Adds or modifies a server trigger on the HFSQL server. HCreateView Creates a HFSQL view. HRecordDate Returns the date and time of the last write operation per- formed on a record found in a HFSQL file. HDBCreation Ends the description of the structure of an xBase data file by programming. HDBDescribeFile Describes by programming a file in dBase3 format. HDBDescribeIndex Describes by programming the different index files that will be created. HDBDescribeField Describes by programming each item of the structure of an xBase file. HDBIndex Opens an xBase index file. HDBOpen Opens the xBase data file and the file if it exists. HDBOpenNoLock In single-user mode, opens an xBase data file without locking it. HDBSortType Returns or modifies the sequence of text items in the xBase files. HFSQL • www.windev.com 18