0

On-Premise: select + order by Syntax

Hallo zusammen, 

gibt es eine nachvollziehbare Ursache, warum "order by" bei einem select nicht akzeptiert wird, wenn das Ergebnis in einer Variable landen soll? Zeile 1 wird vom Editor nicht bemängelt, Zeile 3 schon - Inhalt ist eigentlich identisch? 

select Lifecycle where 'Gerät / Hardware' = 189 order by 'Lieferdatum Kunde';

let a := select Lifecycle where 'Gerät / Hardware' = 189 order by 'Lieferdatum Kunde';

Vielen Dank vorab für Vorschläge! 

4replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Fred
    • Fred
    • 10 days ago
    • Reported - view

    For some reason Ninox is picky with a variable. Put quotes around the select statement.

    let a := (select Lifecycle where 'Gerät / Hardware' = 189 order by 'Lieferdatum Kunde');
    

    I got the error message in iOS app and in a browser.

    Like 1
    • Fred Hi Fred, thank you for your time and answer. I contacted Ninox-Support after this post, we had a zoom-session and they came up with the same solution as you, a couple minutes ago. Because this is undocumented and unneccessary complicated, they created an internal bugticket for the developers, so we can look forward to a future fixed version ;-) 
      Have a great day!

      Like 1
      • Fred
      • Fred
      • 10 days ago
      • Reported - view

      F. Schwendtner I wouldn’t hold my breath for a quick fix. :)

      Like
    • Fred no - you are right again. i am still waiting for a couple of things since a couple of years with ninox :-D 

      Like
Like Follow
  • Status Answered
  • 10 days agoLast active
  • 4Replies
  • 43Views
  • 2 Following