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)

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

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

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

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

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

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

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

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

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

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

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