Aware IM User Forums

I have a headache from a problem that I am trying to solve in the most efficient way possible. I have a cashbook BO which is basically a recording of lines on a bank statement. The entries may be made daily or weekly (or even monthly). I want to be able to generate a running balance at Weekly Monthl...

So, I generally avoided using the SQL Editor in the Query Builder in v7.x because it wasn't possible to have a separate test DB but now that we have the ability to utilise dedicated test and production databases in v8 I've now got a whole bunch of views that I'd like to build in SQL. Whilst I can go...

And finally Annual comes to the same as month Whilst the numbers should look like: Only difference to all of these queries are the grouping on the X axis to Automatic, Week, Month, Year

I have 4 identical queries that search for: FIND Finance_Cashbook WHERE Finance_Cashbook.ob_Statement.ob_Bank=LoggedInRegularUser.VPL_FinBankAcc ORDER BY Finance_Cashbook.DateTransaction DESC Three of these identical queries are to produce charts. The difference in the charts is the roll up of the d...

I really need to display the currency symbol inside grids and I also have thousands of currency attributes throughout my application. Don't really want to change thousands of attributes just to display properly in grids! Hope this can be fixed or I am missing something! Thanks Not really an answer ...

I've copped out and just used a standard query of the Contact_Bank WHERE Contact_Bank.ob_Contact = LIRU.ob_Tenant.ps_RelatedContact.

I will look at 'prettying' it up with a custom query later on.

I have a hierarchy of records: Tenant om_Contacts om_BankAccounts Tenant ps_RelatedContactRecord om_BankAccounts om_Statements So the Tenant record has its own Contact Record and this Contact has Statements (via the Bank Account). I need to create a Cashbook which is essentially just a running state...

me too - I have a lot of Statement like BOs that are key entered (no chance of automation at moment - paper based).

Found the Create problem - data truncation issue

I've just started to play with the LoginNotification objects and I'm confused between the difference between: When LoginNotification is received and When LoginNotification is created I've had a look at the sample apps and they all seem to use only the When Received. Is there a specific meaning appli...

aware_support wrote:You are displaying the wrong list. The list of functions is displayed separately (F4 on Windows as opposed to F3, something else on Mac - see the text above the controls)

Oops

aware_support wrote:The TRANSLATE function is part of the list, so not sure why you couldn't find it

See screenshot - Build 2375 (Mac Configurator, LINUX AIM Server)

Appears to have been fixed by Build 2375

Thanks Mark! Wasn't expecting as involved an explanation, that's great. The issue is that I am trying to get round is on input fields - where their mandatory state is based on other field values, so the HTML route doesn't work in this case. I've taken a rather crude route to fixing the problem. As t...

Thanks Mark, I'm not sure I understand. I was hoping that there was a way to manipulate the css value for a field along the lines of what is discussed here and here What I am trying to achieve is a Render script that finds the value of a field, checks it's value and then inserts the class type into ...