Ajesh
9th September 2016, 16:43
Hello there

I have included the below code



before.program:
import("bpid.f",bpid.f)
import("bpid.t",bpid.t)
import("docd.f",docd.f)
import("docd.t",docd.t)
query.extend.where("tfgen200._index1 inrange {:bpid.f} and {:bpid.t} and tfgen200.dcdt inrange :docd.f and :docd.t")



But the record doesnt come. If i do refresh or first or last set, the records are displayed. But the record doesnt come at first.

Things i have tried

a) All the values of variables are coming perfectly
b) EXTEND_APPEND, EXTEND_OVERWRITE
c) Changed the specific start command to find.data etc

What the session currently is
a)Display, List Wondow


Any Clues?

bhushanchanda
9th September 2016, 17:16
Some things to check -

1. Try with braces "{" and "}" around docd variables
2. Try with "Default start command"
3. Try with execute(interrupt) after the extend statement
4. Try adding rebuild.query() after the statement.

What are other sections being executed?

5. Try adding the following code if it doesn't exists-

group.1:
init.group:
get.screen.defaults()

6. You might also try using -

query.extend.where("tfgen200._index1 inrange {" & quoted.string$(bpid.f) & "} and {" & quoted.string$(bpid.t) & "} and "
& "tfgen200.dcdt inrange {:docd.f} and {:docd.t}")
rebuild.query()

Ajesh
12th September 2016, 15:08
hmmm..

It had to do with start.synchronised.child. I replaced it with start.session and it started working.