Unable to Override parameters of Query component at runtime
Posted: Tue 14 Nov 2006 16:03
Hi,
I am using licensed 3.80.0.32 version of SDAC components.
I am facing the following problem with SDAC components in my Project.
My Project has a Query component, UpdateSQL and a DataSource. UpdateSQL handles the insert, delete and Update operations of a table (Sorry I cannot use SQLInsert etc of Query Compoenet). This Update SQL is attached to the UpdateObject property of Query component and for the DataSource Querycomponent is attached.
During certain cases of Inserting Data into the Data base, i am overriding the values of Query component and passing new values to the "insert" statement of UpdateSQL in the OnUpdateRecord event of Query component and then i am doing an ApplyUpdates of the Query component.
I still found that UpdateSQL is picking the values of Query component rather than the values passed at runtime.
I already read a similar problem posted in the Forums on Nov9 by Mr.Japhar and my problem is very much similar to his.
I also looked into the solution provided by Corelab team. I cannot use the Solution as i have to use CachedUpdates. Also i have gone through the demos and i couldnt find any reference to the problem i faced.
Please provide me a solution, also please correct if i am worng or please inform me whether there is a bug in SDAC components in this case.
Thanks in Advance
I am using licensed 3.80.0.32 version of SDAC components.
I am facing the following problem with SDAC components in my Project.
My Project has a Query component, UpdateSQL and a DataSource. UpdateSQL handles the insert, delete and Update operations of a table (Sorry I cannot use SQLInsert etc of Query Compoenet). This Update SQL is attached to the UpdateObject property of Query component and for the DataSource Querycomponent is attached.
During certain cases of Inserting Data into the Data base, i am overriding the values of Query component and passing new values to the "insert" statement of UpdateSQL in the OnUpdateRecord event of Query component and then i am doing an ApplyUpdates of the Query component.
I still found that UpdateSQL is picking the values of Query component rather than the values passed at runtime.
I already read a similar problem posted in the Forums on Nov9 by Mr.Japhar and my problem is very much similar to his.
I also looked into the solution provided by Corelab team. I cannot use the Solution as i have to use CachedUpdates. Also i have gone through the demos and i couldnt find any reference to the problem i faced.
Please provide me a solution, also please correct if i am worng or please inform me whether there is a bug in SDAC components in this case.
Thanks in Advance