Search found 94 matches

by nhofkes
Fri Mar 22, 2024 4:44 pm
Forum: General discussion and questions about Aware IM
Topic: Adding records to database of Aware app
Replies: 3
Views: 76

Re: Adding records to database of Aware app

Have you considered writing the custom process as a SQL Stored Procedure? That does not solve the issue of the ID, BASVERSION and BASTIMESTAMP, but at least you have it running directly in the database so it may be easier and faster than as a .NET application running on the server.
by nhofkes
Mon Mar 18, 2024 10:07 pm
Forum: General discussion and questions about Aware IM
Topic: Configurator does not load most current version
Replies: 4
Views: 82

Re: Configurator does not load most current version

Aware (both server and configurator) is running on a cloud server (Windows) and I connect through RDP.
by nhofkes
Mon Mar 18, 2024 12:08 pm
Forum: General discussion and questions about Aware IM
Topic: Configurator does not load most current version
Replies: 4
Views: 82

Re: Configurator does not load most current version

I sometimes have the same issue. See screenshot for an example. The configurator loads the earlier version instead of the latest version that I am working on. It's no big issue because I can load that version manually, but I wonder what the philosophy behind it is.

Screenshot 2024-03-18 130249.png
Screenshot 2024-03-18 130249.png (7.24 KiB) Viewed 53 times
by nhofkes
Mon Mar 18, 2024 12:01 pm
Forum: General discussion and questions about Aware IM
Topic: Browser refresh
Replies: 3
Views: 89

Re: Browser refresh

I would assume that if a session is timed out, then the user is actually logged out already at that time? So presumably the fact that you were logged in after pressing F5 suggests that the session had not yet timed out even though you suspected that it might have been too long. In any event, it seem...
by nhofkes
Mon Mar 18, 2024 6:58 am
Forum: Tips and Tricks
Topic: Generic event handler for row operations working with records from Stored Procedure
Replies: 7
Views: 164

AwareApp.startProcess2('VP_ShowJobWithChat', 'jobs', ObjectID, { newTab: true, id: "JobWithChat", margins: {top: 0, bottom: 0, left: 0, right: 0} }); Since you are deep into this function, This might come in handy in the future. I don’t think it’s in the forum. I had this in an email. The key part ...
by nhofkes
Mon Mar 18, 2024 6:47 am
Forum: Tips and Tricks
Topic: Generic event handler for row operations working with records from Stored Procedure
Replies: 7
Views: 164

Re: Generic event handler for row operations working with records from Stored Procedure

Haven’t checked in at least 6 months but last I recall, the Alt-V search function doesn’t include this script. (That sure would be nice wouldn’t it, to find all the places “RenderOption” is used, for example) Can u check in V9 ? If not, sending and Email to Vlad would help get this in an update. I ...
by nhofkes
Sat Mar 16, 2024 11:08 pm
Forum: Tips and Tricks
Topic: Generic event handler for row operations working with records from Stored Procedure
Replies: 7
Views: 164

Re: Generic event handler for row operations working with records from Stored Procedure

The code in the first examples had in the render script some hard-coded parameters for the AwareApp.startProcess2 call (BO name, field containing BO ID and renderOption). I have now made this even more generic by passing the parameters in JSON to the render script. See screenshot for an example: Scr...
by nhofkes
Fri Mar 15, 2024 5:26 pm
Forum: General discussion and questions about Aware IM
Topic: Browser refresh
Replies: 3
Views: 89

Browser refresh

This is a question about the consequences of a browser refresh - in most browsers this is done by pressing F5 and/or Ctrl-R, sometimes also referred to as 'Reload'. I noticed from the log files (Tomcat log and testing log) that the browser refresh results in fully new login request. It seems that th...
by nhofkes
Fri Mar 15, 2024 11:49 am
Forum: General discussion and questions about Aware IM
Topic: EXEC_SP - Returns data, but not to BO
Replies: 8
Views: 8545

Re: EXEC_SP - Returns data, but not to BO

A possible solution for this issue is described in this post.
by nhofkes
Fri Mar 15, 2024 11:47 am
Forum: Tips and Tricks
Topic: Generic event handler for row operations working with records from Stored Procedure
Replies: 7
Views: 164

Generic event handler for row operations working with records from Stored Procedure

Introduction As described here , you can have a Stored Procedure returning data to a query. If you then would like to have row operations for this data, you will run into the issue that Aware does not have the BOs itself (see this post . As Jaymer pointed out in that post, you can make your own Row...
by nhofkes
Tue Mar 05, 2024 6:53 am
Forum: General discussion and questions about Aware IM
Topic: How to avoid error "BO has been changed by another user"
Replies: 8
Views: 292

Re: How to avoid error "BO has been changed by another user"

Thanks Pointswell. I believe I have fixed it now by the following changes: I removed all BO rules in Transaction that updated transaction totals based on changes in line items I added the simple rule "Transaction.TotalNumber = SUM TransactionLineItem.Number WHERE (TransactionLineItem IN Transaction....
by nhofkes
Mon Mar 04, 2024 10:43 pm
Forum: General discussion and questions about Aware IM
Topic: How to avoid error "BO has been changed by another user"
Replies: 8
Views: 292

Re: How to avoid error "BO has been changed by another user"

Apologies for the misunderstanding. It's a combination of both: some fields are editable, such as 'description' and 'comment', while other fields such as TotalNumber cannot be edited but are updated through business rules. So when the user modifies one or more fields that are editable, I need to sav...
by nhofkes
Mon Mar 04, 2024 10:13 pm
Forum: General discussion and questions about Aware IM
Topic: How to avoid error "BO has been changed by another user"
Replies: 8
Views: 292

Re: How to avoid error "BO has been changed by another user"

Bear in mind if you've got a rule on LineItem that touches Transaction (eg update Transaction.Total when LineItem was changed) then it will be more difficult. This is exactly the situation, although the rules are not in LineItem but in Transaction. As an example: If TransactionLineItem FROM Transac...
by nhofkes
Mon Mar 04, 2024 9:58 pm
Forum: General discussion and questions about Aware IM
Topic: How to avoid error "BO has been changed by another user"
Replies: 8
Views: 292

Re: How to avoid error "BO has been changed by another user"

1). There is an action "COMMIT TRANSACTION" (Which Vlad does not suggest using) that will Commit any open transaction. This might help I tried to put COMMIT TRANSACTION in the process that is run after the Save button is clicked, but it didn't help. That point isn't even reached, because the save a...
by nhofkes
Mon Mar 04, 2024 2:32 pm
Forum: General discussion and questions about Aware IM
Topic: How to avoid error "BO has been changed by another user"
Replies: 8
Views: 292

How to avoid error "BO has been changed by another user"

I am struggling with the error message " [BO] has been changed by another user. Please get the latest version of the data and try the operation again. " when saving the form of that BO. The situation is as follows: I have a BO 'Transaction' which owns multiple 'LineItems'. There are BO rules for bot...