Web App: Difference between revisions
From Data Islands
WikiSysopdi (talk | contribs) No edit summary |
WikiSysopdi (talk | contribs) No edit summary |
||
| Line 21: | Line 21: | ||
select * from apvendors where "VendorName" ilike '%ma%' | select * from apvendors where "VendorName" ilike '%ma%' | ||
B. Islands = Tables | |||
Revision as of 11:34, 8 July 2024
The web application is available at
Advanced SQL help
The backend of Data Islands is Postgres SQL servers.
A. Column Names
Column Names are case-sensitive and should be enclosed in double Quotes.
If not you may see the error text
"Query Failed: column "vendorname" does not exist 31"
Example of working SQL
select * from apvendors where "VendorName" ilike '%ma%'
B. Islands = Tables
