Re: SQL Losing Data

From: Trevor Best (nospam_at_besty.org.uk)
Date: 01/15/05 

Date: Sat, 15 Jan 2005 11:02:12 +0000

Neil Ginsberg wrote:
> For those who have been following this, here's a note I just got from one of
> the users. If this situation was bizarre before, this just brings it to a
> new level.
>
> "I type in either keynotes [varchar 255] or notes [text]. Save (using Save
> Record from the Records menu). Then, if I'm working in notes and save, and
> click into either keynotes or citation [varchar 255], I immediately lost all
> information in both notes and keynotes. This just happened twice. And I
> really do make very sure the information is saved, but it disappears anyway.
> Doesn't ALWAYS happen like this, sometimes I'll click into another area and
> the information doesn't get lost. But it did just happen twice that way."
>
> So it seems the data is getting lost even before the user exits the record
> (presumably, clicking in one of the other fields just brings up the latest
> data in the table, which is blank in those fields).
>
> So there's some more that goes into the pot of this weirdness.

What method do you use to save the record in code? 

-- 
This sig left intentionally blank

Relevant Pages

  • hubcap/centercap
    ... yesterday, i lost my left hubcap, it happened twice before on the right side ... If i read it correct, it'll fit, am i right? ...
    (rec.autos.makers.vw.aircooled)
  • Re: SQL Losing Data
    ... > Neil Ginsberg wrote: ... >> So, apparently, there was some glitch with creating a new record through ... then immediately going to a subform and then out of it again to ... data that was entered after coming out of the subform was lost ...
    (microsoft.public.sqlserver.odbc)
  • Re: How to fight an airline?
    ... The first time I flew with them, they lost my luggage. ... and it has only happened twice that an airline lost my luggage: ...
    (rec.travel.europe)