Change of tack – moved to trying: selectdistinctcount(loginame)as'user_count'fromsys.sysprocesses In MSSQL get 75, in excel get 75 in xpa get 1 As before I just cut and pasted the

You need to get to a point you can find the concise sql its running in the magic logs...paste this into sql studio I only check gateway logging, put a log filename the selected the sql dbms log level

Hi Jim I can't see how you could use Font Awesome natively in magic, because in the font editor you can only zoom and pick fonts installed on windows. (as long as they are true type fonts as they

HI Adam, It would be good to look in your DB log file and also check the index settings!? BR StaneStanko Karlovčec Direktor - EPOS Krčkova 15, 2204 Miklavž na D.p. Telephone:

Tried with full developer trace and the only RESULT line was the one record I am getting which BTW is for my connection so could this be a permissions thing? Our DBA says not and all the time my

Dear Magic Developers! I would like to ask you, please explain me, how the GigaSpace license management works contrary to Broker's mechanism. (I mean the network broadcast packages) Best regards,

HI, Tried that and got below which seems OK. Still only showing one record in xpa but 7 in MSSQL Studio <158285391664954432> 10/08/2017 08:19:11.271 [Action ] - >>Starts load Batch

Hi Turn on the sql gateway logging - the answer to your problem will be in there From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Jackson, Adam <adam.jackson@...> Sent: Wednesday,

No, it is online query with no/before as end task conditions. I literally just pasted query into direct SQL screen, pressed APG option and chose browse then run program. The direct sql task is a sub

Hi Adam May be End task condition is set to Yes and Evaluate condition is set to After updating record in Task properties. What does the Magic logfile tells you ? Erwin

Hi, I have a query that returns me 4 records in SQL server but only one when I use it as direct sql. I just coped and pasted query into direct sql screen and used APG option then ran it. I have a

Thanks Newton On 8/8/2017 6:23 AM, Lawrence Fisher via Groups.Io wrote:

Law of conservation of bugs Regards Lawrence Author of the award winning book, "Kill Me Now!", amusing stories from the world of dating

Steve, First time's the charm. Many thanks. Didn't even need the header. Sherm

Sherm, Try this at home: Update a BLOB variable with the following expression: HTTPGet('https://www.myclient.com/etc/image.jpg', '','') You might have to include a header like 'Content-Type:

I'd like to display an image from a website on a form and/or in a table. https://www.myclient.com/etc/image.jpg Is there a straightforward way to accomplish this? Everything else is traditional

I probably know the answer to this, but I will ask anyway... Is there a way to use Font Awesome icons in a UP1.9 app or an XPA3.2 app, that is not web based? Just a plain old client/server

the native message box is standard and inherits all its visual from the operating system display theme.

Interesting. Thanks!

Sure? No. Just hoping. But thanks.