Error 3021 - No current record
Solved, but might be of general interest.
Interesting one. I had a query, and wanted to drop in a y/n field from the right-side of an outer-join
Error - no current record. I must have spent a couple of hours on this, looking for data corruption, nulls and so on.
Without the field, it worked. With the field, I got the error immediately.
Eventually I found the answer on Allen Browne, which may be of interest.
http://ift.tt/1GTGxIs
Solved, but might be of general interest.
Interesting one. I had a query, and wanted to drop in a y/n field from the right-side of an outer-join
Error - no current record. I must have spent a couple of hours on this, looking for data corruption, nulls and so on.
Without the field, it worked. With the field, I got the error immediately.
Eventually I found the answer on Allen Browne, which may be of interest.
http://ift.tt/1GTGxIs
No Current Record Error
