This topic is locked

Master - Detail Error

10/15/2007 11:19:52 PM
ASPRunnerPro General questions
M
Michael7 author

Hello,
I have a master detail relationship. when i click on the detail link i get the following error
[font=Arial]Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
Can you recommend a fix for this.
ver 5.1 (326)
thanks

Michael

Sergey Kornilov admin 10/16/2007

Michael,
you need to make sure master-details relationship are configured properly. It looks like you have a problem with the link field (NULL or missing value).

M
Michael7 author 10/17/2007

Thankyou, found the fix.
Checked the DB and all records were populated okay but,

I had altered the Where clause in the variables.asp sql but not changed it in the masterlist sql so it was only working for the records where both SQL's agreed on the record selection.
thanks

again
Michael