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

![image](media://9c378c6b-dd9b-4277-b64e-8ba0af025c27)


**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.