÷ÓÅÍ ÐÒÉ×ÅÔ! éÇÒÁÌÓÑ ÔÕÔ Ñ Ó execute statement É ÒÅÛÉÌ ÅÇÏ ÐÒÉÍÅÎÉÔØ. éÄÅÑ ÔÁËÁÑ - ÄÉÎÁÍÉÞÅÓËÉ ÆÏÒÍÉÒÏ×ÁÔØ ÔÅËÓÔ ÚÁÐÒÏÓÁ × ÐÒÏÃÅÄÕÒÅ, ÞÔÏÂÙ ÍÁËÓÉÍÁÌØÎÏ ÐÒÁ×ÉÌØÎÏ ÉÓÐÌØÚÏ×ÁÔØ ÉÎÄÅËÓÙ. ÷ ÓÍÙÓÌÅ Ñ ÈÏÞÕ ÕÊÔÉ ÏÔ ÚÁÐÒÏÓÏ× ÔÉÐÁ:
select ... from .... where (((:field1_do_find=1) and (field1=:param1)) or (:field1_do_find=0)) and (((:field2_do_find=1) and (field2=:param2)) or (:field2_do_find=0)) .... èÏÞÕ ÄÅÌÁÔØ ÜÔÏ × ÐÒÏÃÅÄÕÒÅ, ÐÏÔÏÍÕ ÞÔÏ ÍÎÅ ÎÅ ÈÏÞÅÔÓÑ ÐÒÁ×Á ÎÁ ÔÁÂÌÉÃÕ ÄÁ×ÁÔØ ÐÏÌØÚÏ×ÁÔÅÌÀ ÎÁÐÒÑÍÕÀ. þÔÏ ÍÅÎÑ ÏÓÔÁÎÏ×ÉÌÏ - ÐÒÉ ÉÓÐÏÌØÚÏ×ÁÎÉÉ × ÐÒÏÃÅÄÕÒÅ ÄÉÎÁÍÉÞÅÓËÏÇÏ ÚÁÐÒÏÓÁ ÐÒÁ×Á ÐÒÏ×ÅÒÑÀÔÓÑ ËÁË ÒÁÚ Õ ÚÁÐÕÓËÁÀÝÅÇÏ ÐÒÏÃÅÄÕÒÕ ÀÚÅÒÁ, × ÓÍÙÓÌÅ ÐÒÁ×Á ÎÁ ÔÁÂÌÉÃÕ. üÔÏ ×ÉÄÉÍÏ as designed? ÷ ÐÒÉÎÃÉÐÅ ÌÏÇÉÞÅÓËÉ ÐÏÎÑÔØ ÍÏÖÎÏ É ÎÁ×ÅÒÎÏÅ ÜÔÏ ÐÒÁ×ÉÌØÎÏ. ôÏËÏ ËÁË ÂÙ ÍÎÅ ÉÚ×ÅÒÎÕÔØÓÑ? ÐÏ ÈÉÔÒÏÍÕ ÂÙ... ÏÞÅÎØ ÕÖ ÎÅ ÈÏÞÅÔÓÑ ÄÁ×ÁÔØ ÐÒÁ×Á ÎÁ ÔÁÂÌÉÃÕ. úÁÒÁÎÅÅ ÓÐÁÓÉÂÏ - ÅÓÌÉ ÂÕÄÅÔÅ ×ÏÐÒÏÓÙ ÚÁÄÁ×ÁÔØ - ÔÏÌØËÏ Ó ÕÔÒÁ ÏÔ×ÅÞÕ.
