18
Views
3
Comments
SQL syntax reference guide
Application Type
Traditional Web
Service Studio Version
11.8.13 (Build 32892)

I am using some advanced SQL statements and I need a SQL language reference guide (syntax) to help me debug my code.  What default SQL language does OutSystems use?  Where can I find the syntax reference guide?

See example below.

Thanks

Leon

Rank: #95

Hi Leon,


The syntax guidelines depend on your database server (SQL Server, MySQL, Oracle), but it should be pretty straightforward.

Just looking to your query at a first glance, I think you will need to replace the commas on your joins by AND to get it working.


Hope it helps.


Cheers,
João

Rank: #3464

Yes, thanks.  I realized that I needed the "and" in place of the commas.  I need to modify some of the join statements to inner and outer joins.  

How do I know which database server in being employed?