>Hi,
>
>Can we issue the requery() command only on SQL views?
>Whe trying to do this on a cursor, I get the message:
>
>'Function is not supported on native tables' - 1536
>
>Any help will be appreciated.
>
>Thank you.
>
Ria,
The command only works on views (local and remote). If you create a cursor using SPT, it won't work. If you open a table or use SQL to create a cursor, it won't work.
If you have a cursor created using a SQL select, rerun the SQL statement or create a view out of it and use Requery().
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao