>I'm getting an error message that says "function requires row or table buffering mode". In my form init and load I have the following code:
> SET MULTILOCKS ON
> =CURSORSETPROP("Buffering",3)
>It still writes the record though. How do I get rid of the error message?
>
>My next problem is that I'm trying not to write duplicate records. In the click event of my save button, I have the following code
> set order to tag lname
> seek upper(thisform.txtLname.Value + thisform.txtFname.Value)
> if !found()
> append blank
> endif
> =tableupdate()
>the lname index is on upper(lname + fname) What am I doing wrong?
>
>Thanks.
Jane,
With cursorsetprop include alias to be sure you're setting it on correct one.
Second do not use row buffering if you have chance to leave record before tableupdate() decision (row buffering does an implicit tableupdate when you move rec pointer ie: seek()).
scatter memvar
select cnt(*) from ;
myTable ;
where lName+fname == m.lname+m.fname ;
into array myarray
if type("myarray[1]") = "N" and myarray[1]>0
tablerevert(.f.,cAlias)
else
tableupdate(0,.t.,cAlias)
endif
Cetin