I have created the following range and it works fine
dim global dte_wrk as c
:form.load("time_clck_view","dialog")
:time_clck_view:BROWSE1.activate()
range.flags=RANGE_INDEX.OR.RANGE_FIRST.OR.RANGE_LAST
range.index_pointer=:time_clck_view:tables:daily.index_primary_put("dte_tip")
:time_clck_view:tables:daily.range_add(dte_wrk,dte_wrk)
:time_clck_view:FIELD1.activate()
sys_send_keys("{F5}")
:time_clck_view:BROWSE1:name.activate()
:time_clck_view:tables:daily.fetch_first()
:time_clck_view:FIELD1.activate()
:time_clck_view.show()
The problem arises when I try to put in a filter base on a global variable
I add the following code
dim global dept_id as c
dim global dte_wrk as c
:form.load("time_clck_view","dialog")
:time_clck_view:BROWSE1.activate()
range.flags=RANGE_INDEX.OR.RANGE_FIRST.OR.RANGE_LAST.OR.RANGE_FILTER
range.index_pointer=:time_clck_view:tables:daily.index_primary_put("dte_tip")
range.filter="*ANY(dept_id,:time_clck_view:tables:daily.acct_dept)"
:time_clck_view:tables:daily.range_add(dte_wrk,dte_wrk)
:time_clck_view:FIELD1.activate()
sys_send_keys("{F5}")
:time_clck_view:BROWSE1:name.activate()
:time_clck_view:tables:daily.fetch_first()
:time_clck_view:FIELD1.activate()
:time_clck_view.show()
I get the error saying field not found. I'm thinking it may have something to do with the global variable.
Thanks
Willie
dim global dte_wrk as c
:form.load("time_clck_view","dialog")
:time_clck_view:BROWSE1.activate()
range.flags=RANGE_INDEX.OR.RANGE_FIRST.OR.RANGE_LAST
range.index_pointer=:time_clck_view:tables:daily.index_primary_put("dte_tip")
:time_clck_view:tables:daily.range_add(dte_wrk,dte_wrk)
:time_clck_view:FIELD1.activate()
sys_send_keys("{F5}")
:time_clck_view:BROWSE1:name.activate()
:time_clck_view:tables:daily.fetch_first()
:time_clck_view:FIELD1.activate()
:time_clck_view.show()
The problem arises when I try to put in a filter base on a global variable
I add the following code
dim global dept_id as c
dim global dte_wrk as c
:form.load("time_clck_view","dialog")
:time_clck_view:BROWSE1.activate()
range.flags=RANGE_INDEX.OR.RANGE_FIRST.OR.RANGE_LAST.OR.RANGE_FILTER
range.index_pointer=:time_clck_view:tables:daily.index_primary_put("dte_tip")
range.filter="*ANY(dept_id,:time_clck_view:tables:daily.acct_dept)"
:time_clck_view:tables:daily.range_add(dte_wrk,dte_wrk)
:time_clck_view:FIELD1.activate()
sys_send_keys("{F5}")
:time_clck_view:BROWSE1:name.activate()
:time_clck_view:tables:daily.fetch_first()
:time_clck_view:FIELD1.activate()
:time_clck_view.show()
I get the error saying field not found. I'm thinking it may have something to do with the global variable.
Thanks
Willie
Comment