SQL “flavour”
C

Is there a proper, up to date reference on the SQL that Ninox uses anywhere that doesn’t involve picking through sample apps? I’m a MySQL user mainly (I’ve used some MS SQL and ages ago, Access). This doesn’t look like any sql I’ve ever used.

Ninox Profile

codycoder, You can find the language reference here...

 

https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language

 

Ninox Profile

The code used is also similar to JavaScript if that could be of any help....

C

I did read that the NX scripting language is based on JavaScript. How does that factor into the sql flavour Ninox uses ?

Ninox Profile

You've got me curious. When you say "flavour", are you referring to the database engine?

C

Sort of. This article says it better than I can:

https://www.quora.com/Why-are-there-so-many-types-of-SQL-What-is-the-difference-between-all-of-them

Ninox's SQL reminds me of somtnkbg called "linq" in Microsoft's work. It's an attempt to turn sql statements which are "string litterals" in programming vernacular into more an object oriented syntax.  Even that isn't a great explaination. 

Take this example from Ninox's documentation:

https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language

sum((Invoice where Status = 2).Amount)
sum(Invoice[Status = 2].Amount)

This shows two different ways to sum the invoice where the invoice Status is 2

In mySQL for example this would be expressed as:

SELECT SUM(Amount) as Amount FROM Invoice WHERE Status = 2

The NX Script looks (to me) like a 'mashup' between Javascript and SQL

 

Ninox Profile

Here's a link that has a response from Ninox support...

 

https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/what-is-the-language-5bb3daa9a9ece4783d4d6b10

 

I have to say I prefer the less verbose syntax that Ninox offers!

Ninox Profile

In order to make successful HP Wireless Printer Setup you need to connect router, printer as well as your system all together. You should also ensure that HP printer and your computer both are connected on the same network or same access point. If you don’t know the procedure to do the same or having problem while creating setup, then you need to take assistance from an expert. For this, you can make a call at our toll free number and get united with them. For sure, after taking their support you will be able to resolve all your queries within a promised time frame.https://www.hpprintersupportpro.com/hp-wireless-printer-setup

Ninox Profile

great post. you can go with https://www.avastsupportnumber.us

Reply