What is the sql syntax for a data link?
Does anyone know where this is documented? We are having difficulty implementing a "LIMIT" clause on one out of six desired layers and would like to figure out why, suspect that its related to the "LIKE" syntax or its concatenation but we are not sure.
0
-
Hi Zack,
the data link page in our documentation centre may help:
https://docs.geocortex.com/essentials/latest/admin-help/Default.htm#ge/admin/data-links.htm
Also, W3Schools has good examples of sql syntax.
Thanks,
Marion.0 -
Thank you Marion but the page does not address what we're after.
We're trying to set the maximum returned records in the data link using syntax like TOP or LIMIT, and have been successful with four other queries against the same data using LIMIT. Unfortunately, there is something about this last query which the link must not like since any attempts to add such limiting syntax break the query altogether. The only appreciable difference between this query and the others is the use of "LIKE" and wildcards.
This is why I was wondering if there is a reference somewhere for the flavor of SQL being used by those data links.0 -
Hi Zack, have you been able to run an equivalent sql query in your database - using LIMIT and LIKE in the same way? If it can run there, it should be able to run in the data link. The data link takes it syntax from the type of database it is reading. What database are you using? I have tested LIMIT in SQL Server, but it does not work there. 0 -
It uses the db syntax? Thank you! The issue was coming from an Access database, which I did not realize until I looked into my data connections is different from the postgres based data in the other connections. This explains my confusion, everything seems to work now!!! LIMIT does not work on Access either, by the way... must be a Microsoft thing. 0
Du måste logga in om du vill lämna en kommentar.
Kommentarer
4 kommentarer