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

mvp_badge
MVP

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

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?

mvp_badge
MVP

Hi Leon,


You can see it in LifeTime, on tab Environments:

If you are working on-Premises, you will be able to specify that on the installation process using Configuration Tool.


Regards,
João

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.