TheStriker
Programmer
Hello,
I am using Dreamweaver MX to develop a survey that spans about 5 pages. On the first page, I have the Insert Record behavior with the subsequent pages using the Update Record behavior. The insert record behavior works fine however, for some reason, when I get to the second page I get an error:
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
I think this is because I have a hidden field containing the primary key that is an Autonumber datatype. When I remove the hidden primary key field, I can open the page but it doesn't update because of the missing primary key. This is the first time I have ever done a multipage survey so I can use a tutorial of sorts on best practices for the subject. Should I continue to use DW behaviours or should I dump them and just write my own SQL. Please advise.
PS - I have tried to put all of the questions on one page but it is entirely too much for one page.
Thanks in advance
I am using Dreamweaver MX to develop a survey that spans about 5 pages. On the first page, I have the Insert Record behavior with the subsequent pages using the Update Record behavior. The insert record behavior works fine however, for some reason, when I get to the second page I get an error:
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
I think this is because I have a hidden field containing the primary key that is an Autonumber datatype. When I remove the hidden primary key field, I can open the page but it doesn't update because of the missing primary key. This is the first time I have ever done a multipage survey so I can use a tutorial of sorts on best practices for the subject. Should I continue to use DW behaviours or should I dump them and just write my own SQL. Please advise.
PS - I have tried to put all of the questions on one page but it is entirely too much for one page.
Thanks in advance
