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


Delete all records in a form


Started by Ian Stockbridge
Search
You will need to Sign In to be able to add or comment on the forum!

Delete all records in a form

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

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

Re:Delete all records in a form

Hi Ian

Developing in a windows environment is a totally different experience that in dos :)

To delete all records in a form:

File > New Procedure 

Type: delete records in formname .

Click on check script button

Click on run

Backup your database before running these type of procedures.

Kind regards

Josef

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

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.  Have looked at all the options and also cannot find the run button or command

Ian

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

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).

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

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

Thank you sorted that one.

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