🚀 go-pugleaf

I am having a problem in deleting multiple records in a local InterBase
Table via Visual dBase (and Delphi).

In Visual dBase individual rows can be deleted in the Browser by
pressing Table Delete but not from the command window when using 'Delete

for 'FieldName' = 'Value' with a Database Engine Error :  Multiple
Records found, but only one was expected.

Local Share has been set to True in the BDE.

I have tried a workaround in SQL via Delphi

   with

       Delete
          From TableName
             where FieldName = 'Value'

and the BDE returns a 'Table is read only' error message.

Opening a Table and cycling through the records with Table.Delete within

an if test also gives a 'Multiple Records found' error message.

Can anyone assist.