>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?
Sergey,
Good suggestion but so far I haven't been able to identify anything that would cause this. But I have discovered that some of the prices in the view are totally unrelated to the data in the table. And some of the data in the tables is duplicated, which shouldn't be happening.
Regards,
Jim