Easy to Create, Easy to Change - Easy to use!

Support::

with



Parameters


Returns/Result


Examples


Reference

with

Type

Operator

Purpose

The with operator specifies the criteria for selecting records in a table or a relationship.

Syntax

with ( SELECTION CRITERIA)

Usage

The with operator tells DataEase to process some rather than all the records in the specified table. The records that are selected for processing are those that satisfy the selection criteria that follow the with operator.

Example 1

for MEMBERS with TOTAL DUE > 150 ;

This statement tells DataEase to process only those MEMBERS records that contain a value greater than $150 in the TOTAL DUE field.

Example 2

delete records in RESERVATIONS named "OUTDATED"

 with ( DATE < 01/01/99) .

 

This statement tells DataEase to delete the records in the "OUTDATED" relationship (the RESERVATIONS records that are dated before 01/01/1999).

See Also


On the forum about with

Networking with DataEase 6.53

I am trying DataEase 6.53 in a network but don´t work. I copy the files configur.dat and denetwork.ovl for the FULL locking strategy but I have not any locking. I look in Preferences - Locking and I have a double mark in Lock nothing and Lock files in...

Product: LegEasy 6 Windows. Written by Carlos Ruiz 08/10/12 at 00:09:03

Re:Networking with DataEase 6.53

Hi Carlos. Have you set the DEPATH correctly? The easiest way to do this is to start Dataease.exe via a bat file and include the DEPATH and DENAME in the bat file. Quote from our website "In the Program catalogue of 6.53 you will find a catalog called...

Product: LegEasy 6 Windows. Written by DataEase 08/10/12 at 06:12:43

Re:Re:Networking with DataEase 6.53

I´am working with dataease since 1980 and before upgrade I need to be sure about the work of the "new" version But let me insist: After copy the configur.dat I look at Preferences - Locking and I have the double mark in Lock nothing and in Lock files op...

Product: LegEasy 6 Windows. Written by Carlos Ruiz 10/10/12 at 05:22:34

Re:Re:Re:Networking with DataEase 6.53

Hi again Carloz. If your Locking screen doesn't show up with a Locking strategy, there is only to possible explainations: 1. That the configur.dat copied to the shared catalogue pointed to at the server by DEPATH environment variable, is the wrong one...

Product: LegEasy 6 Windows. Written by DataEase 10/10/12 at 07:47:06

files with extension. ERa

we have a database in version 7.2.3.947 DataEase and create files with extension. ERa...

Product: . Written by wilmer raul contreras riaño 11/10/12 at 23:43:44

Re:Re:Re:Re:Networking with DataEase 6.53

I did a new test: Windows server 2008, with the new DataEase 6.53 and Dataease 6.52 All stations via Terminal Server Depath and Dename via a .bat file with the configur.dat for the new version DataEase 6.52 it´s in the Denetwrk.ovl and all locks are OK...

Product: LegEasy 6 Windows. Written by Carlos Ruiz 29/10/12 at 01:39:16

Re:Re:Re:Re:Re:Networking with DataEase 6.53

Dear Carlos. I am very sorry, I didn't realise that you were trying to test this with the demo version. I thought you had a Network version. The demo version is set up to only run as a Single User. It is a demo of the functionality in DataEase for "new"...

Product: LegEasy 6 Windows. Written by DataEase 29/10/12 at 05:39:49

Problems with Export, Upgrading from 7.2 and DataEase 8 Exec.

• Currently I have a procedure to export data from a table with the following code for detalle-Prestamos ; list records Pretamo_Numero ; Fecha_cobro ; LlaveItems ; Valor_abono . end export to "D:\Detalle.txt" . .form header .items @f[1,1], @f[1,2], @f[1...

Product: DataEase for Windows 7.x. Written by diego fernando ocampo gomez 29/10/12 at 20:14:58

Re:Problems with Export, Upgrading from 7.2 and DataEase 8 Exec.

1. Problem with Export. http://www.dataease.com/dg3_SearchHelp/?PageID=10066 Example 3 for MEMBERS ; list records MEMBERID in order ; CARDNO. ; TOTALDUE . end export to "MEMBDATA.TXT" . .form header .items @f[1,1,5]@f[1,2,20]@f[1,3,7] .end This example...

Product: DataEase for Windows 7.x. Written by DataEase 29/10/12 at 20:23:06

Re:Re:Re:Re:Re:Re:Networking with DataEase 6.53

OK, let me see but as you say in the main page of the doewloads, this it´s a "FREE DEMO! Same as Full verson........." Also let me tell you, with the last version I have problems with the "fake virus detection"....

Product: LegEasy 6 Windows. Written by Carlos Ruiz 30/10/12 at 00:09:25

Re:Re:Re:Re:Re:Re:Re:Networking with DataEase 6.53

Fair point Carlos. Victim of the copy and paste ghost. It is now corrected and it states that Demo is limited to 30 records and NO Network support. However, I think that it shouldn't be. On my initiative we changed from the same limited demo as 6.53 in...

Product: LegEasy 6 Windows. Written by DataEase 30/10/12 at 04:44:54

migration from 7.23 what issues with DQL, OML scripts; choice lists

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by Edward Gordley 23/12/12 at 00:07:12

Re:migration from 7.23 what issues with DQL, OML scripts

There is no issues with either of these things in moving from 7.2.x to 8.x.Moving from 7.2x to 8.0 is not a migration, it is a transition. Everything will work as before but you get a lot of new functionality. Migration doesn't work as it impl...

Product: Dataease [{8}]FIVE. Written by DataEase Support 23/12/12 at 18:54:30

Re:Re:migration from 7.23 what issues with DQL, OML scripts

Will it run faster on in a network environment; What is the target license cost for a deployable copy of an application?...

Product: Dataease [{8}]FIVE. Written by Edward Gordley 29/12/12 at 01:27:41

Re:Re:Re:migration from 7.23 what issues with DQL, OML scripts

Hi again. DataEase 8 will run slightly faster than 7.2 in any environment and it will run faster on a network but that is simply because we have tweaked the default settings.&nbsp;There is no change in Network handling in 8.0 compared to 7.2 b...

Product: Dataease [{8}]FIVE. Written by DataEase Licesning 29/12/12 at 12:18:47

Setting up ODBC Link erroring with IM002 No Default ODBC Driver Found!

Hi I have set up a User and System DSN in Control Panel for our SQL Server and tested the connection and it works fine, but When I try and create a link in DE8 I get the above error everytime, I have tried the Link Name the same as my DB and the serve...

Product: Dataease [{8}]FIVE. Written by Qualtex 03/04/13 at 12:25:09

Re:Setting up ODBC Link erroring with IM002 No Default ODBC Driver Found!

Hi, Firstly. Which version of SQL server are you using. We have tested 2000 / 2005 /2008 /2012 versions of sql server... the only difference is the client that is used by the odbcThe client s...

Product: Dataease [{8}]FIVE. Written by DataEase 08/04/13 at 10:15:44

Re:Re:Setting up ODBC Link erroring with IM002 No Default ODBC Driver Found!

Hi - I am using SQL 2008 R2, in control panel, system and security, administrative tools, data sources I have setup System DSN called T21Live (Sql Server) and tested the link which connects to the database correctly, I have then tested the link again...

Product: Dataease [{8}]FIVE. Written by Qualtex 16/04/13 at 08:33:31

Re:Re:Re:Setting up ODBC Link erroring with IM002 No Default ODBC Driver Found!

Hi I have now sorted this problem out....

Product: Dataease [{8}]FIVE. Written by Qualtex 22/04/13 at 11:00:53

Help with problem

Hi,&nbsp;I'm not a proffesional developer, only do inhouse, is there anyone out there who could help me solve a few problems.I need to send my application to some one who can go over it and resolve a issue I have.Happy to pay....

Product: DataEase for Windows 7.x. Written by Gregor Popp 20/06/13 at 20:57:18

Re:Help with problem

Hi IonPlease give me a call on 01332-855005 to discuss your problem....

Product: DataEase for Windows 7.x. Written by Peter Birney, PB Associates 21/06/13 at 07:07:45

Re:Re:Help with problem

hiMore than happy to help you out.Email me on info@ajcsoftware.comKind regardsJosef...

Product: DataEase for Windows 7.x. Written by Josef Vella 22/06/13 at 16:37:02

Re:Re:Re:Help with problem

Hi IonSorry, I did not realise that you were not in the UK - You can contact me on pete@pb-associates.co.uk if you wish,Peter...

Product: DataEase for Windows 7.x. Written by Peter Birney, PB Associates 03/07/13 at 12:59:34

SetState Problems working with choice field

Using SetState works perfectly using the following where the field test is a Yes/No fieldif (test = Yes, SetState("Field",3),SetState("Field",0))I can make all the 0,1,2,3 options all work in the above formular.<...

Product: Dataease [{8}]FIVE. Written by Graham Brown 17/07/13 at 17:48:28

Re:SetState Problems working with choice field

Download SampleHi again.1. SetState switch 3 and 0 is not a pair. 0=will hide the field and 3 will enable it, but 3 will not show it.The m...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Support 18/07/13 at 08:21:39

Re:Re:SetState Problems working with choice field

Thank you.In an if statement what is the order for combining:&nbsp;If (setstate("field",0) &amp; Set(colour( ) &nbsp;...

Product: Dataease [{8}]FIVE. Written by Graham Brown 18/07/13 at 14:14:45

Re:Re:Re:SetState Problems working with choice field

The brilliance of functions is that you can call them in any way you like as long as they get triggered ;-)Of new functions in DE8 we try to give no return (empty string) if they are made to "do a job" rather than the normal function stuff of...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Support 18/07/13 at 16:01:49

Re:Re:Re:SetState Problems working with choice field

Hi again Graham.We have problems replying to your emails. We only get the following message after days of retries:This message was created automatically by mail delivery software. A message that you sent could not be deli...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Support 22/07/13 at 13:20:59

Problem with GetGlobal / SetGlobal functions while checking procedure .

See below &nbsp;an example :....................................... .................................. ................................ ...........................

Product: Dataease [{8}]FIVE. Written by Luca 31/07/13 at 13:21:39

Re:Problem with GetGlobal / SetGlobal functions while checking procedure .

Hmmm… This is a little headache. SetGlobal(), GetGlobal() is an internal function now not a CDF. And it is defined with “names” rather than numbers to make it more useful. SetGlobal(“MyVar”,MyValue) GetGloba...

Product: Dataease [{8}]FIVE. Written by DataEase 31/07/13 at 13:23:50

Re:Re:Problem with GetGlobal / SetGlobal functions while checking procedure .

It's not a good idea to change how existing functions, etc, work, especially with such a commonly used function as this one.Could you not have given the internal version of this function a different name? e.g. GetVariable, or GetVar.Ther...

Product: Dataease [{8}]FIVE. Written by Adrian Jones 02/08/13 at 14:04:19

Re:Re:Re:Problem with GetGlobal / SetGlobal functions while checking procedure .

Very good point Adrian and the time to correct it is now and the new name is GetVar()/SetVar().Luckily this is the only one, was worse when hole functionality was replaced like the Old Memo with the New memo or Lookup fields with Multi...

Product: Dataease [{8}]FIVE. Written by DataEase 02/08/13 at 14:34:42

Re:Re:Re:Problem with GetGlobal / SetGlobal functions while checking procedure .

You can of course still use numbers and loop through them if that is what you want as DataEase automatically converts numbers to text when you use a variable, so in that use case there will be no difference....

Product: Dataease [{8}]FIVE. Written by DataEase 05/08/13 at 13:40:19

Re:Problem with GetGlobal / SetGlobal functions while checking procedure .

SetGlobal()/GetGlobal() are now renamed to SetVar() and GetVar().You can now use the old CDF and the new functions in parallel.If you have used the the new internal format for SetGlobal()/GetGlobal() you will have to rename them in your...

Product: Dataease [{8}]FIVE. Written by DataEase 05/08/13 at 13:41:53

Re:Re:Re:Problem with GetGlobal / SetGlobal functions while checking procedure .

Adrian Jones wrote: "There is also an advantage to having the number, as it means you can view the currently used values with a getGlobal ( number ), or with my Looper table of integers with getGlobal ( LoopNo ). Of course, if the...

Product: Dataease [{8}]FIVE. Written by DataEase 01/10/13 at 09:16:45

Fill string to length with blanks

I am creating a txt file using the TextOut and textoutln functio and would just like to know if there is a way to fill a field with blank until its length. Ex: Name (defined text 40) value = "Marco"...

Product: DataEase 6.x. Written by Marco 13/11/13 at 10:32:04

Re:Fill string to length with blanks

These functions are CDFs and there might be CDFs that do this but that is outside our "purview".In DE8 there is internal functions for all of this.http://www.dataease.com/dg3_HelpView/?PageID=13698&field1;=*FixedWidth*http://www.da...

Product: Dataease [{8}]FIVE. Written by DataEase 13/11/13 at 10:32:48

MULTIPLE TABLES WITH SAME NAME CANNOT DELETE

Looks like DataEase 8 is no better than Ffenics.&nbsp; While adding a field to a from which defined a table. I could not save with the error message that the Table already existed.&nbsp; Sure enough when I viewed the table tab there were two tables li...

Product: Dataease [{8}]FIVE. Written by David Fazio 28/01/14 at 05:27:51

Re:MULTIPLE TABLES WITH SAME NAME CANNOT DELETE

Hi David.I don't know which one will be most insulted by that, DataEase or Ffenics ;-)To be fair, this bug is originally a DataEase bug that has been there since the beginning of DFW at least. I don't have any experience with it in Ffe...

Product: Dataease [{8}]FIVE. Written by DataEase 28/01/14 at 09:33:38

Re:MULTIPLE TABLES WITH SAME NAME CANNOT DELETE

Thanks for the Help.&nbsp; I have a backup copy that does not have the issue and will start my revision over.&nbsp; I do like DataEase 8 and look forward to continue promoting the product here in the USA.&nbsp; I was just hoping that this bug that I h...

Product: Dataease [{8}]FIVE. Written by David Fazio 29/01/14 at 15:08:19

Re:Re:MULTIPLE TABLES WITH SAME NAME CANNOT DELETE

Will be soon! We will take some weeks and clean up old sins soon, so they won't get in the way of the share joy which is the new DataEase8 ;-)We did fix this once already in 8.x but it doesn't seem to fix it all the way. We both enabled deleti...

Product: Dataease [{8}]FIVE. Written by DataEase 29/01/14 at 15:33:12

Problem with , Comma as Decimal separator in derivation after migration to 8.1

I write from Italy and we are migrating from 6.52 to 8 and I've a little problem with a derivation that use a comma as decimal separator as follow :(Imponibile * 12,5 / 100) Imponibile&nbsp;#1: Error in parsing derivation for field P...

Product: Dataease [{8}]FIVE. Written by Marco 19/02/14 at 11:26:22

Re:Problem with , Comma as Decimal separator in derivation after migration to 8.1

In DataEase pre 7. the national settings was used in coding too so you would use , in countries like Italy, Norway and . in UK etc.This made applications hard to "transport". If you changed your windows settings the app would stop working etc....

Product: Dataease [{8}]FIVE. Written by DataEase 19/02/14 at 11:50:13

Printing with PDF export

Hello good eveningI currently have the 7.2.3.947 version of DataEase and am generating a list designed in DQL and I will report PDF Export, give the path D: \ cesantias.pdf I generated the following error Could not find DataEase. What I see is...

Product: DataEase for Windows 7.x. Written by diego fernando Ocampo 23/02/14 at 23:28:00

Re:Printing with PDF export

PDF printing only works in x86 versions of Windows. It won't work in X64.Read more here:http://www.dataease.com/DG3_ForumList/?ParentID=0000000573&field1;=0000000573...

Product: DataEase for Windows 7.x. Written by DataEase 24/02/14 at 09:35:39

Calling a ExecDQL from with an ExecDQL

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by 25/03/14 at 12:58:36

Problems when I try to install a table within including data for a table

There are serious problems when you try to install a table from another database (same version 8) checking including data for Table. The installation ends normally but when I try to open the table installed, DataEase crashes and ends with an Access Vi...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 27/03/14 at 14:52:31

Re:Problems when I try to install a table within including data for a table

The problem is Locking.&nbsp;In DE7 and DE8 you can run a Local version of DE with Locking and this is enabled by default in DE8.To be able to install a Table with Data you need to run DE as standalone. The best way to do this is simpl...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 28/03/14 at 18:45:30

Re:Calling a ExecDQL from with an ExecDQL

ExecDQL is just a function so you can simply call it like this.retval := MemoExecDQL(any DQLStore with DQLNr=006,"","","","","") ....

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 28/03/14 at 18:50:56

Re:Re:Problems when I try to install a table within including data for a table

I’ve tried to import a table in standalone mode as suggested ad it’s work fine.But there’s a very serious problem when I try to import a very large table that contains more than 1.500.000 records. (DBM) DataEase crashes with a GPF – Access viol...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 16/04/14 at 14:39:29

Re:Re:Re:Problems when I try to install a table within including data for a table

Problem with import of large tables (.dbm) import has been fiexed in 1533....

Product: Dataease [{8}]FIVE. Written by DataEase 24/04/14 at 11:24:24

DFD 4.53 ... I know ancient , but still running. We moved to Windows 7 (32 bit) and now all the Imports are not showing, it runs without a problem, but it does not show so we can not make any changes ? Any Ideas ?

[@EOF@]...

Product: LegEasy DOS. Written by charmaine smit 19/05/14 at 12:00:10

Re:DFD 4.53 ... I know ancient , but still running. We moved to Windows 7 (32 bit) and now all the Imports are not showing, it runs without a problem, but it does not show so we can not make any changes ? Any Ideas ?

I use DOSBOX ,&nbsp;http://www.dosbox.com/ and it works fine, both in small and full screen.Remember that DFD does not like long file import names, so you might have to rename them to fit that length....

Product: LegEasy DOS. Written by Kensington 20/05/14 at 16:36:04

Setting DEPATH/DENAME in Windows 7/8 without using a bat file.

So we now start Dataease from .bat file – which opens a Command Prompt window – how can we get this to close automatically?...

Product: LegEasy 6 Windows. Written by Rob 28/05/14 at 15:00:38

Re:Setting DEPATH/DENAME in Windows 7/8 without using a bat file.

Even though Autoexec.bat etc. is obsolete in Windows7/8 which is where we used to set these things, you are still able to configure environment variables in Windows.1. Open the Start Menu and right click on <strong style="background-color: ini...

Product: LegEasy 6 Windows. Written by DataEase Tech Sup 28/05/14 at 15:02:46

Problem with Startup.exe

I have just downloaded DataEase 8.2 and is trying to use the Startup.exe to start one of my applications directly from the catalogue.&nbsp;Nothing happens, any idea what is wrong?...

Product: Dataease [{8}]FIVE. Written by Neil Simmons 20/08/14 at 09:46:02

Re:Problem with Startup.exe

Startup.exe depend on paths and environment variables set up at installation of DataEase 8.2. These settings are only done by the FULL version of DataEase 8.2 and only in versions higer than 1594. (8.2.0.1594). If you run an older version of DataEase...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 20/08/14 at 09:55:14

Re:Re:Problem with Startup.exe

I successfully installed on my client the last version of DE8 (8.2.0.1600) recently released.I tried to use the new function “startup” downloading the simple tool for the website.Putting the unzipped file in anyway directory “startup” wo...

Product: Dataease [{8}]FIVE. Written by Marco 20/08/14 at 10:31:49

Re:Re:Re:Problem with Startup.exe

Hi Marco.I am glad that you have both started to play with the new feature and that you give us feedback on its shortcomings ;-)What you see here, Startup.exe and the new release today 1602 with ALWAYS able to switch to Design Mode is th...

Product: Dataease [{8}]FIVE. Written by DataEase 20/08/14 at 11:08:45

Re:Re:Re:Re:Problem with Startup.exe

Download New Startup.exe This version of Startup.exe will handle Application Names with space in them. Simpley but the application name in "" AppName="...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 20/08/14 at 17:23:47

Help with Displaying Instruction / Help message text in a fields

Hey folks - I've seen where DE8 can display an instruction / help message in a field when the field is blank or when the cursor is not in the field. &nbsp;This is not the typical Help message that appears in the bottom Help message display area. &nbsp...

Product: Dataease [{8}]FIVE. Written by dtagcayman@yahoo.com 30/08/14 at 08:05:55

Re:Help with Displaying Instruction / Help message text in a fields

HiTo display a message in the field do as follows:Click on the Help tab withing the field definitionType: &nbsp; &nbsp;&nbsp;...

Product: Dataease [{8}]FIVE. Written by Josef Vella 31/08/14 at 15:30:29

Re:Re:Help with Displaying Instruction / Help message text in a fields

Hi Josef - Your instructions worked Perfectly ! &nbsp; Simple yet effective feature. &nbsp;Now&nbsp;I'm now adding the prompts and it will be a great help for the users.&nbsp;Many thanks!-Robert...

Product: Dataease [{8}]FIVE. Written by dtagcayman@yahoo.com 01/09/14 at 03:56:36

Problem with greyed out features in Exec

One of my customer base is using DataEase Exec 8.2.0.1619.Issue they were having is, unable to export from QBM. It is greyed out.But, if they login with Full version, then they can export. Is there any workaround for this?<img src...

Product: Dataease [{8}]FIVE. Written by Arul 02/09/14 at 15:26:17

Re:Problem with greyed out features in Exec

The point with runtime is to stop users from doing things the developer don’t want them to do.&nbsp;To export the entire content of the application is one of these things that need to be addressed.&nbsp;There is no limitation to what a developer can a...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 02/09/14 at 16:06:09

Re:Problem with greyed out features in Exec

Hi&nbsp;Normally I do a button - Data Export - with do not print property ticked.This should work.regardsJOsef...

Product: Dataease [{8}]FIVE. Written by Josef Vella 02/09/14 at 16:08:29

Reading/Sharing data with other applications

It's very important and useful for us to share some particular DataEase tables between our various databases. I don’t know if I have to use ODBC or other things using version 8 of DataEase and don’t even know how to use it properly. Could you kindly s...

Product: Dataease [{8}]FIVE. Written by Marco 03/09/14 at 13:50:39

Re:Reading/Sharing data with other applications

DataEase sharing of data has not been high on any lists for a long time. It used to be quite good in 4.53 and Express but after that I think it went down the wrong direction. Obviously reading DataEase data from other systems have been even...

Product: Dataease [{8}]FIVE. Written by DataEase 03/09/14 at 14:53:25

Re:Reading/Sharing data with other applications

HI MarcoYou can share data by doing import &nbsp;/ export between the various databases.regardsJosef...

Product: Dataease [{8}]FIVE. Written by Josef Vella 04/09/14 at 05:22:40

Slow calculations on 2011 Small Business Sever with using SMB2

DataEase 8.2I have a DataBase that contains a CashBook with @200,000 recordsIn the cashbook there are two fields Credit &amp; DebitsWithin a Form I have two lookup fields linked by relationships that need to calculate <e...

Product: Dataease [{8}]FIVE. Written by 17/10/14 at 12:15:23

Re:Slow calculations on 2011 Small Business Sever with using SMB2

It is hard to diagnose this without sitting on top of the problem.For a very long time it was a speciality of DataEase support to work on the notion of conflicts, registry settings, patching and wizardry&hellip; I used to work on DataEase suppo...

Product: Dataease [{8}]FIVE. Written by DataEase 20/10/14 at 19:10:12

Re:Re:Slow calculations on 2011 Small Business Sever with using SMB2

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by Graham Brown 22/10/14 at 13:28:50

DE8 with Windows OneDrive

Greetings All - Has anyone tested using a DE8 application that has it's&nbsp;files stored on a&nbsp;Microsoft OneDrive storage space&nbsp;that resides in the cloud? &nbsp;I've been using a DE8 application with this setup and I've had no issues thus fa...

Product: Dataease [{8}]FIVE. Written by dtagcayman@yahoo.com 24/10/14 at 08:53:18

Re:DE8 with Windows OneDrive

Hi Robert.It should definitely work fine as long as you are using it as a single user. We do this to on shared developments as it is very practical to have the latest updates available for all the involved developers. However we make sure that...

Product: Dataease [{8}]FIVE. Written by DataEase 28/10/14 at 07:41:38

Problem with Importing/Installing Table with Form in ver. 8.2.0.1679

Suddnly version 8.2.0.1679 is blocking the TDF file during import from another Database (Install). You no longer get the option of installing the table.arvid...

Product: Dataease [{8}]FIVE. Written by Arvid 14/11/14 at 12:07:54

Re:Problem with Importing/Installing Table with Form in ver. 8.2.0.1679

We have just tested this and it works "fine".We suspect that the problem is not really related to DE 8.2.0.1679 but a general problem with Installing Forms with Tables (TDF) and Data (DBM).When you select a Document during install it w...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup. 14/11/14 at 12:09:57

Sample Application with Build 8.2.0.1700

Just download the&nbsp;trial version&nbsp;to try of course.&nbsp;Tried to open sample given (Customer Relations) using provided username and password but won't let me go through, giving me an error message of invalid username/password. Am I doing some...

Product: Dataease [{8}]FIVE. Written by Ruben 30/12/14 at 18:56:35

Re:Sample Application with Build 8.2.0.1700

Just tested and the user names are as follows:Username: UserPassword: UserAlternatively:High/High...

Product: Dataease [{8}]FIVE. Written by DataEase 31/12/14 at 13:28:04

Help with email applications

Hi,Would it be possible for the function descriptions to be updated to reflect the latest version of DE8? Referring to your sample applications:CRM uses the email client "send" which is documented, but the Emailing and PDF applica...

Product: Dataease [{8}]FIVE. Written by Bill Nicholson 01/01/15 at 09:18:40

Re:Help with email applications

Correction to my last post. The function SendEmail is documented on the main help page (posted on 21/11/14), but it doesn't appear with the list of functions which is why I couldn't find it. It will help massively when the promised documentation is re...

Product: Dataease [{8}]FIVE. Written by Bill Nicholson 02/01/15 at 07:38:24

Re:Re:Help with email applications

Hi Bill.SendEmail and HTMLtoPDF aren't strictly speaking functions as they are External Programs called from Execute File rather than Execute Function/Derivation.&nbsp;However this is very technical and it is better that people find th...

Product: Dataease [{8}]FIVE. Written by DataEase 02/01/15 at 14:41:07

Re:Re:Re:Help with email applications

Very helpful, thanks. Finding those buttons was like&nbsp;the proverbial&nbsp;needle in a haystack. Bill...

Product: Dataease [{8}]FIVE. Written by Bill Nicholson 02/01/15 at 17:25:35

data manipluation from within a form.

Well i have now taken the plunge and bought 8.2 and am now trying to learn new ways of doing things.I have history fields and an OML on a button, which copies field B to field C, then field A to field B, then what i've entered in a field to fie...

Product: Dataease [{8}]FIVE. Written by Simon B 19/01/15 at 16:33:14

Re:data manipluation from within a form.

SetValue() is a GUI function to it use the object name i.e the name of the GUI object rather than the field (column) name.SetValue(hist_s3,hist_s2) basically set the string value of hist_s2 into the GUI object named in hist_s3 and as there is...

Product: Dataease [{8}]FIVE. Written by DataEase 19/01/15 at 22:40:36

Re:Re:data manipluation from within a form.

There is a fundamental difference between PRISM (TDF) and GUI (FRM).PRISM is traditional DataEase where you work on column names, multi-views and data sets. Here you work horizontal on the data as a database.GUI is basically the curren...

Product: Dataease [{8}]FIVE. Written by DataEase 20/01/15 at 08:36:51

Re:Re:Re:data manipluation from within a form.

My field names are the same as there object names, the reason dataease had a field name AND an object name was never explained back in datease 3.12 or something and as such I don't know why there are 2 names to deine an object so I always keep them th...

Product: Dataease [{8}]FIVE. Written by Simon B 20/01/15 at 09:24:34

Re:Re:Re:Re:data manipluation from within a form.

Create a sample app with the code you are trying to do, and upload it.That way we know we talk about the same thing. 99% of the times when customers are persistent that they haven't done something wrong, they have but can't see it because they...

Product: Dataease [{8}]FIVE. Written by DataEase 20/01/15 at 18:14:34

Re:Re:Re:Re:Re:data manipluation from within a form.

Simon,On the face of it your code should work. The only thought I have is that the desired changes may have taken place but not displayed on the screen so a RecordSave() or RefreshScreen() might help.I detect the signs of frustration tha...

Product: Dataease [{8}]FIVE. Written by Bill Nicholson 21/01/15 at 07:44:08

Re:Re:Re:Re:Re:Re:data manipluation from within a form.

Thank you both :)&nbsp; I'm pretty much folllowing the rules but Bill you found the problem straight off.&nbsp; RecordSave() needed to be adding.&nbsp; DataEase did the change but didn't think i needed to see it, only once the existing record was save...

Product: Dataease [{8}]FIVE. Written by Simon B 21/01/15 at 09:15:49

Re:Re:Re:Re:Re:Re:Re:data manipluation from within a form.

Hi Simon!It is still a BUG, it is just the paternity we are disputing ;-)RefreshForm() will refresh the GUI objects without hitting on the database, so any manipulation done in the form that is not yet saved etc, will be refreshed. Thi...

Product: Dataease [{8}]FIVE. Written by DataEase 21/01/15 at 10:01:18

Solution:How to align data on the right on a text field with FixedWidth() and StringTo().

Download Sample Thank you for giving us such a brilliant opportunity to show of some of the new and sadly not so well known functions in...

Product: Dataease [{8}]FIVE. Written by DataEase 13/02/15 at 18:13:40

Error message when trying to save DQL with .export

I have simple procedure that works both in Dataease for Dos and DEW 7.2. I have converted a customer database from 7.2 to 8.5 and get the following error. The procedure reads: for Subsriptions with Internet ID No. not = blank and any Customer...

Product: Dataease [{8}]FIVE. Written by Wim 19/02/15 at 09:03:19

Re:Error message when trying to save DQL with .export

Dear Wim.When you get a GPF on something like this the problem is most likely in the underlying table, as this happens when you compile/save the DQL it is most likely in the table structure. Try to open the table in design mode, add a text fiel...

Product: Dataease [{8}]FIVE. Written by DataEase 19/02/15 at 09:06:21

DE8 compatible with Windows 7? Running 6.52 application in DE8

It DataEase 8.0 Is compatible with Windows 7 and later? Can run application&nbsp;developed Datataease DataEase 6.52 to 8.0? Same question for DataEase version in Spanish Thanks....

Product: Dataease [{8}]FIVE. Written by Luis Fernando 21/02/15 at 10:47:32

Re:Re:Error message when trying to save DQL with .export

I have tried as suggested and&nbsp;added a text&nbsp;field in the table but when I try to save it as suggested it returns "Error 503 Adding Field - Missing operator in formula" . I have tried this several time but each time I get the same message.&nbs...

Product: Dataease [{8}]FIVE. Written by Wim von der Becke 23/02/15 at 11:06:42

Re:Re:Re:Error message when trying to save DQL with .export

It sounds like the problem is in you exiting table. Is this a migrated or converted table?If there is a pre-existing problem then it will typically GPF.If it is a migrated app it can be related to , or . in numbers in derivations etc....

Product: Dataease [{8}]FIVE. Written by DataEase 23/02/15 at 11:18:40

Re:Solution:How to align data on the right on a text field with FixedWidth() and StringTo().

Great! It works well. I have another questiom. I have to format a field in this way "000000000.00" in a fixed text field within a length 12 char (padded with zeroes) . The input field is simply a number with 2 decimals. Take in mind that I'm in Italy...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 27/02/15 at 09:53:56

export table in a TXT with fixed length

Hi DataEase, we have a problem when we try to export a file into a TXT file that MUST have a fixed length. It means that each fields of the output record have a specific length. It happens that sometimes on some fields DataEase does not respect the le...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 02/03/15 at 10:49:58

Re:export table in a TXT with fixed length

We are sorry but this is not something that we can test or check out. We take your word for it, but this DQL is pushing the envelop for this functionality....

Product: Dataease [{8}]FIVE. Written by DataEase 02/03/15 at 14:16:23

Re:export table in a TXT with fixed length

Sounds like you have a bug carried over from and introduced in DataEase 7, it's the reason I have 7 databases still on dataease 6.52.&nbsp; The bug was reported but the old dataease team ignored it.I've not tried it yet in 8 as so far i've just...

Product: Dataease [{8}]FIVE. Written by Simon B 02/03/15 at 14:30:06

On the blog about with

DataEase 8 Default Template - Document Editor with Mail Merging and Formatted Printing (Ver. 8.0.0.1230)

The Default Template in DataEase 8 Pre-Release has been updated with a small example that show how you can build documents with Memo functions, Merge in field information, edit the document in WYSIWYG editor and finally print document properly formatt...

Product: Dataease [{8}]FIVE. Written by DataEase 22/02/13 at 10:03:19

DataEase 8 - Memo Update. Scrolling with Mouse wheel in Memo fields (Ver 8.0.0.1257)

We have no further updated Memo field so you will be able to scroll the content of a memo field with the Mouse Wheel.The rules are now as follows. (when field have focus)1. Memo and Multi-line fields. Scrolling content of field. Form s...

Product: Dataease [{8}]FIVE. Written by DataEase 27/03/13 at 09:16:46

New function in 8 - MemoMemoReplace() - Replace a tag with the content of a Memo (Ver 8.0.0.1282)

This is the&nbsp;complementary&nbsp;function of MemoReplace() which replace a tag in a Memo with the content of a string(255) or any other "normal" prism field/value.The exciting bit about MemoMemoReplace() is that you can replace any tag with...

Product: Dataease [{8}]FIVE. Written by DataEase 08/05/13 at 13:46:40

New Sample - Data Export in DQL, ExecDQL and with DataExport() explained!

Download SampleIt is no secret that data export which used to be so easy and natural in DFD has been a nightmare in DFW. Especially the DQL export.If you do a...

Product: Dataease [{8}]FIVE. Written by DataEase 25/07/13 at 18:24:45

Sample in DE8 - Print to PDF with Filename

Download Sample We made a small sample to show how to do this some time back, but I think it was so long ago that it was not published on this forum... ...

Product: Dataease [{8}]FIVE. Written by DataEase 10/09/13 at 08:13:12

New Sample - DQL with no output and the superiority of ExecDQL over traditonal DQL... You won't believe it!

Download Sample If you are just looking for a way to "fool" DataEase into not generating any visual output there is several ways, just remember that all...

Product: Dataease [{8}]FIVE. Written by DataEase 16/09/13 at 13:31:43

How to extend user with field from a DataEase table in DG3

In the current version of DG3, we use a special table for users and authentication. It is not the table used in DfW, but a completely separate entity to satisfy the need of session and group security on the web. The build in DG3 user table contains...

Product: DataEase Generation 3. Written by DataEase Development 19/11/13 at 19:11:04

DataEase 8.2 - GetCurrent updated with a lot of new features (Ver. 8.2.0.1665)

Download Sample GetCurrent() is our "jack of all trades" where we add useful info features. It already return RowNumber, RecordNumber, File positions etc.<...

Product: Dataease [{8}]FIVE. Written by DataEase 11/11/14 at 18:02:50

DataEase 8.2 - ObjectName/FieldName synchronization with copying (Ver. 8.2.0.1666)

Since the implementation of Object Names there has been a peculiarity when copying a field.&nbsp;The peculiarity is that when you copy the the field name Field the new Copy will be named Field2 when the new Object Name will be Field1.&nbsp;<br...

Product: Dataease [{8}]FIVE. Written by DataEase 11/11/14 at 22:34:46

DataEase 8.2 - ExitDataEase("Silent") now with Silent option (Ver. 8.2.0.1679)

When running DataEase as a scheduled process it is nice to be able to quite DataEase altogether after it has been run.The way of doing this has been to use KeyStrokes() cdf to send keystrokes to the process after running ExitDataEase() function...

Product: Dataease [{8}]FIVE. Written by DataEase 11/11/14 at 22:42:03

DataEase 7.x and 8.x - Problems and Workaround for Installing Form with Table and Data.

We have just tested this and it works "fine".We suspect that the problem is not really related to DE 8.2.0.1679 but a general problem with Installing Forms with Tables (TDF) and Data (DBM).When you select a Document during install it w...

Product: Dataease [{8}]FIVE. Written by DataEase 14/11/14 at 12:40:33

Using DE8.2 Emailing with GMAIL

If you are going to use DE8.2 together with GMAIL you need to change the security settings of GMAIL.GMAIL is configured by default only to be accessible (SMTP) to only accept connections from GOOGLE tools so you need to "lower" the security to...

Product: Dataease [{8}]FIVE. Written by DataEase 15/11/14 at 18:35:39

New Sample - Using Subform as Open Related Dialogue with multiple returns (Ver. 8.2.0.1686)

Download "Open Related"&nbsp;Sample Open Related is a "awkward" and outdated way of doing "picklists". As you have pointed out it is slow and you can only really r...

Product: Dataease [{8}]FIVE. Written by DataEase 17/11/14 at 18:26:41

DataEase 8.2 - SetColor() updated with Decimal Interpretation R255G128 etc... (Ver. 8.2.0.1691)

It was pointed out to us that we might have been to technical and not particularly user friendly when we designed the SetColor() function.After a lot of protesting, soul searching and deliberation and with the weight of tradition heavy on the...

Product: Dataease [{8}]FIVE. Written by DataEase 19/11/14 at 16:51:31

New Sample - CTRL-F10 Simulation with automatic search

Download Sample! This is just a small sample that show how you can use subforms as an alternative to built in lookup and search alternatives.&nbsp; Both Multibox an...

Product: Dataease [{8}]FIVE. Written by DataEase 02/12/14 at 13:23:18

New Sample - Make an Application with Expiry Date (Ver. 8.2.0.1700)

Download Sample! A lot of our customers are developers that develop applications for third parties. In the good old days these customers was local to the partner, b...

Product: Dataease [{8}]FIVE. Written by DataEase 27/01/15 at 18:39:47

Re:New Sample - Make an Application with Expiry Date (Ver. 8.2.0.1700)

This is an excellent idea, as it can also be used to maintain the licence or maintenance on a&nbsp;system on an annual or whatever&nbsp;basis....

Product: Dataease [{8}]FIVE. Written by Kensington 29/01/15 at 12:43:00

Application that Showcase how you can write-protect and search with paste in a Form.

Download Sample! In the attached sample we use SetState(), Custom Menu and Custom Toolbar to "force" the user to use our functionality correctly. Se...

Product: Dataease [{8}]FIVE. Written by DataEase 20/03/15 at 10:47:38

Making icons and picture buttons with Fonts (WingDings, WebDings)

One of the best ways to make graphical buttons etc in DataEase 8 is by using Graphical fonts on buttons. You simply choose WingDings as font on the button and then you select the correct image from the list below.Have a go!We will make...

Product: Dataease [{8}]FIVE. Written by DataEase 31/05/15 at 16:01:36

Custome TableView/FormView Toggle, fun with LabelExecDQL, SetClass, Custom Menu, Custom Toolbar, MoveObject etc...

Downlaod Sample! We had a request the other day about manip...

Product: Dataease [{8}]FIVE. Written by DataEase 13/07/15 at 16:48:31

DataEase 8.5 BETA! Finally. System/Install Document with Table and Data is fixed (Ver. 8.5.0.1918)

One of the most useful maintenance features in DFD was install Form/Report/Table etc.And like so many other things from DFD, it never worked the same in DFW if at all.You could get it...

Product: Dataease [{8}]FIVE. Written by DataEase 16/10/15 at 16:27:45

Re:DataEase 8.5 BETA! Finally. System/Install Document with Table and Data is fixed (Ver. 8.5.0.1918)

Yes!!!Finally!!One of the useful and important feature. I haven't tested this. But, I take your word for it.I think DataEase 8.x is getting into 21st century. But, slowly :-)...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 16/10/15 at 17:55:44

Re:Re:DataEase 8.5 BETA! Finally. System/Install Document with Table and Data is fixed (Ver. 8.5.0.1918)

To be honest, this is definitely a 20th Century feature.I can guarantee you that DE8 is solidly in 21st Century but possibly it is not that "visible" yet....

Product: Dataease [{8}]FIVE. Written by DataEase 18/10/15 at 12:12:16

Re:Re:Re:DataEase 8.5 BETA! Finally. System/Install Document with Table and Data is fixed (Ver. 8.5.0.1918)

One thing I can guarantee, you will attract more customers. Is to add interactive DQL like DFDWhen someone types or selects FOR.....then DataEase automatically gives all the tables to select.....etc....

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 19/10/15 at 03:52:09

Simple Calendar in DE85 using ExecDQL with Body ver 1.0 - Will be continued....

Download Calendar Sample It is Christmas after all so why not give you guys another little "present" ;-...

Product: Dataease [{8}]FIVE. Written by DataEase 30/12/15 at 15:29:44

ScrollTo added to SetCurrent() - Force your document to scroll with programming (Ver. 8.5.0.2096)

Download Sample! Even though we are getting close to DataEase 8.5 Production release, the deve...

Product: Dataease [{8}]FIVE. Written by DataEase 08/01/16 at 14:24:52

How to highlight active record in a subform by using GetCurrent("RowNumber"), SetStyle(with * and #) and GotFocus/Mousdown.

Download Sample We got a very good question o...

Product: Dataease [{8}]FIVE. Written by DataEase 28/01/16 at 11:26:05

Re:New Sample - CTRL-F10 Simulation with automatic search

This is a rather "technical" sample that is getting old now, and it was more meant as inspiration to a technical thinking around functionality in DataEase 8 than a practical way to solve this problem.&nbsp; But nothing wrong in explaining it a...

Product: Dataease [{8}]FIVE. Written by DataEase 01/03/16 at 16:52:33

Getting Started with DataEase for Windows 8.5

Welcome to DataEase 8.5 community!&nbsp; Are you completely new to DataEase for Windows (DFW)?&nbsp;We'll help you learn how to get started with DataEase, explore and learn the basi...

Product: Dataease [{8}]FIVE. Written by Fatma Adel 04/04/16 at 11:21:04

How to adjust DataEase 8.5 to use the Non-English characters with the HtmlEdit and text fields

-&nbsp;First, make sure that&nbsp;your system use the correct&nbsp;"System Local" language of the Non-English&nbsp;characters you use in DataEase: The system locale determines the default character set (letters, symbols, and numbers) an...

Product: Dataease [{8}]FIVE. Written by Fatma Adel 18/04/16 at 06:57:29

DataEase 8.5.0.2428 - DeletRecords updated with Options to allow specific deleting without dialogue.

It is almost crazy that this feature took so long to join our function library.Nothing has been as annoying as deleting records in DFW.Personally I have been using ExecDQL("delete records in mytablw with ID=data-entry field1 .",ID) sim...

Product: Dataease [{8}]FIVE. Written by DataEase 16/07/16 at 06:27:35

DataEase 8.5.0.2440 - RecordSave("Silent") - Background Save of Changes with no Visual impact.

DataEase has a tendency to do a lot more than you want to in one function and part of the 8.x program is to give the power back to the developer.In 8.x we have introduced a lot of new features that "stress" the old paradigm of DataEase.W...

Product: Dataease [{8}]FIVE. Written by DataEase 29/07/16 at 14:25:47

LegEasy4DOS Professional - New Release with Printer Timout and Server 2008R2/2012 (Ver. 1.0.0.2464)

We have now released the "long" awaited version that Support Windows Server&nbsp;2008R2 and 2012. If you get the message above, simply follow the instructions and you...

Product: LegEasy DOS. Written by DataEase 18/08/16 at 18:02:04

FINAL 8.5 with highlights like Actions Info/Alphabetical RE-Layout and improved Migration (Ver 8.5.1.2674)

You might have thought it was a little quiet on the blog lately but rest assured that it is not down to us being idle.We have been working on the final release of 8.5 when at the same time the work on 8.6 has been going at full blast. One of th...

Product: Dataease [{8}]FIVE. Written by DataEase 04/03/17 at 19:45:21

Re:FINAL 8.5 with highlights like Actions Info/Alphabetical RE-Layout and improved Migration (Ver 8.5.1.2674)

These are really good improvements.&nbsp;But, we also need full details in the Status &gt;&gt; ImportsRight now we only have Import Name,&nbsp;File Size, DOS File.I am not sure what we can get out of this....&nbsp;...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 10/03/17 at 16:08:24

New Sample - How to use jsBridge in WebField to interact with form

Download Sample! We got a request today that related to interaction between WebField (Memoexecdql etc)...

Product: Dataease [{8}]FIVE. Written by DataEase 14/04/17 at 16:45:31

Tired of the Delete Dialogue? New RecordDelete() with Option solve that!!

I don't know about you but I hate this dialogue! Every time I get it I think - WHY? I just want to delete this record and get on with it. And now you can!...

Product: Dataease [{8}]FIVE. Written by DataEase 24/04/17 at 10:41:00

New Sample - How to do multiple automated exports with ExecDQL()

Download Sample I know we keep on harping on this but DQL is DQL, syntax wise that is true at least. <b...

Product: Dataease [{8}]FIVE. Written by DataEase 02/07/17 at 16:54:26

WARNING! Keep up to date with versions!

We have had some reports of problems with warnings like Missing Status documents and files already exist lately. After some investig...

Product: Dataease [{8}]FIVE. Written by DataEase 18/07/17 at 19:22:16

UPDATE to 8.5 - Rebuild of last 8.5 (2674) to fix problems with scaling in older versions of Windows (7,8,2008 etc)

Problems with scaling in DataEase 8.5? Some of you have experienced problems with dialogs not scaling properly in 8.5. This is due to a bu...

Product: Dataease [{8}]FIVE. Written by DataEase 11/01/18 at 13:36:07

Re:UPDATE to 8.5 - Rebuild of last 8.5 (2674) to fix problems with scaling in older versions of Windows (7,8,2008 etc)

The date on your hompage is wrong 2018 not 2017...

Product: Dataease [{8}]FIVE. Written by Rainer 31/01/18 at 17:44:10

Re:Re:UPDATE to 8.5 - Rebuild of last 8.5 (2674) to fix problems with scaling in older versions of Windows (7,8,2008 etc)

Thanks Rainer.Always hard to get this right around the new year ;-)...

Product: Dataease [{8}]FIVE. Written by DataEase 02/02/18 at 16:53:26

L4D - How to print with color in LegEasy4DOS

We got a request today from a customer that was testing LegEasy4DOS.&nbsp; As he was very enthusiastic about what he could accomplish we decided to set aside some to help him...

Product: LegEasy DOS. Written by DataEase 25/01/20 at 18:21:12

DE8.5 - How to make generalised Language Version with ExecDQL and GetCurrent() etc.

Download Sample How to create language versions of documents has been discussed before. How to acheive t...

Product: Dataease [{8}]FIVE. Written by DataEase 09/06/20 at 18:50:01