i am trying to write a sql statement in visual that resembles the following:
select a_alias
scan

If a_alias->field > 0 .and. not empty(a_alias->field)

Insert into a_alias2 ;
( a , ;
b , ;
c )
Values (a_alias->x , ;
a_alias->y, ;
a_alias->z)

endif
endscan


i do not want to tie up the database files though. does visual foxpro have a nolock command that will not lock the table when the above code is being executed? any suggestions would be appreciated. thanks.