>>>>>>>Are you sure you are not doing an APPEND BLANK in the forms INIT? or something?
>>>>>>>
>>>>>>>WAYNE
>>>>>>>
>>>>>>>
>>>>>>>>On my ADD button, I have:
>>>>>>>>= cursorsetprop("buffering",3)
>>>>>>>>append blank
>>>>>>>>
>>>>>>>>When I =tableupdate(.t.)
>>>>>>>>I get two records.
>>>>>>>>any ideas?
>>>>>>When I add a record then save it and add another record, I am getting the data
>>>>>>from the first record I added in the fields of my second?
>>>>>>any ideas?
>>>>>
>>>>>make sure you're not moving between records before the save.
>>>>
>>>>thanks Dave for answering.. :)
>>>Is there a reason that you are not using "INSERT INTO tablename ..." to add records?
>>How about a small coding example of adding with INSERT INTO?
>>:)))
>1)I initialize memvars by using the SCATTER MEMVAR BLANK command the main program to make sure that the memvars are visible to any program or form I use and if I ever change or add fields, I dont have to remember to go back into a form or program and add the memvar manually.
>2)Re-initialize the memvars at the ADD new record button click method (another SCATTER MEMVAR BLANK)
>3)Get the new information thru the form
>4)At the SAVE click method issue INSERT INTO tablename FROM MEMVAR.
thanks - I guess this is not OOP, but it works. :))