Devart Forums

Found the problem.

If you use any 3rd party plugins from SDAC you must deinstall those as well.

It's in the packages under productname Data access for Sdac (so not in the Devart range)
In my case Reportbuilder
(There's one for Fastreport, QuickReport, InfoPower and Intraweb as well)
After removing the plugin the IDE starts fine.
You need to recompile and add the plugin afterwards offcourse.

Over a week and no response.
What is going on ?

Hi,

I have downloaded the new SDAC for both Alexandria as well as Delphi Sydney.
However i have projects where it try's to open the project after the SDAC update, but the IDE just shuts down after 15 seconds.
This both happens in Alexandria 11.2 and the latest Sydney version.

When going back to SDAC 10.1.1 both versions open those projects without a problem.

This does not happen with all projects, just with some.

Is there anything i can provide or look for that might help you solve the issue ?
In the eventlog you can see the BDS crashing on RTL280.BPL and RTL270.BPL
Exception code 0xc000005

Kind regards,
Erik.

Hi,

I found a serious bug.
It does not happen in Unidac with SQLServer connectivity only with SDAC.

If you do a query with a parameter and the contents of the field start with a colon you will not get a correct result

SELECT ARTICLE FROM Table1 where article =':SRI' works fine and shows all records with :SRI in the article

SELECT ARTICLE from Table1 where article = :parameter where parameter is :SRI will not return the correct result.
If the parameter does not contain a colon in the beginning the result IS correct.


Providing you have setup a MSTable call dbarticle point to table Article;
The same is true for a combined locate :
dbArticle.Locate('article;otherfield',VarArrayOf([variable1,variable2],[])
where variable1 is :SRI , again it works with variable1 not containing a colon at the start.

Can you fix this, or do you know a workaround ?

Kind regards,
Erik

Hi Viktor,

This version works perfect for me.
I can connect, create an executable.

I could even switch from MySQL to MSSQL within the program without a problem.
Multiple reports over different database servers works seamless.

Direct support for Reportbuilder is now working fine indeed !

Kind regards,
Erik

Thank you, with some difficulty I am able to connect to the database inside the IDE in Reportbuilder.
However on compilation it forgets the server specifics.
I was not able to create a working executable with a database connection in Reportbuilder.

Also if you try to change the server connection details it keeps remembering the old details.
So very much in beta version indeed.

Kind regards,
Erik

Hi Viktor no problem, i'll gladly test it.

However click the link does not work, and also if it just type in the address shown in the address bar is does not work either.
Do you have a correct address/link ?

Kind regards,
Erik.

Any news on this ?
I already asked about this years ago, but i'm still waiting.

Kind regards,
Erik van Putten

Hi, would it be possible that you make a Reportbuilder extension just as you created in SDAC and MyDac so we get a UniDacSession in the data part of Reportbuilder ?

(Demos\3dparty\Reportbuilder)

Kind regards,
Erik.

Thanks for your quick reply.

Erik.

Hi can you tell us when we can expect all the DACs for Delphi XE10 Seattle ?

Kind regards,
Erik.

Thanks, but I got a version from the lead programmer of Digital-Methapors.
(Reportbuilder is made by them)

Don't you want to at least look at his version ?

Kind regards,
Erik.

Hi,

As of version 16.02 the Tppcomponentlist function in ReportBuilder has been removed.
Since a few versions Reportbuilder is now threadsafe and that function was not.
(The old plugin no longer works)

I've gotten an updated version from Digital-Metaphors that works fine with SDAC and should replace the current (old) files stored in \devart\demos\thirdparty\reportbuilder

Where should I send that version so you can make it available to everbody else ?

Kind regards,
Erik.

Hi, I saw the new SDAC 7 beta and am very exited about the new features.

I have a couple of questions and remarks.

- Can I download the none trial version somewhere ? (My subscription was just renewed)

- I have MYDAC 8.4.11 installed, but it wants 8.4.12 that is not available...

- Is it a known problem that sql.strings access in my old projects causes access violations during opening of those projects ?

- The product page http:\\devart.com\sdac talks about Oracle in the Direct Mode, that should probably be MS SQL....


Kind regards,
Erik

Hi GNiessen, as I wrote putting the filter between brackets solves the problem.
(You only get Red and Green Apples returned)

My point was that I did not expect the need to do that.
The problem arises as soon as you use AND or OR in your FilterSQL.

So it's easy to forget you need to enclose it in brackets.