Hi
I have a Table Buffered Parameterized Remote View to which I have added 2 records. Now I have to SCAN ENDSCAN through these records and do some processing on other tables using SQL Pass Thru etc.
This SCAN seems to get stuck on the second record and goes into an infinite loop on the second record. First record was nicely skipped to the second but the second record keeps on repeating in the SCAN ENDSCAN. If there was some logic problem on my part in further processing I guess the first record itself should get stuck into infinite loop.
Plus I also tried to SELECT * into a cursor but the cursor turns up empty so I am forced to work on the view. These records are new (not saved yet) so I cannot use parameterized SQL-PT cursor from the table itself.
Please advise where I messed up?