[mapguide-trac] #1141: Feature Service API: Out parameter are not working

[MapGuide Open Source]

#1141: Feature Service API: Out parameter are not working
-----------------------+----------------------------------------------------
   Reporter:  Aleck    |       Owner:  Aleck
       Type:  defect   |      Status:  new  
   Priority:  low      |   Milestone:       
  Component:  General  |     Version:  2.0.2
   Severity:  trivial  |    Keywords:       
External_id:           |  
-----------------------+----------------------------------------------------
 In feature service API MgFeatureService::!ExecuteSqlQuery and
 MgFeatureService::!ExecuteSqlNonQuery methods, there is an argument for
 parameter binding. The parameters for a sql statement can be an output
 parameter. However, the client can't get the value of out parameters after
 executing the sql statement. This is because current server structure does
 not allow out parameters.

 Therefore, the solution is to create an intermediate object !MgSqlResult
 which
 contains a !rowUpdated integer, an !MgParameterCollection and an
 !MgSqlDataReader
 object. Once the !ExecuteSqlQuery or !ExecuteSqlNonQuery operation is
 finished,
 the intermediate !MgSqlResult object will be serialized. The
 !ProxyFeatureService
 will deserialize the !MgSqlResult and process the value of out parameters.

-- 
Ticket URL: <http://trac.osgeo.org/mapguide/ticket/1141>
MapGuide Open Source <http://mapguide.osgeo.org/>
MapGuide Open Source Internals