Paul
-
What do the different colours for Database icons signify?
Some icons are blue; some are grey. Why?
-
Database menu options are not working with 3.11.4
With the latest upgrade Database options Save Archive As... Duplicate... Rename... Reorganize Delete do not work.
-
How do I send a return in a TXT?
This sms://0401111111?&body=Hello World sets up a TXT in Messages on my Mac ready for me to press RETURN. How do I include RETURN in my command string? sms://0401111111?…
-
Zoom link gets converted in Sendmail
I'm using SendMail to send Zoom meeting invitations to online students. A link like https://zoom.us/j/2861234557?pwd=TklkRG1oNXNwSHR2awsSk9HaVpKRFppZ ends up looking like http://links.ninoxdb.…
-
Why was "void" inserted?
If I attach the following code to a button let a := 1; if 1 = 1 then a := 2end;alert(a);a it works as expected i.e. 2 is displayed if I replace "a:=2" by "let a:=2" or "var a:=2" I get let a := 1;…
-
How would I populate a view with a 3 table join
Suppose I had the following tables: Customer(CustomerID, CustomerName) Order(OrderID, CustomerID) OrderItem(OrderID, ItemID, Description) In SQL I could create Customer orders with: select a.…
-
How do I write Appointment fields?
I'd like to be able to set Appointment fields e.g. Let Appointment.startDate :=x; Let Appointment.startTime :=y; etc..
-
What fields are displayed in the calendar?
If I have an Appointment field in table Bookings and several other fields e.g. Status, Name, Event, etc.. How do I control what is displayed (and the order) in the calendar i.e.…
-
How do I create child records in a subtable?
I have a table Student with a subtable Lesson. I'm in a particular Student record, how do I programmatically create a new linked Lesson record which I can set date and time fields?
-
If I have a time field 'Start Time' how would I set 'End Time' to 'Start Time' + 30 minutes?
In the "Trigger after update" property of the time field 'Start Time' I can set the 'End Time' to be the same as 'Start Time' with 'End Time' := 'Start Time' How would I set the 'End Time' to the…
-
What's the for loop syntax?
Is it? for <index> in range( <from>, <to> ) do <expression>; .... end; or does it return a value or set of values? let <variable> := for <index> in range( <from>, <to> ) do <expression>; ....…