Aware IM User Forums

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?

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

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.

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

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

Also if you are using grouped columns in your query (or form grid) there are 2 nested column elements :
[2] and [3] have to be set to the position of the group and column indexes.

Try using the FLOOR function.

Vlad's a legend

Try changing start of code from To

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

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

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

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

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

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