<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1543" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=250104223-17102006><FONT face=Arial color=#0000ff size=2>Hi
Haris,</FONT></SPAN></DIV>
<DIV><SPAN class=250104223-17102006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=250104223-17102006><FONT face=Arial color=#0000ff size=2>Yes,
the reader returned from the insert command should return the id's of the
inserted records. This is particularly needed if the id's are auto-generated.
The actual mechanism of auto-generating new id's is up to the provider. Oracle
would use sequences, other rdbms would use autonumber or related
concepts.</FONT></SPAN></DIV>
<DIV><SPAN class=250104223-17102006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=250104223-17102006><FONT face=Arial color=#0000ff size=2>Map
expects to get this reader from every insert. It uses this information for
example to update the data table and cached information for newly created
features.</FONT></SPAN></DIV>
<DIV><SPAN class=250104223-17102006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=250104223-17102006><FONT face=Arial color=#0000ff size=2>To
avoid having Map try to insert records immediately with null values, change the
Edit menu option for update edits automatically to off (I don't remember the
exact menu item name - I don't have the Map ui in front of me right now, but I
think it's the first item under Edit). Then, once you finish adding the geometry
and setting the properties that you want, you can check-in the feature or
features.</FONT></SPAN></DIV>
<DIV><SPAN class=250104223-17102006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=250104223-17102006><FONT face=Arial color=#0000ff
size=2>Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=250104223-17102006><FONT face=Arial color=#0000ff
size=2>Orest.</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Haris Kurtagic
[mailto:haris@sl-king.com] <BR><B>Sent:</B> October 17, 2006 6:52
PM<BR><B>To:</B> dev@fdo.osgeo.org<BR><B>Subject:</B> [fdo-dev] fdo insert
command<BR><BR></FONT></DIV>
<DIV><SPAN class=593054122-17102006><FONT face=Arial
size=2>Hi,</FONT></SPAN></DIV>
<DIV><SPAN class=593054122-17102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=593054122-17102006><FONT face=Arial size=2>I am little
confused how FDO Insert Command should work, and what it should
return.</FONT></SPAN></DIV>
<DIV><SPAN class=593054122-17102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=593054122-17102006><FONT face=Arial size=2>From documentation
I understand it should return reader with feature id's of new records filled,
for single and also for batch insert. Is this true and necessary? Could be
problem for some rdbms ?</FONT></SPAN></DIV>
<DIV><SPAN class=593054122-17102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=593054122-17102006><FONT face=Arial size=2>Also I don't quite
understand how Map is using insert command and null values. It seems to me
that it is calling Insert command immediately after creating new geometry
without user filling Null values ?</FONT></SPAN></DIV>
<DIV><SPAN class=593054122-17102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=593054122-17102006><FONT face=Arial size=2>All this I am
testing on foreign schema's (without fdo metadata)</FONT></SPAN></DIV>
<DIV><SPAN class=593054122-17102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=593054122-17102006><FONT face=Arial size=2>I hope that
I put together understandable questions.</FONT></SPAN></DIV>
<DIV><SPAN class=593054122-17102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=593054122-17102006><FONT face=Arial
size=2>Haris</FONT></SPAN></DIV></BLOCKQUOTE></BODY></HTML>