I would check what records that didn't make it in the SPT result have in common adn how they are different from once that did.
>I have a view in a VFE application using dynamic view parameters. Executing the view with 'GAMINC' as the parameter returns 300 records. But executing the query from the view, using SQLEXEC, with the same parameter returns 3,956 records, which is what I would expect. This is the code from the SQLEXEC approach. The actual query code was just copied from the view code with the where clause added.
<snip>
>Can anyone suggest where I should start looking to resolve this?
--sb--