Error executing sql query in creatio using VSCODE

Hi Community,

Any idea why I am getting this error executing sql query in creatio using VSCODE?

 

Unexpected token '', "<?xml ver"... is not valid JSON

 

 

Like 1

Like

2 comments

Use "" Like: Select "Id" FROM "Account"

I do wish that Clio Explorer would show the actual error returned.

As for the error, I assume the database is Postgresql, not MSSQL. Postgresql has case sensitive table/column names and must be enclosed in quotes (or they are assumed lower case, which won't match your tables/columns). For example: 

select "Id" from "Account" where "Name" = 'Something'

Ryan

Show all comments