AnsweredAssumed Answered

SQL ..... searching in a ListField

Question asked by GuenterBorg on Sep 12, 2015
Latest reply on Sep 12, 2015 by GuenterBorg

Is it possible to search/validate in a Field with more ¶ separated values ?

 

SetzeVar ( [

 

a = "SELECT SUM(Menge)," & "'x'," &" Artikel," & "'€', SUM(Preis_Artikel_gesamt)

FROM BON_Splitting WHERE sitz = ? AND Flag_boniert = ?GROUP BY Artikel"

] ;

Austauschen(SQLAusführen ( a ; Char(9); ""; Sitznummer_Spli;1);".";",")

)

 

The Field "Sitznummer_Spli" can take one or more values.

 

When "sitz" is in Sitznumer_Spli should display all real. Datas.

e.g. when Sitznummer_Spli = 3 then all Data from 3

when Sitznummer_Spli = 3¶5¶7   all Date from 3,5 and 7.

 

thx

 

Günter

Outcomes