phvwijk
22-Dec-2015, 08:06 AM
Hi,
I have a fairly simple view with a cDbCJGrid showing data limited by a non data aware header.
9607
The combo and year determine the constraint for the grid. The onChange in both controls rebuild the constraints in the DD and send a MoveToFirstRow.
When the view comes on screen The following is happening
onConstrain in the dd is called. Because there is a 0 default for the year It create a constrain in the dates 01/01/2000 and 31/12/2000. So the gird is constrained at the moment. The country default is "All" so will show all countries.
The spinform in activated and sets it tio the current year which fires the onchange and rebuild the constraints.
Then I have 2 ways. One I am using the old way of constraining and the second way is to use SQL Filters.
The df constraints
Gives and error
9608
Click ok and it will show the correct result
The sql filter:
Has a nice result
9609
Using ctrl+home give the correct result
Both are not correct, even have different results.
Peter
I have a fairly simple view with a cDbCJGrid showing data limited by a non data aware header.
9607
The combo and year determine the constraint for the grid. The onChange in both controls rebuild the constraints in the DD and send a MoveToFirstRow.
When the view comes on screen The following is happening
onConstrain in the dd is called. Because there is a 0 default for the year It create a constrain in the dates 01/01/2000 and 31/12/2000. So the gird is constrained at the moment. The country default is "All" so will show all countries.
The spinform in activated and sets it tio the current year which fires the onchange and rebuild the constraints.
Then I have 2 ways. One I am using the old way of constraining and the second way is to use SQL Filters.
The df constraints
Gives and error
9608
Click ok and it will show the correct result
The sql filter:
Has a nice result
9609
Using ctrl+home give the correct result
Both are not correct, even have different results.
Peter