Try:

update notesdata
SET notetype = 'D'
where notetype is null

OR try this

update notesdata
SET notetype = 'D'
where notetype = ''

(ie, blank string not a space)


Roger

-----Original Message-----
From: Daniel Bertin [mailto:daniel@...]
Sent: 18 April 2001 19:27
To: IBObjects@yahoogroups.com
Subject: [IBO] help please IBO SQL


Hi All
With IB60 and IBO
In IB_WISQL , DSQL tab, the SQL

update notesdata
SET notetype = 'D'
where notetype = ' '

execute statement
post datasets and commit
nothing
Does not produce any errors and does not replace all blank notetypes with D.
why is that?

Help someone please..
Daniel







Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/