>>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?
>
>must be set in the form buffermode property
>
>>
>>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.
>
>what results are you getting from this? it looks like you'd be getting a lot of blank records from this code.

---

Agree, there seem a big problem as it will tableupdate() blank record at once
if key not found. What will he do if the user DO NOT want to add record or wrong press addnew button by mistake!

2nd, if you really put the sharing code, you should:

Set Multilock on && at very begining, even before opening any form!
* This should be the general favour setting such as Set Near On, Set Exact Off

3rd, There will be a problem if you put Buffering code at Form.init()
Too late!!!

Events loading:

FOrm.Load()
Form.object1.init()
...
Form.init()

That is, if more than one program instance opening the first(Same) record at
Object1.init()
There will be a trouble to you but if you put it at LOAD(), it is better!

For me, as I using Classlib FOrm, I only can put Buffering code as no DE!

But I recommand you to set the property of DE on DO FORM if possible...
because it is more easy to do!! ^_~