InstantForum.NET v4.1.4Релибhttp://www.relib.com/forums/robot@relib.comThu, 20 Nov 2008 02:27:48 GMT20http://www.relib.com/forums/Topic884021-21-1.aspxПоменяй динамически строку в SQLText сorder by :Sortirovka наorder by ZAVADSKOY_NOMERНу типа:OraQuery1->SQL[11] = "order by ZAVADSKOY_NOMER"В ORDER BY переменных быть не можетThu, 01 Dec 2005 14:21:00 GMTmorenkohttp://www.relib.com/forums/Topic884021-21-1.aspxНе знал куда написать так что извините:select * from SPYSOK_PRIBOROV where (INDEKS_KPA LIKE :Indeks or :Indeks is null) and (GORANT_SROK like :GarantSrok or :GarantSrok is null) and (ZAVADSKOY_NOMER LIKE :ZAVADSKOY or :ZAVADSKOY is null) and (PAPKA=:Papka or apka is null) and (OTMETKA_O_PROVED LIKE:OTMETKA or :OTMETKA is null) and (DATA_IZGOTOVLENIY >= to_date(:in_dat1,''''dd.mm.yyyy'''') and DATA_IZGOTOVLENIY <=to_date(:in_dat2,''''dd.mm.yyyy'''')) and (DATA_PROVERKI >= to_date(:in_dat3,''''dd.mm.yyyy'''') and DATA_PROVERKI <=to_date(:in_dat4,''''dd.mm.yyyy'''')) order by :Sortirovka в билдере прописываю OraQuery1->ParamByName("Sortirovka")->AsString ="ZAVADSKOY_NOMER"; а блин он не сортируетПомогите Thu, 03 Nov 2005 05:16:00 GMTZapes