Search found 1248 matches

by rocketman
Thu Oct 05, 2023 4:35 pm
Forum: General discussion and questions about Aware IM
Topic: How to Format Column Totals in Grid
Replies: 6
Views: 29909

Re: How to Format Column Totals in Grid

The reason why it is not working is because in the bounded RED area you have two commas which signals to AwareIM that you have three variable, Income.Amount then a variable with $# then another variable containing ##0 You could try changing the $#,##0 to be $#.##0 and see if either the attribute for...
by rocketman
Sun Sep 17, 2023 11:51 pm
Forum: General discussion and questions about Aware IM
Topic: FIND ALL, SEARCH_COUNT seems to override READ PROTECT Filter
Replies: 13
Views: 66343

Re: FIND ALL, SEARCH_COUNT seems to override READ PROTECT Filter

I find the logic strange here. The READ PROTECT statement is usually placed in the RULES of the BO, and they don't fire when a query is run and a list is obtained. They only trigger when you enter edit or view mode (or this is my understanding). The protection is not permanently held against a recor...
by rocketman
Sun Sep 17, 2023 11:31 pm
Forum: General discussion and questions about Aware IM
Topic: 2 questions re MySQL
Replies: 1
Views: 16428

2 questions re MySQL

So I successfully migrated over to a new server (Windows server 2022 running on AMD 6 core, 12 thread 3.6Ghz - flies like a bullet) All systems working BUT I am getting a lot (like 36,000 in 12 hours) of BAD Handshake (event ID 100) with the provide MySQL in my event viewer logs Just wondered if any...
by rocketman
Thu Aug 24, 2023 10:52 pm
Forum: General discussion and questions about Aware IM
Topic: *SOLVED* (YAY!!) REST/XERO I am now officially bald
Replies: 7
Views: 35384

Re: *SOLVED* (YAY!!) REST/XERO I am now officially bald

I've already found out (I think) that those numbers in the brackets are seconds not milliseconds past a linux epoch start date WTF!!!. Yes, the digits are the number of (I believe) milliseconds past an epoch. Also called "Unix Time" or "POSIX Time" 1692795459269 => Wednesday, August 23, 2023 12:57:...
by rocketman
Thu Aug 24, 2023 12:16 am
Forum: General discussion and questions about Aware IM
Topic: *SOLVED* (YAY!!) REST/XERO I am now officially bald
Replies: 7
Views: 35384

Re: *SOLVED* (YAY!!) REST/XERO I am now officially bald

Rocketman, Does that mean you know what to do with those formats and you just need to write the rules? Or do you need assistance with them? This is all new to me Bobk - flying by seat of pants. Never seen an output like this before. I was kinda hoping AIM would convert it automatically but no such ...
by rocketman
Wed Aug 23, 2023 4:07 pm
Forum: General discussion and questions about Aware IM
Topic: *SOLVED* (YAY!!) REST/XERO I am now officially bald
Replies: 7
Views: 35384

Re: *SOLVED* (YAY!!) REST/XERO I am now officially bald

Thanks Jaymer - see my edited original post. When I put the top level in, I forgot to change the VIEW target. all good now - even dare I say fantastic (says he with fingers crossed) 2 months to a good integration I reckon.

Just need to work on those DateTimeUTC formats
by rocketman
Wed Aug 23, 2023 2:49 pm
Forum: General discussion and questions about Aware IM
Topic: More database things I don't know about testing/publishing
Replies: 3
Views: 13031

Re: More database things I don't know about testing/publishing

I tripped over something like this once. So (if I have misunderstood, apologies in advance) 1) You made some additions/changes to the BSV and put it into test mode. Test database gets updated with all the additions/changes 2) You restored an earlier version that does not contain the additions/change...
by rocketman
Wed Aug 23, 2023 1:54 pm
Forum: General discussion and questions about Aware IM
Topic: Database latency - all suggestions appreciated, will compensate
Replies: 37
Views: 120254

Re: Database latency - all suggestions appreciated, will compensate

I had speed issues when I suddenly found about 300 items in Execution context (still haven't bottomed out why they don't get deleted, since they are all idle). bottom line - It eats your memory and TBH, 8Gb ain't that much these days. I have also know a large EC object to cause the overnight backups...
by rocketman
Wed Aug 23, 2023 1:39 pm
Forum: General discussion and questions about Aware IM
Topic: *SOLVED* (YAY!!) REST/XERO I am now officially bald
Replies: 7
Views: 35384

*SOLVED* (YAY!!) REST/XERO I am now officially bald

I am now officially bald having torn all my hair out. Following an excellent post by @Gabitas, I started working on an accounting interface to Xero. succesfully made a call, got my tenant ID to the demo company etc, then thought I'd start small and just GET the account details for the BANK accounts....
by rocketman
Tue Jul 25, 2023 8:41 am
Forum: General discussion and questions about Aware IM
Topic: Several business spaces with a single database
Replies: 17
Views: 38929

Re: Several business spaces with a single database

I define several access levels, each has its own Visuable perspective (use at login). That way I can not only define in the access level what users can and can’t see/edit but also give each access level it’s own set of menus via its VP. So a mere mortal (member) never gets to even see any of the acc...
by rocketman
Sat Jul 22, 2023 10:53 pm
Forum: General discussion and questions about Aware IM
Topic: Problem Displaying a URL in a new tab
Replies: 5
Views: 12402

Re: Problem Displaying a URL in a new tab

@jaymer @joben I suspect it's a security policy thing. I don't get a blank tab, I actually get a grey background with a sad face icon (although I had to scroll down half a mile to find the face). And yes there is a small amount of network traffic. Anyway, I'm just boning up on the Discord developer ...
by rocketman
Tue Jul 18, 2023 2:59 pm
Forum: General discussion and questions about Aware IM
Topic: Problem Displaying a URL in a new tab
Replies: 5
Views: 12402

Re: Problem Displaying a URL in a new tab

I’m not knowingly using an iframe - unless AIM builds on in the background. It’s just the built in

DISPLAY URL urlstring NEW TAB ‘tab name ’

But thanks for the response
by rocketman
Sun Jul 16, 2023 11:42 am
Forum: General discussion and questions about Aware IM
Topic: Problem Displaying a URL in a new tab
Replies: 5
Views: 12402

Problem Displaying a URL in a new tab

Having a problem using DISPLAY URL BO.URLSTRING, in that it will display ok in a new WINDOW (beautifully in fact), but won't display in a NEW TAB 'Tabname' The url in question is a link to a discord Voice Channel if that makes any difference. It would be nice to be able to keep the connection "in ap...
by rocketman
Sun Jul 16, 2023 11:33 am
Forum: General discussion and questions about Aware IM
Topic: Rgistering new users
Replies: 0
Views: 49871

Rgistering new users

I have a problem when using the logonGuest.aw url to allow access for registering new users. When I use the command "Register User" from a menu item, the user can fill in the details on their record, and the record is saved ok, but they immediately get a "Connection Failure" message. They then have ...
by rocketman
Sun Jul 02, 2023 10:44 pm
Forum: General discussion and questions about Aware IM
Topic: Concatenate text in calculated column
Replies: 2
Views: 4126

Re: Concatenate text in calculated column

Feels like unfinished business - a bit like summing duration attributes in a group (circa 2014)