[fdo-dev] fdo insert command

[Haris Kurtagic]

Hi Orest,
 
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)
So I think there could be cases when it is not so straight forward to
get those id's back. 
 
How is this reader (return from insert) used in MapGuide?  Is it used at
all?
Would be appropriate (considering FDO architecture) for provider to
return NULL reader ? 
 
Thank you for Map tip. It works exactly as you wrote ( I suppose Map
anyhow should not try to immediately insert features if some properties
are not nullable).
 
Haris
 
 

________________________________

From: Orest Halustchak [mailto:orest.halustchak at autodesk.com] 
Sent: Wednesday, October 18, 2006 1:46 AM
To: dev at fdo.osgeo.org
Subject: RE: [fdo-dev] fdo insert command


Hi Haris,
 
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.
 
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.
 
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.
 
Thanks,
Orest.

	-----Original Message-----
	From: Haris Kurtagic [mailto:haris at sl-king.com] 
	Sent: October 17, 2006 6:52 PM
	To: dev at fdo.osgeo.org
	Subject: [fdo-dev] fdo insert command
	
	
	Hi,
	 
	I am little confused how FDO Insert Command should work, and
what it should return.
	 
	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 ?
	 
	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
?
	 
	All this I am testing on foreign schema's (without fdo metadata)
	 
	I hope that I put together understandable questions.
	 
	Haris

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo_dev/attachments/20061018/f61d591a/attachment.html