Aware IM User Forums

Ah yes, I knew there was a setting, but overlooked the grid settings....

Many thanks!

Hi, I have a BO with an attribute 'statusicon'. In the Presentation rules I try to set the right icon when a certain value is entered. When I set a color via a Presentation Rule it works fine. When I run a query, the value in the cell colors like it should. But when I want to show an icon via a Pres...

Hi, I have quite a basic question which I will try to explain with a simple example. I have a BO 'Person' and a BO CarsOfPerson. The BO CarsOfPerson references to the BO Person so I can store the cars of a person. Now, in the BO Person I have an attribute 'NumberOfCars' and I wrote an Update rule wh...

Thanks for you reply.
Ok, I use .Net because I never developed in Java. To much effort to switch to Java for this small solution I want.

Hi, I have an Aware app which works fine for 95%. But there is a process I unfortunately cannot develop with Aware (has to do with loops and table syncs). Therefore I want to write a .Net application which does the job at databaselevel and which stores some data into the Aware apps databasetables. C...

Ah yes, thats the best way. Thanks !!

Hi, I have a BO with a TimeStamp attribute. Now I want to find the maximum date Example: BO1.DateAttr= MAX ListwithDates.Entrydate WHERE ListwithDates.Entrydate <=CURRENT_TIMESTAMP This does not work and it seems that the MAX function is not working on timestamp attributes? Is there another way to f...

Hi,

I like to connect to an external MS SQL Server database.
The authentication is handled by Azure AD.

Can my Aware app connect through Azure AD? I know (and already did that) that is is possible via normal user/password, but via Azure AD?

Tia,

Rob

@BobK: unfortunately it does not...

Hi,

Yes, I connect to a SQL Server database as an external table.

The external table has those "id" and "index" fields, but this SQL Server is not mine, so I cannot change things there.

That causes the problem.

@Pointswell: I don't know. It is a service I use to get data from our financial system (via REST) into an MS SQL Database. It is normally used to show this data in PowerBI (which works fine). But I wanted this data in Aware and bumped against this problem. The REST -> SQL service is an external serv...

Hi, I'm trying to integrate an external MS SQL Server database to view some data in our Aware Application. Connecting to the database works fine and attributes are Discovered fine. But there are a few fieldnames in the tables which causes problems. This fields are called "index", "id" a.s.o. The res...

Hi Mark, Thanks for your answer, but this application is running for months without problems and we did not change anything on the server of installation. I really do not know how to follow your advices and this never occured to me in years. It seems that our firewall has had an update in the night ...

Hi, Since last Friday I suddenly got this message and my application does not work anymore. I can login the app, but when I want to do something a connection error occurs. I restarted the services and the server, but it keeps occuring. To my opinion nothing changed on this server, so anyone a clue w...

Update on this issue: I did go back to an older version and published that version (after making a good backup of course). This went well and I did not loose my data in my production database. In the develoment/testing database my data was lost, but thats not really a problem. So after all its solve...