How to delete a View - Which is showing error

[Jamo]

Hi, I am new to Dadabik, and not a programmer. I am seasoned Access user and have been writing DB's in there for many years, therefore very excited about this.

In stetting up my DB I created a view called 'patterns view' now realising that I think there should be no space. There now seems to be a conflict with this view (which I have now found that I do not need) and the original table 'patterns' and not allowing me to create the page and form.

When I try to delete the view I am getting an error message name error - the table name contains not allowed characters or it is too long. and will not delete the view.

Not being a programmer does anyone have a way to delete this view from the back end or another way around it.

Cheers

Jamo

 

[eugenio]

Hi,
probably the view has been created but not "installed" in dadabik.
You can check it here:
tables_inclusion.php?pages_to_show=views_not_installed
it should be in the not installed views list.

If this is the case, you can drop it from any database console/adminsw (e.g. phpmyadmin for mysql) with
DROP VIEW viewname

Best,

 

[Jamo]

Thank you.... all sorted now thank for the help.... now to battle with importing!@!!!!