Podskajite pojaluista kak modify SQL v nested Datawindow..
Vot to chto ia imeu seichas. Modify rabotaet, no kogda retrieve main, stari' sql srabativaet.
Spasibo..

l_mod_sql = lower(f_print("dw_calibration_cert_standards_used"))
l_mod_sql += " and rotable_inventory.oid in " + std_display.text
l_dw = w_reports.dw_1

/* Custom Function to Modify SQL */
f_modify_sql_dw_no_retrieve(l_dw, l_mod_sql)

l_po_oid = dw_2.getItemNumber (1, 'po_oid')
if not isnull(l_inv_oid) then

/* eto datawindow imeet v sebe nested prediduschee */

f_print("dw_calibration_cert_rpt")
w_reports.dw_1.Reset()
w_reports.dw_1.Retrieve(l_po_oid)
end if

vozmojno Reset ne nujen... .schas poprobuiu..

no..still not working..
Spasibo za pomosch..

Eto toje daet oshibku..

w_reports.dw_1.Object.dw_1.SetSqlSelect(l_mod_sql)

Eto toje daet oshibku..

w_reports.dw_1.Object.dw_1.SetSqlSelect(l_mod_sql)

Est' kakoit to drugoi put' sdelat' eto?