You can also use a period instead of -> when qualifying fields. As long as SET EXCLUSIVE is OFF, you do not have locking issues.

>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.