Aware IM User Forums

Hi I have a process which calls a query as follows: DISPLAY QryPersons This query shows as a popup, but I do want it to be shown in the same panel. How can I do this so it does not show as a popup anymore? Btw: the process is called from another process and not via a button where I can set the outpu...

Hi Bob, That does not work also, because I cannot do anything with the records found. This is my example process: FIND ALL AnObject //this BO contains 6 records AnObject.TryNr=0 //set everything to zero EXEC_STRING 'FIND ALL AnObject TAKE BEST ' + SystemSettings.Counter // this selects 3 records AnO...

No, as I wrote, I never know in advance how many records I need.

So therefore it must be variable. Tnx Rob

Nope, that does not work. Any other ideas how to achieve this?

Hi, I need to run a query which have to show a few records. Sometimes 5, sometimes 7 a.s.o.. I never know how many it has to show, so this is variable. I use the 'TAKE BEST' way and try to set a value to make the result variable. Something like: FIND ALL AnObject TAKE BEST SystemSettings.Counter Thi...

Hi, I trying to implement the Reorder functionality of a Query and made a process to store the new ordervalues in the database like this: IF ThatCBTQuestion.OrderNr > ThisCBTQuestion.OrderNr then ThatCBTQuestion.OrderNr = ThisCBTQuestion.OrderNr -1 else IF ThatCBTQuestion.OrderNr < ThisCBTQuestion.O...

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