Delete all records in a form
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.
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
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
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).
Re:Re:Re:Re:Delete all records in a form
Thank you sorted that one.