Sql Question April 11, 2019 09:46AM |
Registered: 5 years ago Posts: 208 |
Re: Sql Question April 11, 2019 11:18AM |
Registered: 5 years ago Posts: 18 |
Re: Sql Question April 11, 2019 11:35AM |
Registered: 5 years ago Posts: 297 |
Re: Sql Question April 11, 2019 01:01PM |
Registered: 5 years ago Posts: 208 |
FOR ALL QRY_MasterToDo_Gesamt FROMEND FOR EACH STRING sStichwort_GUID OF stMyParaToDo.sStichwort_GUID_Liste SEPARATED BY ";" IF sStichwort_GUID<>"" THEN IF StringCount(QRY_MasterToDo_Gesamt.Stichwort_GUID,sStichwort_GUID)>0 THEN bLöschen=False BREAK END END bLöschen=True END IF bLöschen=True THEN HDelete(QRY_MasterToDo_Gesamt) END END
Re: Sql Question April 11, 2019 01:16PM |
Registered: 5 years ago Posts: 141 |
Re: Sql Question April 11, 2019 01:43PM |
Registered: 5 years ago Posts: 208 |
Re: Sql Question April 11, 2019 02:34PM |
Registered: 5 years ago Posts: 18 |
MyCond is string if 'userselected = something' THEN MyCond = "AND" ELSE MyCond = "OR" FOR EACH SelectedItem //From a list s_Where += Stringbuild(" ListValue %1 ",MyCond)
sQryBuild is string = [ SELECT Val1, Val2, Val3 FROM Data WHERE %1 ] sQryRun is string = Stringbuild(sQryBuild,s_Where )
Re: Sql Question April 11, 2019 03:38PM |
Registered: 5 years ago Posts: 208 |
Re: Sql Question April 11, 2019 03:48PM |
Registered: 5 years ago Posts: 297 |
Re: Sql Question April 11, 2019 04:07PM |
Registered: 5 years ago Posts: 208 |