>>>>>>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.