<!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.2900.2963" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=453072817-18102006><FONT face=Arial
color=#0000ff size=2>Thank you, if I understood you correctly basically it could
be acceptable to return empty reader and it is up to fdo client application
logic how to behave in those situations..</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=453072817-18102006></SPAN><SPAN
class=453072817-18102006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=453072817-18102006><FONT face=Arial
color=#0000ff size=2>Haris</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=453072817-18102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=453072817-18102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=453072817-18102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left>
<HR tabIndex=-1>
</DIV>
<DIV dir=ltr align=left><FONT face=Tahoma size=2><B>From:</B> Orest Halustchak
[mailto:orest.halustchak@autodesk.com] <BR><B>Sent:</B> Wednesday, October 18,
2006 4:22 PM<BR><B>To:</B> dev@fdo.osgeo.org<BR><B>Subject:</B> RE: [fdo-dev]
fdo insert command<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=885491214-18102006><FONT face=Arial
color=#0000ff size=2>Hi Haris,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=885491214-18102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=885491214-18102006><FONT face=Arial
color=#0000ff size=2>If the provider has no way to get the generated id values,
it could return an empty reader (rather than null reader), but then I'm not sure
what Map would do in the case where the records are displayed in the data grid.
Map expects to get the id values back so that it can populate the corresponding
columns in the data grid and also to know the ids of the objects so that if they
are edited subsequently, the correct objects get updated in the server. I
suppose if a lot of new features are being added at one time, the user simply
could refresh the whole layer in Map to get updated data complete with id
values, but for cases of adding one or a small number of objects, it's not very
efficient to do it that way.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=885491214-18102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=885491214-18102006><FONT face=Arial
color=#0000ff size=2>I don't think that MapGuide by default uses the insert
command unless someone writes their own scripts that create new
features.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=885491214-18102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=885491214-18102006><FONT face=Arial
color=#0000ff size=2>Orest.</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Haris Kurtagic [mailto:haris@sl-king.com]
<BR><B>Sent:</B> Wednesday, October 18, 2006 3:54 AM<BR><B>To:</B>
dev@fdo.osgeo.org<BR><B>Subject:</B> RE: [fdo-dev] fdo insert
command<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=843333607-18102006><FONT face=Arial
color=#0000ff size=2>Hi Orest,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=843333607-18102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=843333607-18102006><FONT face=Arial
color=#0000ff size=2>Yes, I understand it is up to provider and RDBMS and app
model, but there could be some other case's of generetaing id's like triggers or
procedure in db or more complex id's (not just
number,string)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=843333607-18102006><FONT face=Arial
color=#0000ff size=2>So I think there could be cases when it is not so
straight forward to get those id's back. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=843333607-18102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=843333607-18102006><FONT face=Arial
color=#0000ff size=2>How is this reader (return from insert) used in MapGuide?
Is it used at all?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=843333607-18102006><FONT face=Arial
color=#0000ff size=2>Would be appropriate (considering FDO architecture) for
provider to return NULL reader ? </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=843333607-18102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN><SPAN class=843333607-18102006><FONT
face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=843333607-18102006><FONT face=Arial
color=#0000ff size=2>Thank you for Map tip. It works exactly as you wrote
</FONT></SPAN><SPAN class=843333607-18102006><FONT face=Arial color=#0000ff
size=2>( I suppose Map anyhow should not try to immediately insert features
if some properties are not nullable).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=843333607-18102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=843333607-18102006><FONT face=Arial
color=#0000ff size=2>Haris</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=843333607-18102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=843333607-18102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Orest Halustchak
[mailto:orest.halustchak@autodesk.com] <BR><B>Sent:</B> Wednesday, October 18,
2006 1:46 AM<BR><B>To:</B> dev@fdo.osgeo.org<BR><B>Subject:</B> RE: [fdo-dev]
fdo insert command<BR></FONT><BR></DIV>
<DIV></DIV>
<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>