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

Support::

~ (tilde)



Parameters


Returns/Result


Examples


Reference

 

~ (tilde)

Type

Wild Card (Sound Pattern) Symbol

Purpose

The ~ wild card character is used to find data that "sounds like" a specified text string. The ~ symbol can be used before any number of characters or words; it locates all the records that have a similar sound to the specified string. In making comparisons with the ~, DataEase matches the consonant pattern; vowels and spaces between words are ignored. Consonants with similar sounds (such as f and ph) are treated as the same character. The ~ symbol can be used in any logical comparison or record selection context and may be used in a text string after another wild card symbol (* or ? ).

Example

for MEMBERS with LAST NAME = "~Read" ;

list records

LAST NAME in order ;

FIRST NAME .

end

 

This script tells DataEase: list the records for members whose last name sounds like Read. The report output for this script, arranged in alphabetical order by LAST NAME, might look as follows:

 

Last Name

First Name

Rada

Amanda

Reardon

Paul

Redzepi

Zudi

Reede

Shannon

Rhode

Gertrude

Rhodes

Gisela

Ride

Sheryl

 

See Also


On the forum about ~ (tilde)

deleted form but table still there

Hi againI have had some trouble with forms, so I deleted them but the table did not delete. Can I delete the table?Thanks...

Product: Dataease [{8}]FIVE. Written by Gregor Popp 08/05/13 at 02:16:57

Re:deleted form but table still there

If you have a tricky table like this you need to do the following:1. Create a new form on top of the table.2. Go to Document Properties and check "Defines Table".3. Save the Form.4. Delete the form and answer yes when it ask if &nb...

Product: Dataease [{8}]FIVE. Written by DataEase Customer Support 08/05/13 at 10:25:35

Re:Re:deleted form but table still there

Thanks for the tip but no luck here.when I select the table to create new form I get error message "table file VARTAAB.DBA not found -1"and another table with no form error message " Error 712 Adding Form. Table not found."any fur...

Product: Dataease [{8}]FIVE. Written by Gregor Popp 08/05/13 at 20:33:49

Re:Re:Re:deleted form but table still there

Works in dataease 7.2 so try this:Create a new DQL:delete table "Temp form 56". --replace with name of your tableRun this and job done....

Product: Dataease [{8}]FIVE. Written by Simon B 09/05/13 at 09:13:46

Re:deleted form but table still there

Thank You worked a treat....

Product: Dataease [{8}]FIVE. Written by Gregor Popp 09/05/13 at 23:19:08

Re:Re:Re:Re:deleted form but table still there

It is always nice when the community step up where we fail to help.It is always nice to be reminded that things are not always as they seem in DataEase.Why would delete table work in DQL when it doesn't work in the Catalog?<...

Product: Dataease [{8}]FIVE. Written by DataEase 10/05/13 at 06:59:44

installation error Visual C++ 2005 redistrubable

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by Kermit Yost 04/08/13 at 15:06:27

Re:installation error Visual C 2005 redistrubable

This means there is a conflict with another version of the VC 2005 distribution package. What version of Windows are you running?...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 05/08/13 at 07:05:56

Deleting particular record(s) from a sub-form

In a form with sub-form (for-example order/order lines) I want to delete lines in the sub-form. I have added a button on the sub-form lines with Action "Record Delete". However when you choose this it asks what do you want to delete, main form or su...

Product: Dataease [{8}]FIVE. Written by Kensington 02/10/13 at 12:42:41

Re:Deleting particular record(s) from a sub-form

Anyone there??? ...

Product: Dataease [{8}]FIVE. Written by Kensington 03/10/13 at 14:25:53

Re:Deleting particular record(s) from a sub-form

Hi Place a button on the sub-form. Button Action: Execute Function / Derivation Function: RecordDelete() + Keystrokes(" S_tab_enter") + RecordSave() 1. RecordDelete ....deletes the record 2...

Product: Dataease [{8}]FIVE. Written by Josef Vella 03/10/13 at 15:21:33

Re:Re:Deleting particular record(s) from a sub-form

Thanks for the reply. RecordDelete() + Keystrokes(" S_tab_enter") + RecordSave() Gives an error saying "invalid keystrock _tab_enter" I have tried changing it to RecordDelete() +Keystrokes(" S(_tab)(_enter)") + RecordSa...

Product: Dataease [{8}]FIVE. Written by Kensington 03/10/13 at 16:00:35

Re:Re:Re:Deleting particular record(s) from a sub-form

Hi, Instead of Keystrokes(" S_tab_enter"), you should use Keystrokes("S _enter"). (put a space between S and _enter). So the function should be: Record...

Product: Dataease [{8}]FIVE. Written by Surjo 04/10/13 at 02:34:29

Re:Re:Re:Re:Deleting particular record(s) from a sub-form

Hi all Surjo that works really great , I still have one more annoying item.. as we fill in the data of the subform tabbing across, the user inadvertently presses the delete button, the pause and question "do you want to delete" c...

Product: Dataease [{8}]FIVE. Written by Gregor Popp 06/10/13 at 21:28:15

Re:Re:Re:Re:Deleting particular record(s) from a sub-form

When I try to execute the expression I get the following error message: I think the Message() function is generating the error. ...

Product: Dataease [{8}]FIVE. Written by Kensington 07/10/13 at 12:00:00

More on delete button to subform

Hi all Surjo that works really great(previous thread by Kingston) , I still have one more annoying item.. as we fill in the data of the subform tabbing across, the user inadvertently presses the delete button, the pause and quest...

Product: Dataease [{8}]FIVE. Written by Gregor Popp 08/10/13 at 21:47:24

Re:More on delete button to subform

Download Sample We have just tested tab order in Sub forms and it works, but is the problem that it doesn't skip the Delete button altogether? <...

Product: Dataease [{8}]FIVE. Written by DataEase 09/10/13 at 14:41:43

Re:Re:Re:Re:Re:Deleting particular record(s) from a sub-form

Anyone there??? ...

Product: Dataease [{8}]FIVE. Written by Kensington 10/10/13 at 09:26:13

Re:Re:Re:Re:Re:Re:Deleting particular record(s) from a sub-form

Have you checked that the CDFS are defined in you app? Try to put the formula in a field derivation instead, then you will be able to debug by removing bits and see when it is accepted. ...

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

Re:Re:Re:Re:Re:Deleting particular record(s) from a sub-form

Hi What you need is an event, that when click enter on the data-entry field it will automatically move you to the next line of the sub form. This can be achieved by setting an OML with Keystrokes (_Tab).....so what happens it wil...

Product: Services. Written by Josef Vella 10/10/13 at 10:31:19

Re:Re:Re:Re:Re:Re:Re:Deleting particular record(s) from a sub-form

Message function is there but looking at it has wrong number of arguments! Do you think I need to re-install Dataease? ...

Product: Dataease [{8}]FIVE. Written by Kensington 10/10/13 at 10:59:10

Re:Re:Re:Re:Re:Re:Re:Re:Deleting particular record(s) from a sub-form

The CDF definition is in the application so Re-installing DataEase won't help. Just fill in the correct information in the CDF record. Cunftion Name: Message Description: Custom Message Dialog &amp; Processing<b...

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

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

DataEase Installation version 8.1

There's a way to start installation wizard without any user prompt? I hope that I can use a parameter for the product key or for the installation directory. I&nbsp; have to distibute automatically the product to many users. ...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 04/02/14 at 09:15:26

Re:DataEase Installation version 8.1

SImply install your multi-user DataEase on your computer and zip down the catalogue&nbsp;<span style="background-color: rgb(255, 255, 255);...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 04/02/14 at 10:08:46

Delete all records in a form

While trialing a conversion from DE5.12 to&nbsp;8 I have left a couple of fields out. &nbsp;How do I delete all records? &nbsp;Cannot find the delete function in DQL. &nbsp;Beginning to prefer the Dos&nbsp;system I have been using for 25 years....

Product: Dataease [{8}]FIVE. Written by Ian Stockbridge 23/08/14 at 12:43:51

Re:Delete all records in a form

Hi IanDeveloping in a windows environment is a totally different experience that in dos :)To delete all records in a form:File &gt; New Procedure&nbsp;Type: delete recor...

Product: Dataease [{8}]FIVE. Written by Josef Vella 23/08/14 at 13:19:10

Re:Re:Delete all records in a form

Josef,Have found the DQL commands, I had been looking in the reports, hence my initial question.Do as you say, but when I press the Check Script it comes up with a blank screen. &nbsp;Have looked at all the options and also cannot find t...

Product: Dataease [{8}]FIVE. Written by Ian Stockbridge 23/08/14 at 14:47:16

Re:Re:Re:Delete all records in a form

CHeck Script is the Gear (1) and the Run button is the man running (2). You can also hit F2 to check script and F4 to run (user view)....

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup. 24/08/14 at 10:39:11

Re:Re:Re:Re:Delete all records in a form

Thank you sorted that one....

Product: Dataease [{8}]FIVE. Written by Ian Stockbridge 24/08/14 at 17:14:21

Frequent Deletion

I have seen in the previous versions, meaning before 8. Where deleting records in a table frequently makes that table become inconsistent.&nbsp;All I do is something like this:delete records in Holding with (CurrUser = current user name)...

Product: . Written by Jeyarajah Arulrajah 13/10/14 at 14:52:44

Re:Frequent Deletion

The problem is "delete records in"....It is on our fix list but so far we haven't gotten to it.delete records (without in) is very efficient because it simply truncate the table, but "delete records in" is a very inefficient function.</...

Product: . Written by DataEase 13/10/14 at 18:33:42

Re:Re:Frequent Deletion

This worked fine in one of the older versions, I can't remember which one. I think DE6.1.&nbsp;Anyways, I use this to manipulate data before printing a report. This helps a lot with recreating layout when we make a change in the script. But, I...

Product: . Written by Jeyarajah Arulrajah 14/10/14 at 13:10:01

DataEase 6.53 Installation Question

I see in your installation document, you have mentioned about the configur.dat file;&gt;&gt;Make sure that you also copy it to the program&nbsp;catalogue, as the one in the shared catalogue and in the program catalogue need to be the sa...

Product: LegEasy 6 Windows. Written by Jeyarajah Arulrajah 13/11/14 at 15:28:38

Re:DataEase 6.53 Installation Question

It is just a way to get around deleting files.&nbsp;Deleting files when you install applications is not "good" management. it works the same both ways.Crazy installation and amazing that it wasn't "fixed" until 7.0...

Product: LegEasy 6 Windows. Written by DataEase 13/11/14 at 17:18:25

SubformAsModalDialogue

Hi there,I have implemented a subform as the example in the subject. It works fine, but I need to refine the result. I use as "menu" a form with buttons: each button is a specific function user can activate. I use the modal dialogue to let user...

Product: . Written by George Washington 05/02/15 at 10:49:08

Re:SubformAsModalDialogue

A form in DFW is a object hierarchy so if you disable the parent object, all children will be disabled too.The main parent object for a Record is the first Record1 so if you disable that you will disable all controls in the form.SetSta...

Product: . Written by DataEase 05/02/15 at 11:23:26

Default font in DataEase 8 - Segoe UI needs to be installed, fixed in 8.5

Hello George.The problem here is straight forward.DE8 use the new default font for Windows 7/8 which is SegoeUI. If a workstation doesn't have this font, Windows will default to the "closest" font which is a dubious affair.DE8 does...

Product: Dataease [{8}]FIVE. Written by DataEase 20/03/15 at 09:15:16

Recover deleted records

Is it possible to recover deleted records?...

Product: Dataease [{8}]FIVE. Written by Kensington 09/04/15 at 14:17:11

Re:Recover deleted records

In theory it is as they are not removed until you reorganize the table, but at the moment there is now tool to show deleted records so you would need to do it manually with HexEdit etc....

Product: Dataease [{8}]FIVE. Written by DataEase 10/04/15 at 07:14:51

Re:Re:Recover deleted records

ON DELETING RECORDSOne of the most important aspects of aDatabase or System, (leaving aside security and structure concept...

Product: Dataease [{8}]FIVE. Written by Kensington 11/04/15 at 10:52:00

Re:Re:Re:Recover deleted records - Postscript

As a postcript to this....plus ça change, plus c'est la même chose &nbsp;Except in this case it is&nbsp;plus ça change, mais n'est pas la même chosehttps...

Product: Dataease [{8}]FIVE. Written by Kensington 11/04/15 at 14:55:46

Re:Re:Re:Re:Recover deleted records - Postscript

There is many increments between DFD 4.2 (4.53, 5.53) and DE8 so it is important to think when things changed ...One of the biggest problems with improving migration from 6.x to 8.x was that 7.x was in between. It is no secret that 7.x was...

Product: Dataease [{8}]FIVE. Written by DataEase 12/04/15 at 09:53:44

Re:Re:Re:Re:Recover deleted records - Postscript

OK I&nbsp;agree, however recovering records has been there since at least&nbsp;dBase !!! which I used on the Commodore Business&nbsp;Pet !!!!dBase II user Guide 1983. ( CPM on NEC ) ( </strong...

Product: Dataease [{8}]FIVE. Written by Kensington 12/04/15 at 17:47:59

Network installation DE8.2 (group)

Hallo out there,were can i find SETUP informations for networkinstallation (Microsoft Server Network) for DE8.2 ?Thank you for informations.Markus...

Product: Dataease [{8}]FIVE. Written by grohmann.papier@t-online.de 17/04/15 at 13:56:24

Re:Network installation DE8.2 (group)

Hi Markus.There is no setup necessary. Just put the application on the server and install DataEase 8 on each client, then simply run the application.Make sure you use Opportunistic Locking as locking options.Cheers!...

Product: Dataease [{8}]FIVE. Written by DataEase 17/04/15 at 14:52:17

Re:Re:Network installation DE8.2 (group)

Following on from this, is dename and depath still required locally these days?&nbsp; Thanks....

Product: Dataease [{8}]FIVE. Written by Simon B 22/04/15 at 10:49:39

Re:Re:Re:Network installation DE8.2 (group)

DENAME has not been necessary since 7.0 as DataEase read the ID from the machine.However DENAME was re-instated in 7.2 as there was problems if one rean multiple Sessions on one computer without running them on a local drive. Then all users wo...

Product: Dataease [{8}]FIVE. Written by DataEase 23/04/15 at 12:36:22

Delete contents of table?

Hello allI've never used dataease before so hoping im in the right place!!&nbsp;I have&nbsp;a customer has it that I work with. They use it to hire out and sell products and gather customer information at there shop. This customer has now opene...

Product: LegEasy 6 Windows. Written by Garry O'Driscoll 23/06/15 at 11:12:22

Re:Delete contents of table?

It is rather straight forward but will take a little "programming".Just open the application in designer mode (catalogue).Chose&nbsp;New/Procedure (DQL).in the DQL you simply write:delete records in &lt;tablename&gt;...

Product: LegEasy 6 Windows. Written by DataEase 23/06/15 at 11:36:08

Re:Re:Delete contents of table?

Brilliant, thanks for your quick response that has worked....

Product: LegEasy 6 Windows. Written by Garry O'Driscoll 23/06/15 at 12:34:57

Re:Re:Re:MULTIPLE TABLES WITH SAME NAME CANNOT DELETE

I just had this same problem when I deleted a field then tried to save.&nbsp; One of my other fields was derived using this deleted field (oops!) and so couldn't save the modified form. This caused the duplicate table to be created.&nbsp; Not sure if...

Product: Dataease [{8}]FIVE. Written by Simon B 17/07/15 at 15:14:54

How do I run more than 1 Delete Records in an EXECDQL

Morning,It is me again ... Hope you are well.I have a two Questions (for now ......)How do I run more than 1 Delete Records in an EXECDQL ? egDelete records in FORMAdelete records in FORMBdelete recor...

Product: Dataease [{8}]FIVE. Written by Charmaine 25/09/15 at 07:48:34

Re:How do I run more than 1 Delete Records in an EXECDQL

Hi Charmaine. To be honest, you should get all away from using old style DQL?s (for new stuff, don?t have to rewrite stuff of course). ExecDQL is ?million? times faster, close t...

Product: Dataease [{8}]FIVE. Written by DataEase 25/09/15 at 07:56:54

Application Utilities Install

I wanted to install a form from a migrated DE652 database and the DE8 install utility didn’t recognise any of the forms in the migrated database. I decided that maybe I should backup and restore the migrated database but I could not find it under Appl...

Product: Dataease [{8}]FIVE. Written by Henry Gondorf 14/10/15 at 08:20:47

Re:Application Utilities Install

Hi.It will install forms from a Migrated Database. They are no different than any other DE8 files.I suspect that you try to install a form/dql from a 6.52 database. When you migrate the DE6.x app it will be re-created in a different ca...

Product: Dataease [{8}]FIVE. Written by DataEase 15/10/15 at 11:50:54

Re:Application Utilities Install

After downloading the latest Beta version 1918, I still cannot install a form from a migrated DE652 database. I can import data from a “migrated” .dbm file but not install.RegardsHenry Gondorf...

Product: Dataease [{8}]FIVE. Written by Henry Gondorf 20/10/15 at 13:46:24

Re:Re:Application Utilities Install

Dear Mr. Gondorf. We are sorry that you are still struggling. It is very hard to judge what is going wrong, as you give us very little information other than it goes wrong&hellip; 1. What is the 6.52 migrated to? Is it mi...

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

Deleting document with a (double quote) in the name

Hi there,I named a form using a double quote, now I am trying to delete it (it should not have that name) and I get the attached error.Regards,George...

Product: Dataease [{8}]FIVE. Written by George Washington 15/02/16 at 08:17:47

Re:Deleting document with a (double quote) in the name

DataEase and " is very ticklish... We couldn't create a form with " in it at first, but realised that you could if you did save as new. It has been a "w...

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

Delete record in subform

How it's possible to create a button (delete) to delete 1 record in subform with the same effect of the keys F7 and delete subform(only)&nbsp;without having to choose the option?...

Product: Dataease [{8}]FIVE. Written by Giordano Villa 26/03/16 at 16:16:50

Re:Delete record in subform

You are making a valid point.&nbsp;It is annoying to have to select in a dialogue what you want to delete.The simplest solution to avoid this is simply to use ExecDQL.Create a button with the Action: Execute Function/Deriv...

Product: Dataease [{8}]FIVE. Written by DataEase 28/03/16 at 13:43:41

Re:Re:Delete record in subform

&nbsp;ExecDQL &nbsp;is OK !&nbsp;&nbsp; &nbsp; my &nbsp;&nbsp;ExecDQL("delete records in Schededett with NumID=data-entry field1",NumID)+RecordSave() &nbsp;delete record&nbsp;but in the screen&nbsp;not clear record deleted, it need &nbsp;to close and...

Product: Dataease [{8}]FIVE. Written by Giordano Villa 29/03/16 at 15:07:11

Re:Re:Re:Delete record in subform

Hi again.As the record is deleted by the DQL and not the GUI the current form don't realize that it has changed and hence don't re-read the data from the database.&nbsp;What you have to trigger is this, and there is a number of ways.<b...

Product: Dataease [{8}]FIVE. Written by DataEase 29/03/16 at 18:45:05

Delete record in subform

I have tried the script but it doesn't work, I attach the file with the button2 in the form scedetest.&nbsp;I wait for your help!...

Product: . Written by Giordano Villa 01/04/16 at 09:29:53

Application Utilities Install

Good Afternoon DataeaseUsing DATAEASE 8.5.0.2222,D85-PICKERIN000-28809 with Share local database switched off and strategy = single user.Trying to install single documents from a LegEasy 6.53 Database into Dataese 8....

Product: Dataease [{8}]FIVE. Written by KEV 23/05/16 at 13:47:16

Re:Application Utilities Install

Hi Kev.A lot of things has changed since then...1. You don't have to run single user etc. to install documents any more. You can run in Normal mode. Switching the locking strategy in the "outer" DataEase will not change the locking str...

Product: Dataease [{8}]FIVE. Written by DataEase 23/05/16 at 14:59:21

Re:Re:Application Utilities Install

Many thanks for your prompt reply.The reason I was going down this path with single document install was I could not migrate my application – see my recent post 17/5/16 MIGRATION ERROR 6.53 to 8.5.0.2222.Hope you can help....

Product: Dataease [{8}]FIVE. Written by KEV 23/05/16 at 15:14:32

Re:Re:Application Utilities Install

Hi again Kev.Upload your application on here as a hidden upload and we will have a look.There is so much "history" in old DataEase applications so sometimes you get caught out....DataEase has been a strong beliver in Migrations...

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

Re:Re:Re:Application Utilities Install

Hi again Kev.We have now looked at your application and we understand why you have struggled.There is something peculiar/corrupt in this application.&nbsp;Where dos it originate i.e. is it in-house development all the way or di...

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

LegEasy4DOS Installation Problem

When trying to install LegEasy4DOS I am getting the error message 'Unable to register the DLL/OCX:RegSvr32 failed with exit code 0x3.'I have tried running it as Administrator and I have checked that RegSvr32 exists on my system.The syste...

Product: LegEasy DOS. Written by Peter Birney, PB Associates 14/06/16 at 09:23:56

Re:LegEasy4DOS Installation Problem

It is part of the LegEasy Connect which is not yet operational so you can simply ignore it. It shouldn't affect the operation of LegEasy 4DOS in any way.Plenty of other stuff that do that though ;-)Will publish another update tomorrow....

Product: LegEasy DOS. Written by DataEase 14/06/16 at 20:07:42

Re:Delete record in subform

New Feature in latest release 8.5.0.2450YOu can now delete without getting dialogue based on the position of where the button is places.RecordDelete("SubForm") will delete the row where the button is placed without affecting any other r...

Product: Dataease [{8}]FIVE. Written by DataEase 05/08/16 at 22:19:27

Want to exit DataEase at a scheduled time, trying Timer().

I want to exit DataEase at a given time and is looking into Timer() but can't find any documentation.Can anyone help?...

Product: Dataease [{8}]FIVE. Written by SteinE 09/11/16 at 10:19:14

Re:Want to exit DataEase at a scheduled time, trying Timer().

Download Sample! Hi Stein. Yes. this is now straight forward with the new Timer() event on F...

Product: Dataease [{8}]FIVE. Written by DataEase 09/11/16 at 10:57:15

Delete Documents

Hi DataEase, we often use the function "delete documents" but I have the possibility to type only 1 letter in order to find the document to delete.I have a very large catalog and many of the objects start with letter "T".&nbsp;It will be very u...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 11/10/17 at 08:22:18

Re:Delete Documents

Download DERESDLG.D85 We have a joke around here that the test application that has been used in the past is a Database with one table with on...

Product: Dataease [{8}]FIVE. Written by DataEase 13/10/17 at 12:26:14

Re:Re:Delete Documents

the "download" does not work....

Product: Dataease [{8}]FIVE. Written by Rainer 13/10/17 at 14:32:05

Re:Re:Re:Delete Documents

Sorry. Spelling mistake in path. 99.9% of the time we create a download we check it after if it works and it always does.... but the one time you don't it doesn't. Not that we are superstitious or anything...&nbsp;...

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

Re:Re:Re:Re:Delete Documents

I downloaded the files and it works.&nbsp; There is also a similar file&nbsp;for the version 8.2? Thanks.&nbsp;...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 16/10/17 at 08:19:16

Re:Re:Re:Re:Re:Delete Documents

Hi.We only do changes to the latest release. The entire point in making new releases is tor improve the product.If we started to do changes to previously released products we would iopen a can of worms.&nbsp;If there is any rea...

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

Slow satelite machines

We use Dataease 6.53 on three PCs. One who works as a server and workstations, and two who are satellite workstations. This two are so slow when doing a search. It can help with a restart, but after a day it becomes slow again. It has been so for a co...

Product: DataEase 6.x. Written by Sondre Grinna 06/10/18 at 10:26:11

Re:Slow satelite machines

As a first attempt I would try to set the locking options to opportunistic.&nbsp;Locking in itself is a database so&nbsp;it makes sense to limit traffic as much as possible.When you are running an application alone on a network it will...

Product: DataEase 6.x. Written by DataEase 09/10/18 at 12:04:56

Delete records in vs For Table ; delete records .

Our Italian guys used “delete records in &lt;Tablename&gt; with bla bla bla”very often.And since some weeks we have problems with this statement.It doesn’t work any more in a procedure with the formDefine fields bla bla bla.<p...

Product: . Written by Henk Spierings 28/06/19 at 11:53:31

Re:Delete records in vs For Table

Hi Henk. deleting the records in the same table as you repopulate the table has been finicky since DFD so not sure anything has changed.Delete records in vs for Table delete records has also been finicky so most likely you have j...

Product: Dataease [{8}]FIVE. Written by DataEase 28/06/19 at 12:21:54

Do and don't when using ExecDQL, MemoExecDQL, delete records in etc.

Hi Afonso.Nobody can say that you haven't embraced the new ideas in DE8 ;-)The DE8 project was very much about "releasing" DataEase from its constraints and as such it has been a learning experience for all of us.The development...

Product: Dataease [{8}]FIVE. Written by DataEase 25/10/19 at 10:58:17

DataEase. A collection of original manuals and utilities from 1980/90s

I have had permission to advertise that I am offering all my old DataEase manuals for sale. I have listed all the items on Ebay as a simple way to list and post photographs, however, Im not expecting a rush of interest from the general public. They co...

Product: DataEase for Windows 5.x and before.... Written by Alan Hayward 27/06/21 at 10:05:55

DataEase. A collection of original manuals and utilities from 1980/90s

I have had permission to advertise that I am offering all my old DataEase manuals for sale. I have listed all the items on Ebay as a simple way to list and post photographs, however, Im not expecting a rush of interest from the general public. They co...

Product: . Written by Alan Hayward 07/05/22 at 12:31:56

On the blog about ~ (tilde)

Fix in 8 - Delete Table/Form directly in Catalogue (Ver. 8.0.0.1369)

A lot of "stubborn" problems have persisted in DFW for ages, some all the way back to Express. One can ask if it is the bug that has been "stubborn", the developers that has been ignorant, or the management that has been bad... ...

Product: Dataease [{8}]FIVE. Written by DataEase 30/08/13 at 11:57:03

DataEase 8 - How to delete all the data in an application

We get a lot of strange requests and one we get quite regularly is how to delete all the data in an application.There is no "button" to hit so the way forward has really been to meticolously create a big DQL with delete records in ... for e...

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

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

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&nbsp; with by&nbsp;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.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

LegEasy4DOS - format of Install files (INSTALL.DIN) in 4.x

FORM: install form FORMNAME from: FORMNAME.dba ; ex : install form CUSTOMERS from: custaaab.dba ; Now the form/table is installed so the next bit is data. New Table: <b...

Product: LegEasy DOS. Written by DataEase 10/08/16 at 13:39:14

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

L4D - Auto Installation/Distribution demonstration Video

...

Product: LegEasy DOS. Written by DataEase 20/11/19 at 19:08:09