0

Reference of Functions and Language
Hi,
I understood the use of the select statement, but I need a confirmation, please...
1.
I can use the select statement with a not linked table too, from any table in the DB?
2.
The select statement run with data fields only, or with formula fields too?
3.
I have three tables; Table A, linked to Table B; Table B linked to Table C; I can use the select statement from the Table A to obtain the Table C data (the Tables A and C are not directed linked); is it correct?
4.
Can I receive a lot of example with a little DB, to understand better the "How to do", please?
Thanks for all
Best regards
Roberto
I understood the use of the select statement, but I need a confirmation, please...
1.
I can use the select statement with a not linked table too, from any table in the DB?
2.
The select statement run with data fields only, or with formula fields too?
3.
I have three tables; Table A, linked to Table B; Table B linked to Table C; I can use the select statement from the Table A to obtain the Table C data (the Tables A and C are not directed linked); is it correct?
4.
Can I receive a lot of example with a little DB, to understand better the "How to do", please?
Thanks for all
Best regards
Roberto
Like Follow
106replies
-
Hello - sorry, me again. I would like a new record to be created in a table when a box is checked on another table, and then that new record to be opened so you can complete the other fields. Is that possible? So, if someone ticks a box on the "interview" form, a new "placement" record opens which is linked to the interview (so pulls across the name and client details). I can send you the database if that helps?
-
If you could send me (support@ninoxdb.de) a copy of the Ninox database you are working on (Main menu -> "Save Archvie as...") I'm sure that I can find a solution to your problem.
Birger - Ninox Support -
Find your comment (and the answers) here:
http://manual.ninoxdb.de/en/formulas-and-calculations/ -
Hi. I want to loop through some records, and detect when some value is different from the previous record.
In this example, I just loop through an array of numbers, trying to detect when a number isn't the same as the previous:
let prev := 0;
"start";
for a in [1, 2, 3, 3, 3, 4, 4, 5, 5, 5, 6, 6] do
if a = prev then
"same"
else
(let prev := a;
"different")
end
The result is:
"different,different,different,different,different,different,different,different,different,different,different,different"
It looks to me like the 'prev' variable must have a local scope inside the loop.
How can I get the 'prev' inside the for loop to be the same scope as the 'prev' outside the loop?
Thank you for your help!
(Tim) -
Hi, again. I'm really having fun with the scripting features of Ninox!
I found the list of new features in Ninox 2.2.0 and would like to know more about the new loop features, especially the 'while' loop. Is that covered in the documentation somewhere or can you provide a couple of examples here?
Thanks!
(Tim) -
The popup alert function does not allow transactions after clicking OK.
You can write a ' quasi alert '
https://www.dropbox.com/s/hztqiuo8lrg19x2/Deleting.ninox?dl=0
regards
Leo