>Hi All,
>
>
>I want to update a field in a table with the following.
>
>SELECT mytable
>REPLACE mytable.myfield WITH "YES"
>
>myfield CHAR 3
>
>It just wont update for me.This is probably something silly but I cant find anything wrong.
>
>
>Anyone?
Do you use buffering? Can be checked with CursorGetProp("Buffering").
Are you after the last record? Check for EOF(), recno() and reccount(). OR are you perhaps before the first record? Check for BOF().
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)