>at what conditions requery can be use with spt to select datas from sqlserver ?

Only if you're using CursorAdapter class or a remote view. Otherwise you need to re-run the select statement.