>Hi all, > Since i can't use requery() in SPT, do i have to call SQLEXEC() function again to retrieve my data and do all the setting for updatenamelist & updatablefieldlist ? > >Thanks Patrick, In addition to what already Larry and Andy said I suggest you to try Remote Views too. It might be much easier for a beginner and if it's SQL server 7 or later speed difference between RV and SPT is arguable (and ADO is another option). Read at least these pages on wiki site.