I’m a new Servoy Developer user and fascinated by this tool. I’m also pretty new to the world of SQL (coming from FileMaker Pro) so apologies in advance for probable displays of ignorance. I have searched this forum and servoymagazine for the answers to the below questions, as well as searching all the documentation, to no avail. I’m hoping some generous soul can help clue me in on some very basic stuff.
What does the “!=” relational operator mean? The operators are not described in the documentation (which suprised me, because the docs are for the most part so thorough)
What does the LIKE relational operator mean and how does it work?
Cartesian joins (in several q’s):
a. How does one create a Cartesian (universal) join in Servoy? Or is it perhaps not necessary since one can show a list of all records on a tab panel?
b. On the other hand, what if one wanted to write an unstored calc that counts rows or aggregates values in ALL records of another table, how would one do that without a cartesian join?
I’m hoping I do not find myself defining a ConstantOne column like we used to have to do in the olden days of FMP…
I’m a new Servoy Developer user and fascinated by this tool. I’m also pretty new to the world of SQL (coming from FileMaker Pro)
Hi Nomi, welcome to Servoy
NB:
What does the “!=” relational operator mean? The operators are not described in the documentation (which suprised me, because the docs are for the most part so thorough)
Means NOT EQUAL TO. (like FM’s <>)
Is standard Javascript notation
NB:
2. What does the LIKE relational operator mean and how does it work?
Means SIMILAR TO
Useful if you want to show related data containing (and not only perfectly equal to) the key you’re using
NB:
3. Cartesian joins (in several q’s):
a. How does one create a Cartesian (universal) join in Servoy? Or is it perhaps not necessary since one can show a list of all records on a tab panel?
Mainly yes: you can use an unrelated tabpanel, so you don’t even need a relation for that.
NB:
b. On the other hand, what if one wanted to write an unstored calc that counts rows or aggregates values in ALL records of another table, how would one do that without a cartesian join?
Several ways to do that. When I need it, I use a SQL query.
But, believe me: most of the times, this need (to know how many rows are in a table) is a FileMaker heritage…
What does the “!=” relational operator mean? The operators are not described in the documentation (which suprised me, because the docs are for the most part so thorough)
Thank you in advance,
Nomi
Nomi,
The operator you mention as well as the other operators are known as
comparison operators. These operators are listed and described in a table
in the printed book Servoy Advanced Programming Guide for FileMaker
Developers - in the JavaScript grammar, Operators section, beginning on
page 51.
This book, along with all the other Servoy books, is available for purchase
from the online Servoy Store. This documentation is also currently
available as a free downloadable file in the Developers section of the
Servoy website.
NOTE: “LIKE” was not listed in this table because this operator was not
included in Servoy as of the time of the writing of this book.