Search found 197 matches

by UnionSystems
Fri Oct 09, 2020 3:17 am
Forum: General discussion and questions about Aware IM
Topic: Wrapping in standard grid
Replies: 2
Views: 5330

Re: Wrapping in standard grid

Also if you are using grouped columns in your query (or form grid) there are 2 nested column elements :

Code: Select all

config.columns[2].columns[3].attributes = {style: "white-space: normal"};
[2] and [3] have to be set to the position of the group and column indexes.
by UnionSystems
Mon Oct 05, 2020 10:47 am
Forum: General discussion and questions about Aware IM
Topic: math getting part of value
Replies: 2
Views: 3062

Re: math getting part of value

Try using the FLOOR function.
by UnionSystems
Fri Aug 21, 2020 7:36 pm
Forum: General discussion and questions about Aware IM
Topic: hover text in a button
Replies: 2
Views: 3867

Re: hover text in a button

Try changing start of code from

Code: Select all

<br><button class=
To

Code: Select all

<br><button title=“this is hover text” class=
by UnionSystems
Thu Aug 13, 2020 3:50 am
Forum: General discussion and questions about Aware IM
Topic: EXEC_SQL
Replies: 1
Views: 3194

Re: EXEC_SQL

I've found a remedy to this error. If you add RETURN BO to the end of the action there is no "Internal Error" and the SQL is successfully executed. So EXEC_SQL `UPDATE CRM_Customer SET Name='John'` RETURN AnyBO works ok. (replacing CRM_Customer , Name and AnyBO with a real Business Object) Seems Awa...
by UnionSystems
Wed Aug 12, 2020 11:58 pm
Forum: General discussion and questions about Aware IM
Topic: EXEC_SQL
Replies: 1
Views: 3194

EXEC_SQL

Has anyone been able to use EXEC_SQL as described on page 397 of AwareIM 8.4 User Guide? EXEC_SQL Action This action executes the specified SQL string by invoking the database engine, for example: EXEC_SQL `UPDATE CRM_Customer SET Name='John'` When we use it (with table and column names changed to m...
by UnionSystems
Wed Jul 08, 2020 10:20 am
Forum: General discussion and questions about Aware IM
Topic: Refresh Query Panel Operation Buttons
Replies: 7
Views: 8101

Re: Refresh Query Panel Operation Buttons

Hi Mark, What we do is display the toggle value from LIRU in the actual button title and only have one button. Only pain is that the displayed value needs to be opposite to its effect. So say the objective it to show or hide a column in the Query, then the LIRU value can be either SHOW or HIDE. So w...
by UnionSystems
Wed Jun 03, 2020 12:19 pm
Forum: General discussion and questions about Aware IM
Topic: how do I send null or empty date from aware IM to stored pro
Replies: 3
Views: 4688

Re: how do I send null or empty date from aware IM to stored

When you define the SP, you can have a DEFAULT value, so if your SP looks like this: Create Procedure MYSP @param1 varchar(20) = null If you have a default value, then you can skip sending the param in your rule. . You can do this in MS SQL but unfortunately not in mySQL as mySQL does not support d...
by UnionSystems
Sat Apr 04, 2020 10:15 am
Forum: General discussion and questions about Aware IM
Topic: EXEC_SPF
Replies: 1
Views: 3523

EXEC_SPF

Is anyone have success using the new 8.4 EXEC_SPF function? It does seems that EXEC_SPF can only use Stored Procedures with an OUT parameter of type DOUBLE or INTEGER (ie you cannot return VARCHAR/TEXT)? I was also hoping to call it inside <<Tokens>> to include the OUT value in AwareIM VPs and forms...
by UnionSystems
Tue Mar 31, 2020 8:26 pm
Forum: General discussion and questions about Aware IM
Topic: Reducing SystemSettings and RegularUser Bloat
Replies: 3
Views: 5712

Reducing SystemSettings and RegularUser Bloat

A frequent AwareIM additional feature request is additional always in context objects to reduce dependence on SystemSettings and LoggedInRegularUser . I understand the common problem just using SystemSettings and LoggedInRegularUser is they get way too large (too many attributes). I am guilty of hav...
by UnionSystems
Tue Mar 31, 2020 12:09 pm
Forum: General discussion and questions about Aware IM
Topic: General Question - Rules & Processes
Replies: 18
Views: 32499

Re: General Question - Rules & Processes

Text with plenty of /* Comments */

/* Comments also seem to maintain some kind of formatting, at least maintaining line breaks */
by UnionSystems
Sat Mar 21, 2020 9:37 am
Forum: General discussion and questions about Aware IM
Topic: Which features do you want in the next release?
Replies: 204
Views: 7614580

Re: Form specific REQUIRED attribute

hpl123 wrote:The option to define attribute required PER FORM.
+1
by UnionSystems
Wed Mar 11, 2020 10:58 am
Forum: General discussion and questions about Aware IM
Topic: Which features do you want in the next release?
Replies: 204
Views: 7614580

Re: Which features do you want in the next release?

Perhaps a way to achieve control of text displayed on grid row buttons this would be if they could have their text defined with <<Object.Attribute>> syntax. Im sure you cannot do this at the moment. You can use <<Object.Attribute>> in text of other buttons but not buttons in a grid row.
by UnionSystems
Fri Feb 21, 2020 8:35 am
Forum: General discussion and questions about Aware IM
Topic: Which features do you want in the next release?
Replies: 204
Views: 7614580

Check Integrity Error Message

When a BO attribute has been deleted the Integrity Check tool (Alt + I) correctly identifies any BO forms that use that deleted attribute. Problem is the message does not include the name of the form the attribute was used by. It only nominates the panel of the form that referenced the attribute. If...
by UnionSystems
Thu Feb 13, 2020 2:07 am
Forum: General discussion and questions about Aware IM
Topic: 2020 Aware IM Developers International Conference
Replies: 22
Views: 37884

Re: 2020 Aware IM Developers International Conference

We'll fly anywhere to attend Mark's excellent AwareIM Conference (and highly recommend the event to anyone using AwareIM). The effort of taking a longish flight is trivial compared to all the work Mark donates to organising these events! January is absolutely the perfect time for most Australians as...