>>>>>It sounds like you are getting bit by the 'phantom' record. I had the same problem when I started in VFP trying to get this whole 'buffering' thing straight. What I do when I need to add a new record is insert with certain fields that I KNOW will always be there. In one system I set my last transaction date, last user update, and am given the new vendor id number. THAT'S what I use to create the new record.
>>>>>
>>>>>Trust me, get AWAY from append blank in a buffered file.
>>>>
>>>>Hi Dorris, and thanks for the advice.. Could you give me a code example
>>>>of what you are talking about? Also, when I APPEND BLANK, the record pointer
>>>>is moving to the last record instead of appending a blank record to the
>>>>end of the table.. :)))
>>>
>>>
i KNEW I was going to regret this.....Robert, I'm not wanting to be harsh, but how simple DOES the answer have to be?
>>>
>>>....if new record
>>>m.lastupdate = datetime()
>>>m.userupdt = muserid
>>>m.vendid = thisform.r_vendid
>>>insert into vendmast from memvar
>>thanks Dorris, I have done a lot of work for the Texas Department of Health
>>in foxpro. I am trying to get away from m.fld... I would think in vfp50
>>and with buffering you would never have a need for m.fld. But, to be sure
>>and to get my work load done on time, I should and probably will take your good
>>advice. I really appreciate you taking the time to take out the blocks for me. I think the older I get, the more I miss the obvious...
>>thanks again... :)))))
>Really? What area(s) did you work for?
I was one of the programmers that helped developed a Vendor program for the
contract department in Austin. This program tracked Bidders. I develop a tracking program that stamped the time,date and network user when they made comments. I think this was for some kind of family service thing. I worked in some basement in a hostipal in Austin and wrote code for some project, I also coded some reports for the nutrition area. :)))))
