Hi,
I have a report that when trying to print on 2 network stations, it gets very,
very slow, up to 50 sec.
The report receives 2 parameters, one string and one real
and it's like this in Before Open View
BIND('LOC:Serie',LOC:Serie)
BIND('LOC:NoFactura',LOC:NoFactura)
BIND('FCV:Serie',FCV:Serie)
BIND('FCV:Id_FacVen',FCV:Id_FacVen)
LOC:Serie = param:Serie
LOC:NoFactura = param:NoFactura
IF SELF.Filter = ''
ImpFacVenMan::View{Prop:Filter} ='FCV:Serie= LOC:Serie AND FCV:Id_FacVen=
LOC:NoFactura'
IF ERRORCODE()
STOP(ERROR())
END
ELSE
ImpFacVenMan::View{Prop:Filter} ='FCV:Serie='&LOC:Serie&' AND
FCV:Id_FacVen='&LOC:NoFactura&'AND ' &'('& CLIP(SELF.Filter) &')'
END
I already saw all the posts that talk about this, I have the sort banding, the
key in my base, and nothing ...
please a real solution to this problem ...
Something like what clarion does with current record !!
|
Hi Sofia,
Something is suspicious in your code for me.
> The report receives 2 parameters, one string and one real
> ImpFacVenMan::View{Prop:Filter} ='FCV:Serie= LOC:Serie AND FCV:Id_FacVen=
LOC:NoFactura'
This will work Ok with bound variables.
> ImpFacVenMan::View{Prop:Filter} ='FCV:Serie='&LOC:Serie&' AND
FCV:Id_FacVen='&LOC:NoFactura
This will work for numeric but NOT for string variable.
> please a real solution to this problem ...
I wish I could reproduce the issue on my computer to experiment and find out a
cause of the slowness.
At first glance this looks like opportunistic lock issue.
See docs.microsoft.com/en-us/windows/win32/fileio/opportunistic-locks
|