<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18702">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2 face=Arial>In the past, when the update conditions are not
met, the update transaction doesn.t finalize.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>However when I run the following update
function where ST_GeometryType(temp_arrow.ithe_geom) =
'ST_MultiLineString' is not true, then the return is a null
value.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Is there a workaround to this
problem??</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial> update temp_arrow<BR> set
ip_target = <BR> ( select
(st_translate(graphics.utilities_dgm.the_geom, <BR> st_x
(st_startpoint(temp_arrow.ithe_geom))-<BR> st_x
(st_startpoint(graphics.utilities_dgm.the_geom)) ,<BR> st_y
(st_centroid(temp_arrow.ithe_geom))-<BR> st_y
(st_startpoint(graphics.utilities_dgm.the_geom)))) <BR> from
graphics.utilities_dgm, temp_arrow, p_id.p_id, p_id.processes<BR> where
temp_arrow.graphic_id = p_id.p_id.process_graphic_id<BR> and
p_id.p_id.process_id = p_id.processes.process_id<BR> and
p_id.processes.fluid_id = temp_arrow.fluid_id<BR> and
ST_GeometryType(temp_arrow.ithe_geom) =
'ST_MultiLineString' <BR> and
graphics.utilities_dgm.utilities_description = 'Arrow_Flow_Direction' <BR>
and graphics.utilities_dgm.orientation = p_id.p_id.ip_orient );</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Bob</FONT></DIV></BODY></HTML>