Archive for the ‘DataEase/Ffenics Tips’ Category

DataEase and Ffenics – Performing Dynamic Validations

Tuesday, May 26th, 2015

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
return(1) . — acceptable input

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 and Ffenics OML Scripting Guide

Sunday, November 30th, 2014

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


Saturday, October 11th, 2014

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.



Saturday, October 11th, 2014

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


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

Saturday, October 11th, 2014

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

Dialogue Techanical Tips

Saturday, June 7th, 2014

Export Data From Old Style Memo Fields,

Named Relationships,

Undelete with JADA,

Application Objects,

Dialogue Technical Tips 1