Hi, It works in that I don’t get the Cast error but I don’t get any returned records either. I have checked the data and all records for the order I am locating have null in the Completed column. Adam

Hi, Probably should have worked this out ages ago but struggling with locating on null datetime fields inside a LQ or LW though I suspect would be same in main table too. I have a null allowed date fi

FIXED – just not 100% sure how. Likely suspect is some changes we did on Friday to allow access to broker servers from outside world which we eventually undid today. Only way to know is to reapply aga

The problem has moved on. Firstly, If I add the username and password values to the URL it works fines. Secondly, my colleague needed to start broker on prod server and that is now getting error too.

Steve, We have three servers: Test App Server – used to host broker during PoC – broker was turned off prior to these issues. Turned broker back on yesterday and it worked OK. Tried today and get erro

Hi, I am getting the error in the subject line when I try to run a broker program from our test server. This was working until I ran a magic install fix. I have tried many things to get it working. Th

Hi, Our users are experiencing times when they have our app open and the focus is lost and it is not clear which app or background process has taken it. It can even happen when the user is actively us

Hi, We have an on-line program (Physical / On Record Lock / On Modify) that calls a subtask when any one of columns A – D are modified using a var change event. The top task has force record suffix =

Hi, I am getting some encrypted data encrypted using AES method and want to use the decipher command to get the plain text. I have been given the key. To get me started I replicated the example in the

Hi, Is it possible for a program being run through the broker to know the username of the person who instigated the call of that program? Example being I’m a user who runs a broker program by entering

HI, Where do I find MagicXPA? I have looked on files section of user group and cannot find it. I have tried turning on the logging option but it is too verbose for me. Adam Adam​ Jackson Senior Manage

Hi, Is there anyway to get the requests info from the broker monitor in text export form. I would like to monitor and report on how much each program gets used. Magic xpa 2.5d TIA Adam Adam​ Jackson S

Correction: not character limit – direct SQL APG had made a long text column a Blob which the DataTo command did not like. Made it a long Unicode and all good Adam​ Jackson Manager, Business Systems T

HI Steve, Thanks, got it working though there seems to be some character limit on the data and column name arguments. When I restrict the columns so length of these are 257 chars it works. If I add on

HI, Just tried that by doing the RepStr I did on Column List virtual and still same. Adam Adam​JacksonManager, Business SystemsT +447949892482M +447949892482E adam.jackson@... Formula 1

Hi, I am trying to get DataViewToHTML working on a batch task with direct SQL and it is not working. My set up is as follows: In Task Prefix Where v Data List is populated with Trim(v Data List)&IF(v

Hi, I have a magic broker running on a server and can connect to it using http protocol no problem but I would like to switch it to use https as well because I want to embed the URL into SharePoint or

Hi, Is it possible to use the “ConnectRetryCount” and “ConnectRetryInterval” in the database connection strings in Magic xPa 2.5? It looks like the string is only big enough to take one of these argum

Yep – that sorted it! thank you Luuk and Arch

Arch, Thanks for that. I have had a play but no matter what I do WIFI On/off, Flight Mode On/Off the IP config info stays the same. I assume I am looking at the “media state” value? Adam