MySql View Problem
I deleted two fields from a table which is used in a query. This caused a view to become unusable.
I created another view with the same name and it opens correctly from within Navicat.
I am using the view in a recordset in Dreamweaver and if I test the recordset it opens correctly.
However when I try to open a page where the recordset is used it creates an error message saying
Table 'bfsn.fullpath_image1' doesn't exist
I wondered if you can suggest a reason for this and how to correct the situation.