in our db it's not, but not sure about other
db's
it also lets us do this:
update table set column=null
you might try either of these things in a DBMS and
if they work try and translate them into an update action if thats what you want
to use (:
----- Original Message -----
Sent: Wednesday, April 21, 2004 11:55
AM
Subject: Re: Witango-Talk: Simple
question
caution: I think "" is different than NULL On Apr 21,
2004, at 11:56 AM, Alan Wolfe wrote:
Hi Ted,/smaller>/fontfamily> We
use R:base and can do this:/smaller>/fontfamily> update
table set column=''/smaller>/fontfamily> and
that sets it to null./smaller>/fontfamily> have
you tried that?/smaller>/fontfamily> -----
Original Message -----/x-tad-bigger>/fontfamily> /x-tad-bigger>From:/x-tad-bigger>
/x-tad-bigger>Ted Wolfley/x-tad-bigger>/color> /x-tad-bigger>/fontfamily> To:/x-tad-bigger>/fontfamily>
/x-tad-bigger>[EMAIL PROTECTED]/x-tad-bigger>/color>
/x-tad-bigger>/fontfamily> Sent:/x-tad-bigger>/fontfamily>
Wednesday, April 21, 2004 11:50 AM/x-tad-bigger>/fontfamily> Subject:/x-tad-bigger>/fontfamily>
Witango-Talk: Simple question/x-tad-bigger>/fontfamily>
Hi,/smaller>/fontfamily> I
would like to put a NULL in a database field with an update action into a
SQL Server database but can't figure out how. Is there a metatag to
use?/smaller>/fontfamily> /smaller>/fontfamily>
Ted
Wolfley/smaller>
/fontfamily> Database/Internet
Programmer/smaller> /fontfamily> The Ogden Group of
Rochester/smaller>
/fontfamily> phone: (585) 321 1060
x23/smaller> /fontfamily> fax:
(585) 321 0043/smaller> /fontfamily> [EMAIL PROTECTED]/smaller>/color>
/fontfamily>
www.ogdengroup.com/smaller>/color>/fontfamily> ________________________________________________________________________ TO
UNSUBSCRIBE: Go to
http://www.witango.com/developer/maillist.taf
________________________________________________________________________ TO
UNSUBSCRIBE: Go to
http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
|