>Hi everybody,
>
>I'm using a view. The table has iActive_Flag field with default value = 1. In my view I set the same default value for the iActive_Flag. Now, when I add a record, GetFldState function reports this field as changed and therefore even if I don't change anything I see a question asked: "Do you want to save your changes?".
>
>How can I solve this problem?
>
>Thanks in advance.

vfp implement DEFAULT with a two step job:
1. fill the record fields with 0 or NULL
2. loop on fields list and update every FIELD with a DEFAULT clause,
this step set the FLDSTATE.

This is a vfp bug.

clear
CREATE CURSOR aa (f1 i null,f2 i DEFAULT -1)
CURSORSETPROP("Buffering",5)

SET NULL ON

APPEND BLANK
? GETFLDSTATE(-1),f1 at 20,f2

INSERT INTO aa FROM memvar
? GETFLDSTATE(-1),f1 at 20,f2

SET NULL OFF
INSERT INTO aa FROM memvar
? GETFLDSTATE(-1),f1 at 20,f2

USE

CREATE CURSOR aa (f1 i null,f2 i DEFAULT -1)
CURSORSETPROP("Buffering",5)

INSERT INTO aa FROM memvar
? GETFLDSTATE(-1),f1 at 20,f2

#IF VERSION(2)>900
	* I wish this on VFP10
	SETFLDSTATE(-1,REPLICATE('3',FCOUNT()))
#ELSE
	FOR f=1 TO FCOUNT()
		=SETFLDSTATE(m.f,3)
	NEXT
#ENDIF

? GETFLDSTATE(-1),f1 at 20,f2

USE