No Current Record Error

vendredi 17 avril 2015

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

No Current Record Error

0 commentaires:

Enregistrer un commentaire

Labels