General information
Category:
Coding, syntax & commands
Allan,
A scope of NEXT 1 is the current record. I think when that command was issued the record pointer was at EOF so the current record couldn't be deleted.
>Hi Dore,
>
>Thanks for your reply. I thought that DELETE was only supposed to delete the current record?? In any case, it wasn't deleting the current record and I had to resort to the SQL-DELETE to make it work - and then move to the previous record and refresh the form to avoid an EOF() error.
>
>>My guess is that the record pointer was at EOF() when you issued the DELETE command. The default scope of the DELETE command is NEXT 1. If you had put the same conditional "alltrim(tblbranchadmin.branchnumb) = alltrim(thisform.brnumb)
>>" as part of a FOR clause in your DELETE command it would have worked because then the default scope would have been ALL (that met the conditional). Instead you used SQL - DELETE which operates on all of the records that meet the WHERE condition.
>>
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only