Migration help needed/service broker notifications

[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.

[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;

[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 .