Access HFSQL DataFile from a different application

-
Sometimes there will be a need to access any one or more HFSQL Datafiles from a different path other than the current application folder.

We have a function called HChangeDir to change the connection to a specified application folder.

Example

 HChangeDir(TableName,CompleteDir(PathOfFileServer))

              Where PathOfFileServer is the Path of the different application

Comments

Post a Comment

Popular posts from this blog

Word Processing Control

-
Image
Overview The "Word processing" control is an evolved control allowing the end user to create and edit documents in docx format in theWINDEV application. The benefits are time saving, consistent interface, no other software to install/drive/manage. This control allows you to: ·     Open, create, modify, save "docx" files, ·         Convert docx into PDF, into HTML to send emails, ·         Manage the images and tables, ·         Save the documents in HFSQL databases, ·         Use a spelling checker, ·         Perform prints, ... Several keyboard shortcuts are also available: Shortcut Effect Shortcut Effect CTRL A Selects the entire text. CTRL C Copies the selection into the clipboard. CTRL F Starts the search. CTRL G Switches the selection to bold CT...
Read more

Read XML String and load the data in Controls

-
We can read a XML string and parse the data based on the XML tags and load the data into our UI COntrols. In the following example a Customer data is sent as XML String, We are going to retrieve the Customer Name, Address and City and load the same in the Edit Controls. s XML is string = "<?xml version='1.0' encoding='utf-8'?><XMLHDR><RESULT>TRUE</RESULT><CUSTOMER><NAME>TESTNAME</NAME><ADDRESS>12 A BLOCK</ADDRESS><STREET>15TH STREET</STREET><CITY>CHENNAI</CITY></CUSTOMER></XMLHDR>" XMLDocument ( "XMLOrd" , s XML )  XMLFirst ( "XMLOrd" ) XMLChild ( "XMLOrd" ) IF XMLElementName ( "XMLOrd" ) = "RESULT" THEN        IF XMLData ( "XMLOrd" ) = "TRUE" THEN                               WHILE XMLOut ( "XMLOrd"...
Read more

Track Directory

-
Image
fTrackDirectory (Function) When there is a requirement to track the files creation, modification, deletion of the files in a specified directory we can use the function fTrackDirectory. This function detects the modifications performed on the content of a directory. Only the modifications performed on the files found in the directory are detected. In case of modification, a specific procedure is run in a thread. Example          // Name of directory to track s DirectoryName is string = "C:\Temp\MyDir"         // The ProcessDirModification procedure will be called        // whenever a file or directory found in the "C:\Temp\MyDir" directory is modified.   IF fTrackDirectory ( s DirectoryName , ProcessDirModification , ftCreateFile  ... + ftModifyFile + ftDeleteFile + ftRename ) THEN                  // Inform the ...
Read more