Devart Forums

Hi,

We have an licenced 3.80.0.32 version of SDAC components.

The StatementTypes value of Query component is returning me stupdate even in the case of insert, delete or update operations in the BeforeUpdateExecute event of Query component.
This problem i am facing specifically when i am obtaining the IdentitKey value from Database.

Can you please help me in knowing and using stInsert, stDelete and stQuery values of StatementTypes in the event.

Thanks in advance.

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

What is the Cost of SDAC components Standard Site Liecense along with Source Code??

Does Core lab provide Source Code for SDAC components if we purchase the SDAC Standard Site Liecense. I want to know the difference between SDAC professional components (for which the source code is Provided) and SDAC site liecense.

Does Corelab provide any support for using SDAC components apart from default help provided and if so what is the cost involved in it ?
We want to inherit the TMSQuery compomnent and add a new properties like SORTFIELDS etc.. If we face any problem in this process does Corelab provide any support.