Search found 1142 matches

by ACDC
Wed Nov 08, 2023 6:53 pm
Forum: General discussion and questions about Aware IM
Topic: Next Version Release Date - any news ?
Replies: 9
Views: 100101

Next Version Release Date - any news ?

Any news on the next Version release date and features ?
by ACDC
Fri Oct 27, 2023 11:09 pm
Forum: General discussion and questions about Aware IM
Topic: Propietry Database Design change utility
Replies: 10
Views: 46293

Re: Propietry Database Design change utility

Use InvoiceItem.Invoice.ID > 0
This seems to be a solution and more efficient than COUNT I suppose?
Is this the preferred method then, albeit very different thinking?
by ACDC
Fri Oct 27, 2023 6:49 pm
Forum: General discussion and questions about Aware IM
Topic: Propietry Database Design change utility
Replies: 10
Views: 46293

Re: Propietry Database Design change utility

The IS UNDEFINED limitation is outlined here Though I believe there is another issue that is undocumented. Top I am not sure if it is the same issue, if it is, then it should be described better with other examples. If you do not know about this the app becomes dysfunctional and takes a while to re...
by ACDC
Wed Oct 25, 2023 8:36 pm
Forum: Problem reports
Topic: Configurator - memory leaks,
Replies: 14
Views: 75123

Re: Configurator - memory leaks,

I don't ever have Config tool crashes, except as I said earlier in the thread after an update if I didn't update memory settings. If you go to the CRM example and make changes to the menu layout in the Visual Perspective by dropping and dragging and inserting new items you WILL get an error. (last ...
by ACDC
Wed Oct 25, 2023 8:09 pm
Forum: Problem reports
Topic: Configurator - memory leaks,
Replies: 14
Views: 75123

Re: Configurator - memory leaks,

Bugs.. they happen.. but Save should f'n Save. Period.
I feel your pain, been there many times :cry: :cry:

The only save button I use is this one (its a tiny button you have to look for it,why it can't be bigger and more visible in the center i'll never know)
by ACDC
Wed Oct 25, 2023 7:27 pm
Forum: General discussion and questions about Aware IM
Topic: Propietry Database Design change utility
Replies: 10
Views: 46293

Re: Propietry Database Design change utility

If you create Pet first and then create Owner and Vet then create the m:n relationships to Pet then you will end up with Owner_Ref and Vet_Ref. Would this method not be the correct method to setup the relationship then. This would get around one table pointing to multiple tables for the fk This is ...
by ACDC
Sun Oct 15, 2023 5:01 pm
Forum: General discussion and questions about Aware IM
Topic: Propietry Database Design change utility
Replies: 10
Views: 46293

Re: Propietry Database Design change utility

It is easy, and will not break aware for you to manually create foreign keys. I thought Aware would become dysfunctional with the presence of these keys. This is good news and seems an easy solution. I wonder why Aware does not create these automatically, just to be more compatible with outside too...
by ACDC
Sat Oct 14, 2023 11:14 pm
Forum: General discussion and questions about Aware IM
Topic: Propietry Database Design change utility
Replies: 10
Views: 46293

Propietry Database Design change utility

AwareIM has its own proprietary way of configuring a database with regard to Primary Keys and references. This makes it impossible or very difficult to use third-party reporting and BI tools. Does anyone know exactly where the differences are and how one would go about modifying an AwareIM-based dat...
by ACDC
Fri Sep 29, 2023 8:43 pm
Forum: General discussion and questions about Aware IM
Topic: How to Format Column Totals in Grid
Replies: 6
Views: 32149

Re: How to Format Column Totals in Grid

I'm afraid neither of the above is working. Thats strange, this works for me: (on a Query Grid, not sure about a form Grid) <div style="text-align: right;background" font-weight: 900; background-color: #d3d3d30a; ><<SUM GenLedger.Credit@#,##0.00>></div> Did you remove the $ and the comma after the ...
by ACDC
Fri Sep 29, 2023 5:41 pm
Forum: General discussion and questions about Aware IM
Topic: How to Format Column Totals in Grid
Replies: 6
Views: 32149

Re: How to Format Column Totals in Grid

This will work for number formatting in the grid

<b>Total Income: <<SUM Income.Amount@#,##0.00>></b>

As to the $, you may have to use html,
by ACDC
Wed Sep 27, 2023 4:15 pm
Forum: General discussion and questions about Aware IM
Topic: AS_STRING European Formatted Number
Replies: 1
Views: 22628

Re: AS_STRING European Formatted Number

I seem to recall something similar, the "," versus the "." is managed by the locale, Kendo culture specific (This could be a clue)
by ACDC
Sun Sep 24, 2023 6:01 pm
Forum: General discussion and questions about Aware IM
Topic: Operation on Single References -default icons - Change
Replies: 1
Views: 11278

Operation on Single References -default icons - Change

I wish to change the default icons on all my single references to better suite the theme At the moment I am using the "Display image on button" utility on the reference to make the change Any suggestions on how I could go about doing this so it's a system-wide change, as it is not a simple css chang...
by ACDC
Sun Sep 10, 2023 6:16 pm
Forum: Wish List
Topic: Managing Styles - Forms
Replies: 1
Views: 13909

Managing Styles - Forms

Re Manage Styles - Forms For some reason, a single reference defaults to a Grid widget. I almost always have to change the widget to a Combo Box drop-down. Not sure if others have the same experience, should it not default to a Combo Box ? Alternatively managing the style seems to be the answer, but...
by ACDC
Fri Sep 08, 2023 5:59 am
Forum: General discussion and questions about Aware IM
Topic: Database latency - all suggestions appreciated, will compensate
Replies: 37
Views: 124571

Re: Database latency - all suggestions appreciated, will compensate

Hard disagree on this. Database should always be segregated from App server Could you provide some reasoning behind this, other than just making a statement? my reasoning was efficiency and shutting down a point of direct access to the DB, not to mention the complexities that go with managing a DB ...
by ACDC
Thu Sep 07, 2023 8:38 pm
Forum: General discussion and questions about Aware IM
Topic: Database latency - all suggestions appreciated, will compensate
Replies: 37
Views: 124571

Re: Database latency - all suggestions appreciated, will compensate

So before I take action, I'm looking for what action makes the most sense. Interested in your thoughts. I don't see the point in running a dedicated DB server within the context of an AwareIM app. It's just another thing that can go wrong, and I've always considered it less secure. Frankly, the obv...