Devart Forums

In Delphi Rio 10.3.3, I have developed an App that works well in Android Version 9 until I update to the SDAC 9.4.4 version, in this version I code like the following do not work

In a button I add the following code
This line of code will only work the first time, the next time you run it it will generate memory access error.

For this code not to be an error, this part of the code must go as follows: Horrible, right ?

Since I updated to the SDAC 9.4.4 version, the application that has worked well began to present inexplicable errors. I wasted precious time from work trying to find an explanation. Uninstall version 9.4.4 and went back to version 9.4.3 and returned everything works perfect.

I have an application that when you open a query if the connection fails to open the connection again it gives me the following error: Assertion failure D:\Projects\Delphi\DAC\SqlServer\Source\OLEDBAccess.pas line:1324

I am using version SDAC 9.0.1

Regards

Hello, I have put a select that brings me a set of data using CTE but the component gives me this error: Syntax error, permission violation, or other nonspecific error. Does SDAC support the use of Common table expression in a Query object?


Thank you.

When in VirtualQuery I use a statement that uses count or sum functions when extracting the field in the field editor it brings me a Memo field. Data type should be Float or numeric type, but extracting ftMemo. Why does this happen?

Hi, we have been testing the relationships Master details and how SDAC handle them. One effect we have noticed is that the master details show instability or does not work when inside the detail query there is more than one parameter. Please review this behavior in the product.


Thanks

Hi, thanks again. We've tried the part of the code that gives us an example. When we tried it, and at the time of executing the action post in the query we receive this error message "Syntax error, permission violation, or other nonspecific error". However, we tried a code like this:
This code works and we get the effects that suggested us.
Both codes are similar, and we think the effect should be the same, but in the code proposed by you causes the error mentioned above. What's the cause?

Hi, thanks for the support. Could you indicate by an example how this part could be implemented? Because we are not clear how to do it using TCustomConnection.DataSets.


Thanks

Hi, thanks for the support. We have done as you indicated and certainly works.
A suggestion, could this option (AutoPrepare and DescribeParams) be included in the connection object besides the query?
Because now we have to go through the whole project and go through all the units and object by Object
Manually set those properties. I think that putting that option (AutoPrepare and DescribeParams) on the connection object and that in turn is updated for all query objects that are linked to it.

Hi, thanks for the support. We have reviewed the property you have indicated, but we do not see the effect we are looking for. When we add a SQL statement containing parameters even with that property enabled to true, we have to manually configure each parameter individually. What are we doing wrong? If at design time I add a SQL statement to the query object having previously configured the properties that are indicated to us, which is supposed to happen? I understand that when defining a parameter the object should extract all the information from the parameter, as we have tried and we notice that everything remains without any effect. This method is only a run time ?

I am so intent on migrating all our projects developed with ADO objects to their products SDAC 8.0.2 but we have a big problem, our projects are very large and we use query objects with parameters. In ADOQuery when we define parameters in the SQL statement within the query, the query extracts all configured parameters (data type, type of parameter, address, etc). We have noticed that this functionality does not exist or does not work in SDAC 8.0.2. We need to be able to get that functionality. Otherwise we would have to configure each parameter manually, and it would be a lot of work. We want to warn that we choose SDAC instead of other tools like FireDAC, both tools (ADO and FireDAC) have that functionality, which we understand is a basic and important functionality. The question is: is a product error (SDAC)? Or is that the product does not have this functionality?

Hello, I am developing an application and I am worried about the security of the information that travels over the network. And I seen the benefits offered by SecureBridge. But I only see that they mentioned compatibility with MyDac and PgDac. I have latest version of SDac and I wonder if could combiner both products SecureBridge with SDAC.

Regards