Search found 441 matches

by rbross
Fri Nov 06, 2020 6:43 pm
Forum: General discussion and questions about Aware IM
Topic: Changed Values revert to Original after First Time Use
Replies: 9
Views: 7508

Re: Changed Values revert to Original after First Time Use

Colin, Attached is a sample bsv for you to look at that duplicates what you are looking for I think. It will create sample data for Order Header and Order Lines at at startup. Click on the Orders Button on the top left. The query will open to show the order. Click on the order and the edit form will...
by rbross
Fri Nov 06, 2020 2:49 pm
Forum: General discussion and questions about Aware IM
Topic: Changed Values revert to Original after First Time Use
Replies: 9
Views: 7508

Re: Changed Values revert to Original after First Time Use

The point is that the user wants to try different selling prices and see the effect on Gross Profit without having to exit the form and reload it. At the moment they can only do it once. OK, I thought you wanted to save it then call a process. In this case you need to try what Bruce suggested. Crea...
by rbross
Fri Nov 06, 2020 5:00 am
Forum: General discussion and questions about Aware IM
Topic: Changed Values revert to Original after First Time Use
Replies: 9
Views: 7508

Re: Changed Values revert to Original after First Time Use

Your changes have not been committed yet. You could try to make Bruce’s rule dynamic or call the process after the form has been saved. You can see this property on the save button.
“Call process after save”
by rbross
Fri Nov 06, 2020 4:34 am
Forum: General discussion and questions about Aware IM
Topic: Post a msg here if you use MSSQL Express currently
Replies: 6
Views: 5731

Re: Post a msg here if you use MSSQL Express currently

I’m using it on two AwareIM applications.
Soon to be 3 I hope. One left using MySQL. Need to covert to MSSQL.
by rbross
Fri Nov 06, 2020 12:46 am
Forum: General discussion and questions about Aware IM
Topic: Virtual Records Returned to Query by Stored Procedure
Replies: 3
Views: 3700

Re: Virtual Records Returned to Query by Stored Procedure

Mark,
The time it takes sql to select the records and do the insert is less than a millisecond. The query will display without delay to the user. I do this in quite a few places and it is instant.
It’s worth leveraging the power and speed of sql.
by rbross
Thu Nov 05, 2020 11:28 pm
Forum: Problem reports
Topic: INSERT reference in not-persisted BO does not work
Replies: 13
Views: 17783

Re: INSERT reference in not-persisted BO does not work

Unfortunately np BO's cannot hold multiple values in a referenced object. it would be nice if they could. You could try ticking the check box for "Store Session Values" under the persistence property on the np BO. This will save all values for the session then discard them when the user logs out. Ma...
by rbross
Wed Nov 04, 2020 11:58 pm
Forum: Problem reports
Topic: INSERT reference in not-persisted BO does not work
Replies: 13
Views: 17783

Re: INSERT reference in not-persisted BO does not work

I’d write a sproc, You could do this in a select statement with left outer joins to get what you want and insert it into a work table that AwareIM can see then use that as your query.
Just a thought.
SQL is very fast!
by rbross
Wed Nov 04, 2020 8:45 pm
Forum: Problem reports
Topic: INSERT reference in not-persisted BO does not work
Replies: 13
Views: 17783

Re: INSERT reference in not-persisted BO does not work

This might be what you are looking for? This will only display records in the picklist that have not been previously selected. One difference is I am not using a NP BO. I don't think you need one just INSERT the reference into the BO you want. This displays a list of contacts to add as a reference t...
by rbross
Wed Nov 04, 2020 8:25 pm
Forum: Problem reports
Topic: INSERT reference in not-persisted BO does not work
Replies: 13
Views: 17783

Re: INSERT reference in not-persisted BO does not work

I think I have an example of an easier way to do this. I will look for it and post it for you.
by rbross
Fri Dec 13, 2019 4:11 pm
Forum: General discussion and questions about Aware IM
Topic: Exception exporting document...(Access Denied)
Replies: 4
Views: 6075

Re: Exception exporting document...(Access Denied)

The path was wrong. You have to start at the tomcat folder. with
EXPORT BOName TO '../Tomcat/webapps/AwareIM/foldername/filename (Optional is EXCLUDE RELATIONSHIPS APPEND) that's if you want to add to what you are exporting.
by rbross
Mon Dec 09, 2019 1:25 am
Forum: General discussion and questions about Aware IM
Topic: Improving the Combo Box. DrillDown button needed
Replies: 6
Views: 8008

Re: Improving the Combo Box. DrillDown button needed

In addition to what Jaymer is requesting on a combo box. If there was a new property that let you call a process to show a popup that would be great. When entering a new record it would still show the plus icon if the option was selected but if a value was selected then you had the option to call a ...
by rbross
Tue Nov 12, 2019 2:21 pm
Forum: General discussion and questions about Aware IM
Topic: item display rules on child grid on parent BO form
Replies: 1
Views: 5363

item display rules on child grid on parent BO form

Hello, The grid is on the parent form and the Item display rules do not seem to be working. Even if I add a Presentation rule on the child bo the row color and the displayed attribute on the grid will now change color? Does this feature only work on stand-alone queries and not on queries displayed o...
by rbross
Wed Oct 23, 2019 1:23 pm
Forum: General discussion and questions about Aware IM
Topic: date format as EEE MM/dd/yyyy
Replies: 6
Views: 7902

Re: date format as EEE MM/dd/yyyy

Looks like 'EEE' is not a supported AwareIM date format yet. I added a 'DateString' Attribute and used this rule to convert the date and get the format I needed. BOname.DateString=CHARS_FROM_LEFT(DAY_OF_WEEK(BOname.Date),3)+' '+AS_STRING(BOname.Date,'MM/dd/yyyy') AwareIM support, it would be nice t...
by rbross
Wed Oct 23, 2019 1:16 pm
Forum: General discussion and questions about Aware IM
Topic: date format as EEE MM/dd/yyyy
Replies: 6
Views: 7902

Re: date format as EEE MM/dd/yyyy

Jaymer wrote:try ddd

I started with that and it did not work. Keep in mind the format was entered under the Format property on the attribute on the BO. If you look at all the available formats to choose from 'EEE' is not included in any of them. Also in the user's guide 'E' is no list in supported formats.