>Hello Michael,
>
>I would do
>
>IF lAddMode
> cSqlStatement = "SELECT EMP.* FROM EMP WHERE .F."
>ELSE
> cSqlStatement = "SELECT EMP.* FROM main_one!EMP WHERE EMP.pers_no = ?nEmplNo "
>ENDIF

Yes that would work cleaner.

>This should be somewhat faster when you add records.
>
>You could also create it from the local cursor if it's available!

True. But I like the above better.

>Bob