0

Have SQL Command That I Am Trying Run with Ninox

I have a table named DOTList and I want to run this SQL script but it's not working

UPDATE DOTList SET DBA_NAME = LEGAL_NAME WHERE DBA_NAME = ''

I get this error message:

Field not found: UPDATE at line 1, column 6
End expected: DOTList at line 1, column 14

Help!!!

3 replies

null
    • JGM
    • Jose_Monteiro
    • 4 yrs ago
    • Reported - view

    I didn't know that Ninox allows SQL statements.

    Is that so?

    • Sean
    • 4 yrs ago
    • Reported - view

    It doesn't use SQL. It has 3 SQL-like statements, select, where and order by. Here is a link to the language reference...

     

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

     

    Where/how are you trying to execute this command?

    • ilvarsveinbergs
    • 4 yrs ago
    • Reported - view

    Where I can find any more detailed information about Ninox commands and language, I am struggling to finish my data base because I can't find enough info about how to use visual and text commands. I have seen all available info at  "https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language" and also videos on youtube but it is not enough.

    I am looking for a code to make whole row or in the best case 2 colummns (Inventory ID and Inventory Name) from table "Inventory List" copy to table "Delivery List" using a button. Button will be added to the table "Inventory List" , im just choosing item then clicking on the button and entry goes to my table "Delivery List"

Login to reply

Content aside

  • 4 yrs agoLast active
  • 3Replies
  • 1361Views