Re: Zero length Fields

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Damon Heron (damon327_at_hotmail.com)
Date: 12/17/04 

Date: Thu, 16 Dec 2004 16:50:08 -0800

Change "Allow zero length" in table design to Yes.

HTH
Damon

"dandgard" <dandgard@discussions.microsoft.com> wrote in message
news:35D2AA54-F66F-4537-BC50-24651C4D7554@microsoft.com...
>I have a table that has 3 key fields - the third key field is potentially
> blank. I can set the field to zero length and default values to "". But
> if
> the user deletes the entries in the field on the form then when it goes to
> save the record it assumes the value is null and will not add a null value
> to
> a key field. Is there someway to bypass this. I have tried to figure out
> what event this triggers. (form error does not fire when this happens,
> and
> before insert does not fire, before update is too soon, and after update
> is
> too late)

Relevant Pages

  • Re: Explosion caused the Minneapolis bridge failure
    ... impact and fire were undamaged, ... The fires were isolated to just a few floors. ... One qualified to design practically anything you use. ... If you watch the videos closely, you can see the collapse starting ...
    (rec.autos.driving)
  • Fire Inside - Structural design with fire safety in mind
    ... Fire Inside - Structural design with fire safety in mind ... of building materials, says structural engineer Amit Varma of Purdue ... concrete and breaks it into pieces, a phenomenon that engineers call ...
    (sci.physics)
  • Re: Fire extinguishers
    ... Yep - a machine a company I worked for and helped to design ... used Taunt caps in it. ... I'd rather not shatter on a floor if I were to die in a fire! ... the Argon system we now use in our computer rooms ...
    (rec.crafts.metalworking)
  • Re: "Cocked and Locked" (Any Cops Out There?)
    ... Nah, just ordinary advantages like quick fire, grip position, and safety. ... # do not understand how 1911 style pistols work. ... Carrying no gun at all, would also be less "dangerous looking" - I don't ... What design do they consistently choose? ...
    (rec.guns)
  • Re: OT : ads on phpclasses.org
    ... > I would fire that employee for even asking me such a stupid question. ... > course we would not abandon the ads, we would keep the ads, I would FIRE THE ... designer to design the site for my taste to promote it __or__ I would ...
    (comp.lang.php)