This topic is locked
[SOLVED]

 Add record says ADDED but list is empty; Record is added

12/18/2011 2:44:06 PM
PHPRunner General questions
N
notuo author

Hi. I just started a new project. I has some tables. One is the main table and has some others for look-up.
I leave all the defaults, just modified the look-up fields and build the project.
Then I test to add a record in the main table. The result shows Record added, and phpmyadmin shows the new record but...

  1. The result screen show an empty record and the result message
  2. if I click View, Edit after the record was added (in the result message) there are no records at all
    The link for view is: http://127.0.0.1/ai/profiles/ai01/output/personas_view.php?editid1=2'>http://127.0.0.1/ai/profiles/ai01/output/personas_view.php?editid1=2

    and I get: http://127.0.0.1/ai/profiles/ai01/output/personas_view.php?editid1=2'>http://127.0.0.1/ai/profiles/ai01/output/personas_view.php?editid1=2 with an empty page
    The link for edit is: http://127.0.0.1/ai/profiles/ai01/output/personas_edit.php?editid1=2

    and I get: http://127.0.0.1/ai/profiles/ai01/output/personas_list.php?a=return with an empty page
  3. Using back to list and clicking in this table, no records found.
    Any ideas?
    Thanks in advance
    EDIT>>> I added in the query designer the lookups as well. That's why. Deleted and is working.