Search found 441 matches
- 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...
- 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...
- 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”
“Call process after save”
- 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.
Soon to be 3 I hope. One left using MySQL. Need to covert to MSSQL.
- Fri Nov 06, 2020 12:50 am
- Forum: General discussion and questions about Aware IM
- Topic: FUNCTION TO CONVERT (NUMBER TO TEXT) / (CURRENCY TO WORDS) AWARE IM VERSION 8.X
- Replies: 2
- Views: 3448
Re: FUNCTION TO CONVERT (NUMBER TO TEXT) / (CURRENCY TO WORDS) AWARE IM VERSION 8.X
I have a bo that demonstrates this. I will upload it so you can review it.
- 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.
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.
- 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...
- 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!
Just a thought.
SQL is very fast!
- 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...
- 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.
- 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.
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.
- 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 ...
- 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...
- 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...
- 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.