VFP 愛用者社區

[Ping.Ku]

我的語法式這樣子的：
private a1
public recno



a1=m.sn+m.site
*
if !empty(m.sn) AND !EMPTY(m.site) AND !EMPTY(m.msn)
select 1
go top

LOCATE FOR (d1.sn+d1.site) = a1
if found()
recno=recno()

select 1
goto recno
select 2
goto recno
select 3
goto recno
select 4
goto recno
select 5
goto recno
select 6


release thisform
do form p2
read events
release p2
else
select 1
append blank
replace d1.sn with m.sn
replace d1.site with m.site
replace d1.msn with m.msn


select 2
append blank
replace d2.sn with m.sn
replace d2.site with m.site
replace d2.pg with "1"


select 3
append blank
replace d3.sn with m.sn
replace d3.site with m.site
replace d3.pg with "1"

select 4
append blank
replace d4.sn with m.sn
replace d4.site with m.site
replace d4.pg with "1"


select 5
append blank
replace d5.sn with m.sn
replace d5.site with m.site


select 6
append blank
replace d6.sn with m.sn
replace d6.site with m.site
replace d6.pg with "1"


recno=recno()
release thisform
do form p2
read events
release p2
endif
endif
**
return .t.
release this form


不知為何，在輸入新資料時會出現「資料超出範圍」，並閃退。
但是重新出入剛剛的資料時，資料已被紀錄在資料庫中，且不會出現任何error。
請問有人知道要如何修改，避免出現此問題嗎? 感激不盡~

[syntech]

你有沒有傳回 RECNO(),
看看數值的變化?

新增的時候,
該筆記錄的 RECNO() 傳回來是 "負值",
存檔後變正值


你可以GOOGLE CURSORSETPROP("Buffering"),TABLEUPDATE()