Odd query results with FF

rbuser

I am using RB 5.5 with FlashFiler 2.05.

I can create a query of two linked tables, (default linking) excluding
records from the subordinate table for a known value, and all works. Try
the same thing with a different value, (again with verified known
value), and the report is empty.

As an example-

Members table is linked to Contributions table.

In an autosearch field called ContributionType, I query the user for a
numeric value. If the user types '51' the report runs with all
ContributionTypes <> 51, excluded as expected. If the user types any
other value, the report is blank. This is the only query field on either
table.

If I paste the SQL text into the FlashFiler SQL engine it returns the
result sets as expected, regardless of the value of ContributionType.

I would suspect something is wrong with my logic, however, the report
runs as expected with certain values, and not with others.

Any clues? Thanks,

John

digitalmetaphors

If the SQL is correct, then I would check the event handlers of the report.
Perhaps one of the data access components or data pipelines is getting
disconnected when you are assigning the autosearch criteria to the sql
query.


Cheers,

Jim Bennett
Digital Metaphors