Aware IM User Forums

I attended this sublime workshop. It provides a lot of useful information and it ensures that you go quickly to the next level in a pleasant way.
Mark is a great coach who can perfectly guide you to take major steps forward relatively quickly.

= Jannes

Issue : When adding a record to the child-grid an extra [Close] is shown on the screen Steps : 1) Show Query (parent table) 2) Click 1 record to edit 3) The edit screen is shown : parent + child-grid 4) Click [New] to add a new child-record The normal [Close] and [Save] buttons are shown (OK) But al...

The question is : Are there functions like in other languages like - NVL(value, 'Something') - CASE WHEN a=b THEN .. - DECODE(supplier_id, 10000, 'IBM', 10001, 'Microsoft', 10002, 'Hewlett Packard', 'Gateway') result So they can be used in ORDER BY etc.. Or do we have to add and use Calculated Field...

How to deal with NULL values in rules ?
Is it possible to use "DECODE" or "NVL" like in Oracle..?

Example : find records sorted on date_input, when empty use current-date :

FIND <table> WHERE <..> ORDER BY NVL(date_input, CURRENT_DATE)

Table with 2 fields : Name : Plain text Period : Number I want to update (increase) field “period” by 1 In SQL : UPDATE person SET period = period + 1 WHERE period > 2017 I expect : FIND Persoon WHERE Persoon.Period > 2017 Persoon.Period=Persoon.Period + 1 But this doesn’t work properly, all selecte...

External database : Cassandra DB The primary key is : bedrijf, soortlid An update-statement (by AwareIM) tries also to update these primary key fields. So an error is raised : The connection '29' query failed to execute query : UPDATE soortlid SET bedrijf=?, omschrijving=?, soortlid=? WHERE bedrijf=...

I used the CRM demo application to create a new business space.

After login via the browser I don't see the expected starting page.
How to connect the user to the first starting page ?

= Jannes

Would it be possible to use another JDBC-driver like
https://repo1.maven.org/maven2/com/data ... -4.1.0.jar

?

I changed CLASSPATH and now it works..!

I like to use AwareIM with Cassandra database (http://cassandra.apache.org) It seems to be an ideal scenario to develop modern mainstream applications. I didn't succeed yet to connect Cassandra via a JDBC-driver. AwareIM and Cassandra are successfully installed on our server = Windows 2012 . Java : ...