Confusion with ADDNEW, EDIT, UPDATE
I'm still a novice with the database stuff.
I seem to be able to make ADDNEW, EDIT, UPDATE and FINDFIRST work as
expected most of the time. The difficulty is when there are no records
in the db.
1. An UPDATE after an ADDNEW fails with "No Current Record". I assume
that is because UPDATE tries to reposition at the previous current
record and there was none. Am I right? If so how do I get around this?
2. FINDFIRST does not seem to set the NOMATCH when the db is empty but
it does when there are records. Wierd. Ideas?
3. Also, I seem to have CLICK events firing for bound controls at
start up. I end up with errors because there is no data in the field
because the db is empty. Any clue what this is all about?
None of this seems to be a problem when there are records.
Any help would be greatly appreciated.
Paul Briggs
University of Guelph
