Jose Monteiro
-
Filtering Grouped columns
I have a table with more than 12000 records. The PK column should not have duplicate values, but unfortunately it does. I want to identify these records and I am looking for an easy way to do this.…
-
Concatenating all fields in a record
Is there a simple way to concatenate all fields in a record into a string? Of course we can do it explicitly:Field 1 + Field2 + ... But I mean is there a builtin command or function (or any other…
-
Searching again - Using REGEX (Regular Expressions)
Searching is really odd in Ninox. If I search for José I will get all records containing just José.And if I search for Jose I will get all records containing just Jose.…
-
Inserting a record in a Child Table from a Script
Supose I have a parent table with 2 fields and 2 records, linked to a child table: Table: "MASTER"Fields: "PK", "COLOR"2 Records: (10; "Blue")(20; "Red") And a child table with two fields: Table:…
-
"while" vs "for" statements in Console
The following code:let total := 0;for x from 1 to 5 do total := total + 1; total;end produces the following ouput:1234 For each cicle total is returned.…
-
Having records sorted in Table by more than one column
In a table view we can sort records by one column only.We have to click the column heading and then click Ascending or Descending box. Suppose now that 2 columns in my table are CN (as Client Number)…