Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why is append blank adding two records?
Message
From
31/10/1997 21:04:27
 
 
To
31/10/1997 11:58:56
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00057230
Message ID:
00057710
Views:
29
>>>>>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?
>>>
>>>are you clearing out the values from the controls between?
>>
>>Hi Dorris,
>>yes, I am. I am using for my add:
>> =cursorsetprop("Buffering", 3)
>> append blank
>>my abort button says"
>>=tablerevert(.t.)
>>but it is adding a blank record to the table.
>>could I see you adding procedures for a single user system?
>>thanks :)))
>
>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.. :)))
Robert Keith
Independent Developer
San Antonio, Texas
E-mail address:
rebelrob1@yahoo.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform