Re: FilterStringBuilder & Co.
Verfasst: Mi 20. Apr 2016, 21:49
Nächste Erweiterung:
Feldname In (select ...)
ergibt:
(fiXyz In (Select idXyz From Tabelle Where (x = 4) Or (y = 5)))
Exists (select ...)
ergibt:
(Exists (Select * From Tabelle Where (idXyz = T2.fiXyz) And (x = 4)))
Feldname In (select ...)
- Code: Alles auswählen
With New FilterStringBuilder
With .AddSubSelectCriteria("fiXyz", SQL_In, "Select idXyz From Tabelle", , SQL_Or)
.Add "x", SQL_Numeric, SQL_Equal, 4
.Add "y", SQL_Numeric, SQL_Equal, 5
End With
Debug.Print .ToString
End With
ergibt:
(fiXyz In (Select idXyz From Tabelle Where (x = 4) Or (y = 5)))
Exists (select ...)
- Code: Alles auswählen
With New FilterStringBuilder
With .AddExistsCriteria("Select * From Tabelle")
.AddCriteria "idXyz = T2.fiXyz"
.Add "x", SQL_Numeric, SQL_Equal, 4
End With
Debug.Print .ToString
End With
ergibt:
(Exists (Select * From Tabelle Where (idXyz = T2.fiXyz) And (x = 4)))