[fdo-dev] fdo insert command

Orest Halustchak orest.halustchak at autodesk.com
Tue Oct 17 19:45:52 EDT 2006


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/20061017/6b570f1c/attachment.html


More information about the Fdo_dev mailing list