Get/Set parameter by Position in Procedure call

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hi Friends, 
 Please help me how to set/Get paramaters of a procedure call, when the call is reffering parameters by position and not by name.  Do we have a finction like 'GetIdentifierParamValue''for parameters of 'pcByPosition' type?

Thanks,
Unni

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
hellounni Members Profile Find Members Posts Groupie Joined: 24-November-2014 Points: 4	Post Options Post Reply Quote hellounni Report Post Thanks(0) Quote Reply Topic: Get/Set parameter by Position in Procedure call Posted: 08-April-2015 at 2:41am
	Hi Friends, Please help me how to set/Get paramaters of a procedure call, when the call is reffering parameters by position and not by name. Do we have a finction like 'GetIdentifierParamValue''for parameters of 'pcByPosition' type? Thanks, Unni

administrator Members Profile Find Members Posts Admin Group Stefan Mueller Joined: 25-January-2003 Location: New Zealand Points: 1027	Post Options Post Reply Quote administrator Report Post Thanks(0) Quote Reply Posted: 13-April-2015 at 7:00pm
	Unni, The GetIdentifierParamValue detects what type the call is (Position/Declaration/Named) and then is using either the PAR or the PARNAME value to locate the correct parameter. if you have a procedure call that is pcByName and you still want to use the PAR instead of the PARNAME then thats currently not possible .. i will modify the TPLSQLParser.GetIdentifierParamValue method to allow to override this behaviour if the ParName is set to empty string (in which case it will treat pcByName as if they are psByPosition). This will be in FormsAPI Master build 435 coming out hopefully later today! Regards, Stefan