Blog

How to subtract a number of working days from a date field

Version:  (DataEase DOS or Windows) and Ffenics

The first step is to deduct the number of days to the original date.
OrigDate - WorkingDays
Next the number of weekends need to be derived, simply by dividing the number of WorkingDays by the number of working days in a week, rounded down to get rid of decimal place and then multiplying that by the number of days in weekend.
floor ( WorkingDays / 5 ) * 2
Finally, we need to ensure that the resulting date is not a weekend. Do this by getting the remainder of the WorkingDays divided by the number of days in a week, deducting that from the original date and if that is a weekend, include the number of days in a weekend into the calculation.
if ( weekday ( OrigDate - mod ( WorkingDays , 5 ) ) > 5 , 2  , 0  )
The completed field derivation is:
OrigDate - WorkingDays -
floor ( WorkingDays / 5 ) * 2 )
if ( weekday ( OrigDate - mod ( WorkingDays , 5 ) ) > 5 , 2 , 0 )

 

DataEase and Ffenics - How to Export to a Variable Filename

TestVariableCTRL
Define Global "gFilename" ;   Text 255 .
GFilename := data-entry EnterFilename .
run procedure "TestVariableExp2" .

TestVariableExp2.
define global "GFilename"   Text 255 .
for COUNTRYSETUP ;
list records
CountryCode in order ;
Country .
end
export to GFilename .
CountryCode,Country
.items
@f[1,1],@f[1,2]
.end

DataEase and Ffenics - Performing Dynamic Validations

This script demonstrates how the PostEdit Event can be used to perform dynamic validation, by automatically testing values as they are typed in by the user. This example script rejects any input which contains spaces in the value.

Note that if you want to accept their typing you say return(1) ( or 0 would do ) but if you want to reject their input, re-instating the original contents type return(2).

In a fields script choose the PostEdit event and put...

if textpos( string , " " ) > 0 then
message "Please re-enter without using spaces" window .
return(2) . -- failure of input to satisfy
else
return(1) . -- acceptable input
end

This script uses the passed parameter for the postedit event which is "string" .

This contains the incoming value entered by the user, whereas the Value property of the field still contains the original contents.

Provided by Simon Irwin    (DataEase Consultant)

DataEase 8.5 Functions Manual

DataEase 8.5 Functions List for Build 1767 (Beta) DataEase85FunctionsManual

DataEase for DOS 5.x Features (Search Mode)

Notes contains operating instructions and technical background to the new features introduced in DataEase for DOS 5.x. DataEase DFD 5xx Search Mode

DataEase and Ffenics Custom Defined Functions Guide (CDF's)

This PDF file contains a guide to the CDF functions originally supplied with DataEase and Ffenics. CustomDefinedFunctionsGuide

DataEase 7 User Guides

For copies of  DataEase 7.2 Designer's Guide and Help File, please email us at info@dataconsultancy.co.uk

DataEase 6 - 6.53 DQL Programmer's Guide

The DataEase Query Language (DQL) extends the data processing and reporting capabilities of DataEase far beyond those of a standard form or report. In addition to letting you list, modify, and delete selected records, DQL lets you:

Create batch processing procedures to enter, modify, or delete sets of records instead of processing each record individually as changes are made in User View.

Use a special Data-entry form L to collect selection criteria, processing instructions, and other user input each time a procedure is run.

Monitor the entry of new records and determine how each record is processed depending on its field value.

Use global variables to pass values from one DQL Procedure to another.

Call and chain together menuscall_menu, forms, reports, other DQL Procedures - even other programs - and link these actions together into a single automated Control procedure.

Who Should Read this Book This book is written for professional application designers, system administrators, and experienced users who want to create DQL programs to extend the power of their applications. If you are not familiar with DataEase, we recommend that you begin by performing the handson lessons in the DataEase Quick Start Guide (QSG).

If you are responsible for designing custom applications, you'll find reference information on creating tables, forms, reports, and menus, defining relationships, and other database design guidelines in the DataEase Designer's Guide (DG).

If you use an application designed by someone else, you'll find all the information you need in the companion volume, DataEase User's Guide (UG).

Before you begin working with DQL, we recommend that you read the DataEase User's Guide (UG) and Designer's Guide (DG) and become thoroughly familiar with DataEase record entry and document creation operations.

DQLProgrammer'sGuide  

DataEase and Ffenics OML Scripting Guide

These guides can also be used for Ffenics as well as DataEase. Up to and including DataEase 6.53 OMLScriptingGuide DataEase 7.2 OML Scripting Guide

MASTERING CDFS WITH DFW

CDFs are the icing on the cake of the DfW user interface. With them you can often provide that extra control. Whilst it could be argued that DfW still lacks a scripting language with the power of NetPlus's ScaleScript, CDFs can be made to go a long way towards filling that needed. CDFs.pdf

STRANGE MONTHS

We need to run a report showing data from last month’s second Monday until the day before this month’s second Monday. The time range from the first month’s second Monday to the next month’s second Monday is entered via a data-entry form. I want to run the report for an entire year, but can’t work out the right DQL to group the data from each month’s second Monday until the day before next month’s second Monday. Click on link below to read more Strangemonths

DataEase for Dos - How to capture a printer port on NT Network

Command (not to re-capture on login) net use Lpt1 servernameprintersharedname Command (to re-capture on login) net use Lpt1 servernameprintersharedname /persistent:yes Undo Command : net use Lpt1 /del

A User's View of DataEase

Welcome to the DataEase User's Guide. This guide explains how to start DataEase and sign on to a custom application, open previously designed record entry forms, view records, print reports, and use the following special features: , Application Catalog , Toolbar , Query By Form (QBF) , Query By Model (QBM) , DataEase Multiforms , Command Buttons , Custom Menus , Dynamic Data Exchange (DDE) , Object Linking and Embedding (OLE) , Transparent SQL Connectivity This documentation includes an introduction to the DataEase graphical user interface, special guidelines for using DataEase in a Client-server environment, and reference information for all data entry, record searching, database administration, and routine maintenance tasks that the users of an application need to understand. DataEaseUser'sGuide

DataEase 6.5 - Opening up DataEase to the World

The article covers the following topics:- Data access mechanisms employed in the previous versions of DataEase (versions prior to 6.5) and their limitations OLE DB The benefits OLE DB brings up to DataEase users The new scripting features and practical examples of how customers will be using these features in real situations WebPublisher 2 as a means of opening DataEase databases to the Internet world Summary DataEase 6.5

Dialogue Techanical Tips

Export Data From Old Style Memo Fields, Named Relationships, Undelete with JADA, Application Objects, Dialogue Technical Tips 1

DataEase and Ffenics Development

If you are thinking of redeveloping your DataEase DOS application or upgrading your existing DataEase for Windows database then we can help by providing you with a free audit service and impartial advice. Our Audit report will also provide an estimate of time and costs involved for us to perform this work and deliver a modern and streamlined application in either DataEase of Ffenics. All development work is carried out in the UK by consultants with experience in many industries. Development costs can be spread over an agreed fixed period makingthe project more affordable. Download our leaflet for more details.

Leaflet covers version DFW 6.0 - 8.0 and all versions of Ffenics DataEase & Ffenics Development

Installer for DataEase

Installer for DataEase is distributed free with DataEase 7.1 onwards, if you would like any help or assistance in installing the application then please do not hesitate to contact us at  techsupport@dataconsultancy.co.uk  Installer for DataEase Readme file   DataEase Installer Readme

Installer for Ffenics

Installer is a set of forms and procedures that once installed into a Ffenics application will allow a Developer to create install files (DIW Files) from a pick list. Installer for Ffenics acts as a Database within a Database and will also allow you to create selective data export files from the System Relationships and External Functions (ELF) forms. Available to purchase from the link below www.dataconsultancy.co.uk/shop.html Download the Readme file for more information (Now also includes Ffenics 2) :- Ffenics Installer Readme