delete a record from a Database

I did this a bit differently. What I did is ask for the record to delete and then I just performed an extraction using @recno <> to the number entered in the input box. Also there is a line of code client.RefreshFileExplorer that will refresh the file explorer without having to exit and reopen IDEA, I always add that code to the end of my scripts. You can also add on to the script and delete the original database if you want. The script also uses the currently opened database. So let me know if this helps you out.

Sub Main

Dim iRecNo As Long
Dim db As database
Dim task As task
Dim dbName As String

iRecNo = InputBox("Please enter the record to delete")

Set db = Client.CurrentDatabase 
Set task = db.Extraction
task.IncludeAllFields
dbName = client.uniqueFilename("Test")
task.AddExtraction dbName, "", "@Recno() <> " & iRecNo
task.PerformTask 1, db.Count
Set task = Nothing
Set db = Nothing
Client.OpenDatabase (dbName)

client.RefreshFileExplorer

End Sub

 

I had a question on how to delete a range of records.  Here is a short example where you enter the first record to delete and the last record and the script will remove all records within that range including the first and last record.

 

Sub Main

	Dim iRecNo As Long
	Dim iLastRecNo As Long
	Dim db As database
	Dim task As task
	Dim dbName As String
	
	iRecNo = InputBox("Please enter the first record to delete")
	iLastRecNo = InputBox("Please enter the last record to delete")
	
	Set db = Client.CurrentDatabase 
		Set task = db.Extraction
			task.IncludeAllFields
			dbName = client.uniqueFilename("Test")
			task.AddExtraction dbName, "", "@Recno() < " & iRecNo & " .OR. @Recno() > " & iLastRecNo
			task.PerformTask 1, db.Count
		Set task = Nothing
	Set db = Nothing
	Client.OpenDatabase (dbName)
	
	client.RefreshFileExplorer

End Sub

Hi Brian,
Is there a way to delete a specific row throughout the file? For instance, one of the rows in my database is for "address". This row is part of a heading section that breaks up each employee data set. So "address" shows up every 20-30 rows in a 60k record database and I need to delete just that row. 
Thanks!