Page 1 of 1
Migration help needed/service broker notifications
Posted: Fri 06 May 2016 13:35
by chillum
Hi, I have the trail version of unidac, and I need some help migrating my service broker events (from MS SQL Server). Please. Here is the FireDAC code:
Code: Select all
Inc(Count);
ea.Names.Add('CHANGE' + IntToStr(Count) + '=ev' +
Table + ';' + q.SQL.GetText);
so basically ea is TFDEventAlerter and q is the query that contains the SQL that is the bit that registers at the service broker... and then if [q.SQL.GetText query] changes in MS SQL Server, then I get alerted of it, and can update my tables. I need to do work with the data, not just display it, so I need to know through an event, and not just a DB aware visual component that always shows the newest data (if that even exists
How do I do the same with TUniAlerter? Please.
Re: Migration help needed/service broker notifications
Posted: Fri 06 May 2016 13:55
by chillum
might add, when I initialize the event alerter, I use these code:
Code: Select all
ea.Names.Clear;
ea.Names.Add('QUEUE=?');
ea.Names.Add('SERVICE=?');
and then when I have added all the events I need (the bit of code in previous post does that), I register it:
Code: Select all
ea.OnAlert := eaAlert;
ea.Register;
Re: Migration help needed/service broker notifications
Posted: Tue 10 May 2016 09:20
by azyk
UniDAC doesn't support such specific features of SQL Server as ServiceBroker and ChangeNotification. These features are supported in another our product - SDAC. You can download it from our website:
https://www.devart.com/sdac/download.html . See a sample of using the above specific features of SQL Server in the SDACDemo project. It is in the "Demos\SDACDemo\" folder respectively to the SDAC demo projects installation path.
Note: all the DAC products, including UniDAC and SDAC may be used simultaneously in one project on the same version of RAD Studio. For this, the versions of the installed DAC products for a particular RAD Studio must be compatible with each other. For example, inter-compatible latest versions: UniDAC 6.3.12 and SDAC 7.3.12 .