---
title: "Syntax error in FROM clause when opening application"
canonical: "https://servicedesk.maxgeo.com/space/DataShed4/1270186168/Syntax%20error%20in%20FROM%20clause%20when%20opening%20application"
format: markdown
---
**Issue: **Syntax error in FROM clause error popup stopping DataShed4 from opening

![image](media://67b47928-b282-42c5-a072-6606a1caa6dc)


**Cause: **View or tables name in the database contains dashes “-” 

eg: tblVWDHAssays_HoleID_KT-DD-RC-rcD

**Resolution: ** Update View or table names to remove the dashes

eg: tblVWDHAssays_HoleID_KT_DD_RC_RCD

Open ConfigManger unregister the  old table or view and register the new view


> ⚠️ DB Modification
> ⚠️ 
> ⚠️ Before any change is made to a user database (or system), maxgeo recommends competent staff should follow all standard database change management practices and never make untested changes to a production database.  
> ⚠️ Change, test and document all modifications on a test copy of your database to ensure results are as expected before implementing them on your live database. Always ensure a full backup is available in case rollback is required and follow all company change management procedures and practices.