is there any chance that your locate statement is locating a blank record in dl_dfltl? Also, if cDeal is not related, how do you know which value it is using in the locate? You do realize that if there is no relation, that only the current value of cdeal.d_code is looked at, it doesn't scan the cDeal table.

>The following code is blanking a good record in a dbf when it should be blanking a single record in a cursor. This is during a retrieve to reload the cursors with previously saved information.
>
> SELECT Dl_Dfltl
> LOCATE FOR d_code = cDeal.d_code
> IF FOUND()
> SCATTER MEMVAR
> SELECT cDl_Dfltl
> GATHER MEMVAR
> ELSE
> SELECT cDl_Dfltl
> GO TOP
> WAIT WINDOW "Saved Copy of Lease Template Not Found" TIMEOUT 3
> BLANK
> ENDIF
>
>Deal is an unrelated dbf in work area 13
>Dl_Dfltl is a dbf
>cDeal and cDl_dfltl are cursors that match the corresponding named dbf's.
>
>If the saved copy of lease template is not found, I want to blank the only record in cDl_dfltl. There is only one record in it, but this code Blanks the current record in the Deal dbf. I have tried a Scatter Memvar Blank and then a Gather Memvar, but it doesn't work. If I comment out the "BLANK" command, the Deal record is not blanked, but the cDl_dfltl record is not touched either.
>
>BTW: I put the Go Top in there because sometimes, I do a Replace on the cursors without it and nothing is updated. Go Top insures that I am sitting on the single record in that cursor.
>
>I hope someone can help me with this. Thanks...Tim