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
-
We are working on a new manual... At the moment find new features documented here https://ninoxdb.de/en/whatsnew
Birger - Ninox Support -
Hi, I wrote this function (it works) inserted in a function field called "Status Fattura" in a table called "Fatture" linked to a table called "Clienti":
let a := text("EMESSA");
let b := text("Inviata");
let c := text("PAGATA");
let d := text("SCADUTA");
if 'Data invio a Cliente' = null and 'Data pagamento' = null and 'Data scadenza Fattura' > today() then
styled(a, "", "", "printer")
else
if 'Data invio a Cliente' = null and 'Data pagamento' = null and 'Data scadenza Fattura' = today() then
styled(b, "", "", "glider")
else
if 'Data pagamento' != null then
styled(c, "green", "white", "moneybag")
else
if 'Data scadenza Fattura' < today() then
styled(d, "red", "white", "warn2")
end
end
end
end
end
I would like to create in a new function field inserted in the "Clienti"(customers) table a code that "reads" the "SCADUTA" (expired) result of the previous function and makes the sum of all the records (connected to the same customer) that have the "Status Fattura" = SCADUTA (Status Invoice = expired). It's possible?
Thx u so much -
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 -
Hi. You may want to give me a helping hand with a puzzling behavior of 'like'.
Here is a list of text records, say 'Dummy'
1 AAR
2 CBR
3 AAR
4 AAR:BZA
5 NCG
6 CBR:AAR
Filtering the list in View:Filter 'like AAR' selects records 1-3-4-6, ie all records containing 'AAR'.
This behavior is different when using 'like' in a Filtering Values context such as
>Counting records 'cnt'
cnt(Record[Dummy like 'AAR'].Any)
this count records 1-3-4 but not 6
>Selecting records
select Record where Dummy like 'AAR'
again, this selects records 1-3-4 but not 6
Any thoughts? It looks as if the behavior of 'like' is inconsistent. I'd expect 'like' to behave like in View:FIlter, ie matching any record containing 'AAR' regardless of its text position within the record.
Thank you for any help you may provide. Cheers, --Jaime -
Ninox Cloud can be accessed from any browser: https://app.ninoxdb.de/
The abilty to connect Ninox with web forms (read and right) is in development at the moment.
Birger Hansen