Function::Internal
DEOS 
DEOS(commandstring)
DEOS(commandstring, param1,param2..paramn)
DEOS("@KEYWORD","Argument","Argument","MemoArgument","MemoArgument")
DEOS("@DFDDQLNr","C:\MyApp\REPOxAAA.DBM") -- Read the number of DQL's in a DFD application.
DEOS("@DFDDQLPath","C:\MyApp\REPOxAAA.DBM","5") -- Read out path for DQL nr 5 in REPORT File.
DEOS("@DFDDQLSet","C:\MyApp\CUSTxAAA.DBR","MyDQLMemo","MyBodyMemo") -- Read the DQL Script and Body Layout from DFD DQL and set in memo in current form.
DEOS("@DFDDQLPrism","C:\MyApp\CUSTxAAA.DBR",MyDQLMemo,MyBodyMemo) -- Same as above, but set in PRISM memos. This is for processing i.e. inside DQL.
DEOS("@BrowseForApp") -- Will open the file dialog and browse for a DataEase 8.5 Application
DEOS("@GetBrowsedAppPath") -- Will return the path to the app browsed for.
DEOS("@GetBrowsedAppName") -- Will return the name of the app browsed for.
DEOS("@OpenApp","AppPath","AppName") -- will open the Application in path with name Appname.
DEOS("@NewApp","AppPath","AppName","","","Template") -- Will create a new application in Path with Name APpName using Template Template.
in 8.5 the goal is to think and act outside the traditional DataEase "box". With Remote() we give you the ability to read data from Remote data-sources like the new DataEase Server, and with Get() we allow you to read localized infomation i.e. from files and environment variables etc.
The first "major" functionality to be implemented in Get() is to read DFD Repositories like Reports (both 4.x and 5.x) and then based on the information gathered read out the DQL Code (Script) and Body Formatting.
This function is only available in DE8.5.1.1995 or later.
PS! Please update to version later than 2281 to get make sure all listed features are available.
Parameters
Keyword (@): All Keywords start with @:
@DFDDQLNr : Return the number of DQL's in REPOxAAA.DBM.
ex. DEOS("@DFDDQLnr","C:\MyApp\REPOAAAA.DBM")
@DFDDQLName: Return the name of a numbered DQL in the Repostiory.
ex. DEOS("@DFDDQLName","C:\MyApp\REPOAAAA.DBM","6")
@DFDDQLPath: Return the path of a numbered DQL in the Repostiory.
ex. DEOS("@DFDDQPath","C:\MyApp\REPOAAAA.DBM","6")
@DFDDQLSet: Read the DQL Script and Body out of the DBR file and set it in two memos in the local form..
ex. DEOS("@DFDDQLName","C:\MyApp\CUSTAAAA.DBR","MyDQLMemo","MyBodyMemo")
@DFDDQLPrism: Read the DQL Script and Body out of the DBR file and set it in two PRISM Memos (Processing).
ex. DEOS("@DFDDQLName","C:\MyApp\CUSTAAAA.DBR",MyDQLMemo,MyBodyMemo)
@AppIniGet
String
Returns the app ini setting based on in rdrrXaaa.ini found in the application folder
- Section - The ini section where this setting is found, this is seen as [SECTION NAME] in the ini file
- Key - The key found in the defined section. This is seen as KeyName= in the ini file
- [Default] - The value to return if no setting is found in the ini file
@AppIniSet
String
Sets the app ini value in rdrrXaaa.ini found in the application folder
- Section - The ini section where this setting is found, this is seen as [SECTION NAME] in the ini file
- Key - The key found in the defined section. This is seen as KeyName= in the ini file
- Value - The value to set (must use string)
@BrowseForApp
String
Open a new item style dialog (Windows Vista and newer) and let you select a folder. If the folder contains DataEase applications the name of the application is shown. The default is to return the folder selected.
Parameters [Optional]
- [Start path] where to start to select file. The dialog remembers the last selection, so this parameter usually are left blank.
- [Return type] default is to return folder selected but you can use the following to override this:
@BrowseForAppFile
String
Open a new item style dialog (Windows Vista and newer) and let you select a repository file. If the folder contains DataEase applications the name of the application is shown. The default is to return the folder selected.
Parameters [Optional]
- [Type] now or old style rdrr file. Default is old style.
- [Start path] where to start to select file. The dialog remembers the last selection, so this parameter usually are left blank.
- [Return type] default is to return folder selected but you can use the following to override this:
@BrowseForFile
String
Open a new item style dialog and let you select a file. The file path is then returned.
Parameters [Optional]
- [Start path] where to start to select file. The dialog remembers the last selection, so this parameter usually are left blank.
- [Filter] what files to display in dialog. Default is All files (*.*)|*.* that will list all files. To set you own, use the format My description|*.ext;My other description|*.other Ex: DEOS("@BrowseForFile","Images (*.png)|*.png;All files|(*.*)")
- [Settings] no implemented yet. For future use
@BrowseForFolder
String
Open a new item style dialog and let you select a folder. The file path is then returned.
Parameters [Optional]
- [Start path] where to start to select folder. The dialog remembers the last selection, so this parameter usually are left blank.
- [Settings] no implemented yet. For future use
@CallAction
Nothing
deos("@callaction",actionno,param)
ActionNo = Action number in action list.
Param = Arguments for action (extended).
@ChangeLicense
Change the license key in DataEase to a new one. Can be done in dialog or by supplying the new license.
Parameters [Optional]
- [LicenseKey]
Ex. DEOS("@ChangeLicense",GetValue("NewLicense")) will change your license to the one supplied in the field NewLicense. It will only be changed if this is a valid license.
@CopyDirectory
Nothing
Copy a directory and all subdirectories to a new folder
Parameters
- from path
- to path
@CopyFile
Nothing
Copy a file to a directory or over another file
Parameters
- file to cpoy
- path to copy to or file name to copy to
@CreateDirectory
Nothing
Created a directory at given path.
Parameters
- path
Only creates the path if parent directory exists.
@ClearAppKey
Clear the Generated AppKey in RDRRxAAA
@CreateShortcut
Create a shortcut used for starting an anplication
Parameters
- path to executable file
- working directory
- startup arguments
- linkfile (can be absolute if next parameter is blank) recognized by windows (ex. "myapp.lnk")
- addto (can be blank, "Desktop" or "Programs"). If programs is used, use a relative path to the link file to add to a specific program group.
- iconpath path to a .ico file or to exe/dll file with the icons to use
- iconidx the index to the icon to use in the file pointed to by iconpath
Ex:
DEOS("@CreateShortcut","C:\Program Files (x86)\DataEase\DataEase 8.5\dataease.exe","",StringEscape("/'C:\Users\myuser\Documents\My DataEase\MyApp/' TheApp"),"TheApp.lnk","Desktop","C:\Program Files\App with icons\IconApp.exe",0)
will add you app in the on the desktop with the name TheApp and use the first icon in the IconApp.exe as the application icon.
@DeleteDirectory
Nothing
Delete an empty directory or by adding second the files as well. Use with caution.
Parameters
- path to directory
- [allfiles=yes]
Ex. DEOS("@DeleteDirectory","C:\Users\Per\Documets\DataEaseApp","allfiles=yes") will remove all files and the directory without any warning.
As a precaution, the path has to be at least 10 chars long.
@DeleteFile
Nothing
Delete a file
Parameters
- file path name
@DirectoryEmpty
yes/no
Check if a directory with the given path is empty. Return yes if exists and empty and no for exists and not empty. Return blank if not exists.
Parameters
- path
@DirectoryExists
yes/no
Check if a directory with the given path exists. Return yes for exists and no for not exists.
Parameters
- path
@FileExists
yes/no
Checks for a file. If the file exists, yes is returned and else no is returned. A directory named the same as the file given will return no. Use @DirectoryExists to check for directories.
Paramers
- File pah
@GetAppKey
String
Get the UNIQUE application key for this application. 8.6 onwards.
@GetBrowsedAppName
String
Returns the application name returned by the previous call to @BrowseForApp.
@GetBrowsedAppPath
String
Returns the folder returned by the previous call to @BrowseForApp.
@GetBrowsedAppVersion
String
Return a version identifier. The currently supported version is DfW 8.5, DfW 7, DfW 7, DfW6, DfD 5, DfD 4.5
@NewApp
Nothing
Let you create an app by supplying Folder, Name, UserName, Password and App template as parameters. The application is opened after creating in a new DataEase instance. The Default template will be used if none given. To not use a template, use the template name "<none>".
@OpenApp
Nothing
Let you open an app by supplying Folder, Name, [UserName], [Password] and [DefaultDoc] as parameters. The application is opened in a new DataEase instance.
@PinToStart
Add a application link to the new Start menu in Windows >8
Parameters
- path to folder
- file
Ex. DEOS("@PinToStart","%USERPROFILE%Desktop","MyApp.lnk") will add the MyApp link at you desktop to the new Start
@PinToTaskbar
Add a application link to the Taskbar in Windows >8
- path to folder
- file
Ex. DEOS("@PinToTaskbar","%USERPROFILE%Desktop","MyApp.lnk") will add the MyApp link at you desktop to the Taskbar.
@RenameApp
String
Let you rename an application of any version (4.53DOS-8.5Win) by parameters:
- Path
- Old name
- New name
Return nothing if rename is done and the reason for not renaming if there was an error.
@RestartApp
Nothing
Will restart the app with the same credentials. To be used when changes that need restart to take effect has been done ex. changes/additions to RDRRxAAA.INI either manually or automatically.
@SetBrowsedAppPath
Nothing
Set the path used for reading application information. This can be used to get the @GetBrowsedAppName and @GetBrowsedAppVersion from a path without having to browse for the files using GUI.
@SetFileTime
Nothing
Set the file last changed time and date
Parameters
- file path
- string with date and time in the format used by DataEase at your location Ex. 17/03/2016 09:32:02 for UK
The date format uses the format set on your computer, but you can override this by using prefix if you want to use a hard coded time stamp. The supported prefix are:
ISO:YYYY/MM/DDThh:mm:ss Ex. ISO:2016/03/22T03:14:15
I:DD/MM/YYYY hh:mm:ss Ex. I:22/3/2016 3:14:15
M:YYYY/MM/DDThh:mm:ss Ex. M:2016/3/22 3:14:15
N:MM/DD/YYYY hh:mm:ss Ex. 3/22/2016 3:14:15
@UnPinFromStart
Remove a application link from the new Start menu in Windows >8
- path to folder
- file
Ex. DEOS("@UnPinFromStart","C:\Windows","notepad.exe") will remove the notepad.exe link from your new start menu
@UnPinFromTaskbar
Remove a application link from the Taskbar in Windows >8
- path to folder
- file
Ex. DEOS("@UnPinFromTaskbar","C:\Windows","notepad.exe") will remove the notepad.exe link from the Taskbar.
@Unzip
Nothing/
Error
Unzip a compressed file to a directory. If the catalog is not exists, it will be created.
Parameters
- Zip file
- Path to unzip to
Zip formats supported are zip. 7z, gzip, bzip2, rar, arj, tar, iso, cab, lzma, lzma86 and more. We supports all format the 7z decompressor supports.
Directory will only be created if parent directory exists.
@Zip
Nothing/
Error
Zip a directory and sub directory to a file.
Parameters
- Directory to zip
- Zip file name path
Zip formats supported for zipping is .zip, .7z, .bz2, .gz, .tar, .swm, .txz and more. We supports all the formats the 7z compressor supports and recognizes as file endings.
Returns/Result
String with asked for field, empty string or in error situation the error string.
ex. DEOS("@DFDDQLnr","C:\MyApp\REPOAAAA.DBM")
@DFDDQLName: Return the name of a numbered DQL in the Repostiory.
ex. DEOS("@DFDDQLName","C:\MyApp\REPOAAAA.DBM","6")
@DFDDQLPath: Return the path of a numbered DQL in the Repostiory.
ex. DEOS("@DFDDQPath","C:\MyApp\REPOAAAA.DBM","6")
@DFDDQLSet: Read the DQL Script and Body out of the DBR file and set it in two memos in the local form..
ex. DEOS("@DFDDQLName","C:\MyApp\CUSTAAAA.DBR","MyDQLMemo","MyBodyMemo")
@DFDDQLPrism: Read the DQL Script and Body out of the DBR file and set it in two PRISM Memos (Processing).
ex. DEOS("@DFDDQLName","C:\MyApp\CUSTAAAA.DBR",MyDQLMemo,MyBodyMemo)
@AppIniGet
- Section - The ini section where this setting is found, this is seen as [SECTION NAME] in the ini file
- Key - The key found in the defined section. This is seen as KeyName= in the ini file
- [Default] - The value to return if no setting is found in the ini file
- Section - The ini section where this setting is found, this is seen as [SECTION NAME] in the ini file
- Key - The key found in the defined section. This is seen as KeyName= in the ini file
- Value - The value to set (must use string)
Parameters [Optional]
- [Start path] where to start to select file. The dialog remembers the last selection, so this parameter usually are left blank.
- [Return type] default is to return folder selected but you can use the following to override this:
Parameters [Optional]
- [Type] now or old style rdrr file. Default is old style.
- [Start path] where to start to select file. The dialog remembers the last selection, so this parameter usually are left blank.
- [Return type] default is to return folder selected but you can use the following to override this:
Parameters [Optional]
- [Start path] where to start to select file. The dialog remembers the last selection, so this parameter usually are left blank.
- [Filter] what files to display in dialog. Default is All files (*.*)|*.* that will list all files. To set you own, use the format My description|*.ext;My other description|*.other Ex: DEOS("@BrowseForFile","Images (*.png)|*.png;All files|(*.*)")
- [Settings] no implemented yet. For future use
Parameters [Optional]
- [Start path] where to start to select folder. The dialog remembers the last selection, so this parameter usually are left blank.
- [Settings] no implemented yet. For future use
ActionNo = Action number in action list.
Param = Arguments for action (extended).
Parameters [Optional]
- [LicenseKey]
Ex. DEOS("@ChangeLicense",GetValue("NewLicense")) will change your license to the one supplied in the field NewLicense. It will only be changed if this is a valid license.
Parameters
- from path
- to path
Parameters
- file to cpoy
- path to copy to or file name to copy to
Parameters
- path
Only creates the path if parent directory exists.
Parameters
- path to executable file
- working directory
- startup arguments
- linkfile (can be absolute if next parameter is blank) recognized by windows (ex. "myapp.lnk")
- addto (can be blank, "Desktop" or "Programs"). If programs is used, use a relative path to the link file to add to a specific program group.
- iconpath path to a .ico file or to exe/dll file with the icons to use
- iconidx the index to the icon to use in the file pointed to by iconpath
Ex:
DEOS("@CreateShortcut","C:\Program Files (x86)\DataEase\DataEase 8.5\dataease.exe","",StringEscape("/'C:\Users\myuser\Documents\My DataEase\MyApp/' TheApp"),"TheApp.lnk","Desktop","C:\Program Files\App with icons\IconApp.exe",0)
will add you app in the on the desktop with the name TheApp and use the first icon in the IconApp.exe as the application icon.
Parameters
- path to directory
- [allfiles=yes]
Ex. DEOS("@DeleteDirectory","C:\Users\Per\Documets\DataEaseApp","allfiles=yes") will remove all files and the directory without any warning.
As a precaution, the path has to be at least 10 chars long.
Parameters
- file path name
Parameters
- path
Parameters
- path
Paramers
- File pah
Parameters
- path to folder
- file
Ex. DEOS("@PinToStart","%USERPROFILE%Desktop","MyApp.lnk") will add the MyApp link at you desktop to the new Start
- path to folder
- file
Ex. DEOS("@PinToTaskbar","%USERPROFILE%Desktop","MyApp.lnk") will add the MyApp link at you desktop to the Taskbar.
- Path
- Old name
- New name
Return nothing if rename is done and the reason for not renaming if there was an error.
Parameters
- file path
- string with date and time in the format used by DataEase at your location Ex. 17/03/2016 09:32:02 for UK
The date format uses the format set on your computer, but you can override this by using prefix if you want to use a hard coded time stamp. The supported prefix are:
ISO:YYYY/MM/DDThh:mm:ss Ex. ISO:2016/03/22T03:14:15
I:DD/MM/YYYY hh:mm:ss Ex. I:22/3/2016 3:14:15
M:YYYY/MM/DDThh:mm:ss Ex. M:2016/3/22 3:14:15
N:MM/DD/YYYY hh:mm:ss Ex. 3/22/2016 3:14:15
- path to folder
- file
Ex. DEOS("@UnPinFromStart","C:\Windows","notepad.exe") will remove the notepad.exe link from your new start menu
- path to folder
- file
Ex. DEOS("@UnPinFromTaskbar","C:\Windows","notepad.exe") will remove the notepad.exe link from the Taskbar.
Error
Parameters
- Zip file
- Path to unzip to
Zip formats supported are zip. 7z, gzip, bzip2, rar, arj, tar, iso, cab, lzma, lzma86 and more. We supports all format the 7z decompressor supports.
Directory will only be created if parent directory exists.
Error
Parameters
- Directory to zip
- Zip file name path
Zip formats supported for zipping is .zip, .7z, .bz2, .gz, .tar, .swm, .txz and more. We supports all the formats the 7z compressor supports and recognizes as file endings.
String with asked for field, empty string or in error situation the error string.
Examples
Reference
See Also
On the forum about DEOS
DataEase 8 Videos 
DataEase users,
I am planning to create at least one video per week.
To kick start this process, here is the link where you can watch "How to..." videos released to limited users last week:
<a href="http://www.fish4support.c...
Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 19/08/13 at 14:48:10
Re:DataEase 8 Videos
If anyone like to get email alerts, each time new video becomes available let me know.
Regards
Arul
DataEase Consultant
Fish4Support, 335 Goldhawk Trail,Scarborough, ON M1V 4G2, Canada
Tel(Canada): 647-930-6497 | Tel(US...
Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 20/08/13 at 15:23:27
Re:Re:DataEase 8 Videos
I have updated my web site with the link.
New videos released. See all of them here:
http://www.fish4support.com/resources/de8-how-to
...
Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 22/08/13 at 13:24:15
Re:Re:Re:DataEase 8 Videos
Updated with new videos. Also site is organized nicely now.
All can be found here:
http://www.fish4support.com/resources/videos
Regards
Arul
...
Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 05/09/13 at 22:09:35
DataEase 8 Videos
DataEase users,
Latest videos can be found here:
http://www.fish4support.com/resources/videos
Regards
Arul
DataEase Consultant...
Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 19/09/13 at 17:43:18
DataEase 8 Videos
DataEase users,
New videos available for your viewing pleasure:
http://www.fish4support.com/resources/videos
Regards
Arul
DataEase Consultant...
Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 02/10/13 at 18:38:45
Problem with DEOS @DFDDQLSet
I have been trying out the options available with DEOS - @DFDDQLNr, @DFDDQLName and @DFDDQLPath all give me the results that I was expecting, but I cannot get @DFDDQLSet to give me anything - No errors, no results, nothing!I have tried executin...
Product: Dataease [{8}]FIVE. Written by Peter Birney, PB Associates 30/12/15 at 12:13:45
DEOS and migrating DQL scripts with Body.
I have tried this out and have migrated a test V5.16 database to V8.5 and been able to bring the procedures across as well in a fairly automated manner, both DQL and body. With a little jiggery-pokery to the DQL and body I have managed to get...
Product: Dataease [{8}]FIVE. Written by Peter Birney 07/01/16 at 12:57:51
Re:DEOS and migrating DQL scripts with Body.
Hi Pete. I am getting the good old DFD feeling now ;-) When I first started with DFD I played and got things working, and after a while I realised that I need to up the game and I thought: “Hmmm… it must be like this surely...
Product: Dataease [{8}]FIVE. Written by DataEase 07/01/16 at 12:59:47
Issues with @DFDDQLPrism using DEOS
I have been bringing across procedures from a DFD 5.15i system using @DFDDQLPrism most of which have outputs. While the procedures themselves appear to come across fine the format of the output rarely come...
Product: Dataease [{8}]FIVE. Written by Rob Birney 10/03/16 at 10:56:38
Re:Issues with @DFDDQLPrism using DEOS
Hi Rob.You are correct. The problem is that the format in DFD.As this is "ancient" stuff it doesn't always fall the way we would think today. Our assumption when we started this project was that the DFD files would contain...
Product: Dataease [{8}]FIVE. Written by DataEase 10/03/16 at 12:44:17
DEOS and Documentopen
I seem to be having issues getting DEOS and DocumentOpen to work how I assume they are supposed to!I have set this up on a simple button to test:setvar("VFile",DEOS("@Browseforfile","u:","*.pdf")) + alert(getvar("VFile")) + DocumentOpen...
Product: DataEase 9 Developer. Written by Paul Cheeseman 17/02/23 at 13:21:53
On the blog about DEOS
DataEase 8.5 - DataEase DQL migrate feature of DEOS() completed (Ver 8.5.0.1996)
The DataEase for DOS REPOxAAA.DBm and .DBR browsing and readout feature of Get() is completed.DEOS("@KEYWORD","Argument","Argument","MemoArgument","MemoArgument")DEOS("@DFDDQLNr","C:\MyApp\REPOxAAA.DBM") -- Read the number of DQL's in a...
Product: Dataease [{8}]FIVE. Written by DataEase 01/12/15 at 15:04:28
DataEase 8.5.0.2275 - Big DEOS Update Added DEOS function @zip, @unzip, @CopyDirectory, @CopyFile, @CreateDirectory, @DeleteDirectory, @DeleteFile, @DirectoryEmpty, @DirectoryExists, @FileExists, @BrowseForFile and @BrowseForFolder
There has been a number of CDFs etc for dealing with finding files etc in DFW.CDF's are well and good but important functions like this should be dealt with by DataEase directly.In 2275 we have included the following DEOS fu...
Product: Dataease [{8}]FIVE. Written by DataEase 15/07/16 at 16:04:24
DataEase 8.5.0.2450 - Command to create shortcuts and pin/unpin them to Taskbar, Start Menu, Desktop added to DEOS
We made a pledge when we started redeveloping DataEase that we would use DataEase for everything including making DataEase in it.
And we have stood by it. Where previous owners have used DataEase very little with the excuse that it didn't...
Product: Dataease [{8}]FIVE. Written by DataEase 05/08/16 at 20:54:28
