Search found 173 matches

by UnionSystems
Fri Mar 19, 2021 5:10 am
Forum: General discussion and questions about Aware IM
Topic: Maria DB on Mac
Replies: 5
Views: 234

Re: Maria DB on Mac

Perhaps you have mySQL still running? By default mySQL and mariaDB use the same port of 3306 so they cannot run at the same time.
by UnionSystems
Fri Jan 15, 2021 6:37 pm
Forum: General discussion and questions about Aware IM
Topic: Windows or Linux?
Replies: 4
Views: 972

Re: Windows or Linux?

We’d prefer to use Linux but you need to run a Windows AwareIM server if you want to use the User Defined Documents functionality with MS Word or MS Excel documents as you need to have MS Word installed on the AwareIM server?
by UnionSystems
Thu Jan 07, 2021 11:56 pm
Forum: Tips and Tricks
Topic: (free) native app RAD with REST
Replies: 29
Views: 5072

Re: (free) native app RAD with REST

Hi Henrik, AppGyver is still looking very good. Need to do user acceptance testing of the App yet but it seems to deliver exactly what we want. I look forward to demonstrating the App at the next AwareIM conference. The gossip is there is a good chance it will be held in 2037. For client side storag...
by UnionSystems
Tue Jan 05, 2021 12:31 am
Forum: Tips and Tricks
Topic: (free) native app RAD with REST
Replies: 29
Views: 5072

Re: (free) native app RAD with REST

I should add AppGyver is very good BUT it is no replacement for AwareIM. Using AppGyver has reminded us of how very much AwareIM does!!! AppGyver is looking very promising as a platform to present AwareIM managed data into a "native" mobile App.
by UnionSystems
Mon Jan 04, 2021 11:11 pm
Forum: Tips and Tricks
Topic: (free) native app RAD with REST
Replies: 29
Views: 5072

Re: (free) native app RAD with REST

We've been testing out AppGyver trialling replacing an existing native app. It has a great user interface and active forum and is showing promise as a way of leveraging AwareIM's REST facilities. One issue we have is how AwareIM constructs a REST response when it returns a SINGLE item where MULTIPLE...
by UnionSystems
Tue Oct 20, 2020 9:56 am
Forum: General discussion and questions about Aware IM
Topic: Virtual Records Returned to Query by Stored Procedure
Replies: 3
Views: 912

Re: Virtual Records Returned to Query by Stored Procedure

Hi Mark, To resolve this we’ve used a stored procedure to actually INSERT records into a temporary mySQL/mariaDB table and then querying that table so we can pass data to “Operations With Records”. Having real rows behind the query also seems to enable the column filters to work in the Query (filter...
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: 2918

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: 847

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: 1428

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: 1236

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: 1236

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: 3533

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: 1872

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: 1801

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