<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 9">
<meta name=Originator content="Microsoft Word 9">
<link rel=File-List href="cid:filelist.xml@01C80C19.1BA3E260">
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Print</w:View>
<w:EnvelopeVis/>
<w:DoNotOptimizeForBrowser/>
</w:WordDocument>
</xml><![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:11.0pt;
mso-bidi-font-size:12.0pt;
font-family:Arial;
mso-fareast-font-family:"Times New Roman";}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US style='tab-interval:.5in'>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:11.0pt'><span
style='mso-bidi-font-size:12.0pt'>I have a PostgreSQL database holding two
tables Drawings and Devices.</span></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:11.0pt'><![if !supportEmptyParas]> <![endif]></span><o:p></o:p></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:11.0pt'><span
style='mso-bidi-font-size:12.0pt'>Each of the drawings holds devices numbering
between 0 – 100.</span></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:11.0pt'><![if !supportEmptyParas]> <![endif]></span><o:p></o:p></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:11.0pt'><span
style='mso-bidi-font-size:12.0pt'>I also have a Delphi interface with which a
user can select a device, the application then performs a procedure then updates
the Devices table with an interface generated ID number. This, single device,
import works well.</span></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:11.0pt'><![if !supportEmptyParas]> <![endif]></span><o:p></o:p></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:11.0pt'><span
style='mso-bidi-font-size:12.0pt'>What I want to do is import all of the
devices from a Drawing, one at a time, <span style="mso-spacerun:
yes"> </span>perform the procedure on each device and update the table
with the ID.</span></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:11.0pt'><![if !supportEmptyParas]> <![endif]></span><o:p></o:p></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:11.0pt'><span
style='mso-bidi-font-size:12.0pt'>I have attempted Declare Cursor. </span></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:11.0pt'><![if !supportEmptyParas]> <![endif]></span><o:p></o:p></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:11.0pt'><span
style='mso-bidi-font-size:12.0pt'>Unfortunately, the version of POstgreSQL that
I am running doesn’t support updating a table with the interface’s ID number
while using a temporary cursor either in Fetch or Move.</span></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:11.0pt'><![if !supportEmptyParas]> <![endif]></span><o:p></o:p></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:11.0pt'><span
style='mso-bidi-font-size:12.0pt'>If someone could suggest a method of
importing these devices, based on Drawings, that allows updating the tables it
would be much appreciated.</span></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:11.0pt'><![if !supportEmptyParas]> <![endif]></span><o:p></o:p></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:11.0pt'><span
style='mso-bidi-font-size:12.0pt'>Bob Pawley</span></span></font></p>
</div>
</body>
</html>