Search found 1642 matches
- Fri Sep 29, 2023 10:23 pm
- Forum: General discussion and questions about Aware IM
- Topic: How to Format Column Totals in Grid
- Replies: 6
- Views: 47693
Re: How to Format Column Totals in Grid
I suspect either this item is not fully built out or there are limitations.
- Fri Sep 29, 2023 7:55 pm
- Forum: General discussion and questions about Aware IM
- Topic: How to Format Column Totals in Grid
- Replies: 6
- Views: 47693
Re: How to Format Column Totals in Grid
I'm afraid neither of the above is working.
- Thu Sep 28, 2023 1:44 pm
- Forum: General discussion and questions about Aware IM
- Topic: How to Format Column Totals in Grid
- Replies: 6
- Views: 47693
How to Format Column Totals in Grid
How do I format a column total as currency?
Here's what does not work.
Here's what does not work.
- Mon Sep 11, 2023 12:27 pm
- Forum: General discussion and questions about Aware IM
- Topic: I Think I Must Be Going Crazy :-|
- Replies: 5
- Views: 30479
Re: I Think I Must Be Going Crazy :-|
Have you reviewed the logs?
- Wed Sep 06, 2023 7:59 pm
- Forum: General discussion and questions about Aware IM
- Topic: Database latency - all suggestions appreciated, will compensate
- Replies: 37
- Views: 170095
Re: [UPDATE] Database latency - all suggestions appreciated
For those following this saga, I replicated the AWS database server to a new EC2 instance and installed a spare AIM license on it, running it locally (localhost). To my surprise, the latency was simply not there. All of the latent queries were normal. For example, a query that is now taking 33 secon...
- Wed Sep 06, 2023 5:30 pm
- Forum: General discussion and questions about Aware IM
- Topic: Trouble Editing Toolbar on Forms/Queries
- Replies: 1
- Views: 13083
Trouble Editing Toolbar on Forms/Queries
When editing Panel Operations on a query, I can move items up or down but cannot see the context of the full menu. When I Edit the Toolbar, there are no features to position items within the toolbar. Am I missing something?
- Wed Sep 06, 2023 12:44 am
- Forum: General discussion and questions about Aware IM
- Topic: Database latency - all suggestions appreciated, will compensate
- Replies: 37
- Views: 170095
Re: Database latency - all suggestions appreciated, will compensate
I've spun up a replica db server with AIM installed so I can start going in that direction with some tests.
Thanks
Thanks
- Sun Sep 03, 2023 11:08 pm
- Forum: Problem reports
- Topic: Import Action not working
- Replies: 4
- Views: 26508
Re: Import Action not working
This file is from a customer who got it from some other unknown source. I'm just happy to close the case with a lesson learned.
- Sun Sep 03, 2023 4:25 pm
- Forum: Problem reports
- Topic: Import Action not working
- Replies: 4
- Views: 26508
Re: Import Action not working (RESOLVED]
Good on you!
You got me thinking. The doc looked fine in a text editor. However, I saved it as TXT using ANSI (usually cleans our the boogers). renamed it to .csv. Then it worked.
Good job and many thanks!
You got me thinking. The doc looked fine in a text editor. However, I saved it as TXT using ANSI (usually cleans our the boogers). renamed it to .csv. Then it worked.
Good job and many thanks!
- Sat Sep 02, 2023 2:36 pm
- Forum: Problem reports
- Topic: Import Action not working
- Replies: 4
- Views: 26508
Import Action not working
I have an import function for end users that employs the IMPORT action: IMPORT [object] FROM [file] WITH VALIDATION This has worked fine for years and I have not altered anything since instituting it. It gets used but I am unsure how often but I recently got a report that it was claiming the header ...
- Fri Sep 01, 2023 2:59 pm
- Forum: General discussion and questions about Aware IM
- Topic: Database latency - all suggestions appreciated, will compensate
- Replies: 37
- Views: 170095
Re: Database latency - all suggestions appreciated, will compensate
Sadly, nothing offered yet has helped. It really behaves as though an index is shot somewhere but I have carefully reviewed the server log for everything it does for this query and have examined all relevant tables and run a number of test queries mimicking those in this query process. They all run ...
- Fri Sep 01, 2023 2:50 pm
- Forum: Problem reports
- Topic: BASServer.Props SessionTimeout value is overwritten
- Replies: 0
- Views: 88894
BASServer.Props SessionTimeout value is overwritten
When editing the General items from the Control Panel, any setting changes (including no changes to the Timeout setting) overwrites the SessionTimeout value in BASServer.Props usually with a long negative value. Interestingly, this only occurs on my production server (running Professional) but does ...
- Mon Aug 28, 2023 1:08 am
- Forum: General discussion and questions about Aware IM
- Topic: Database latency - all suggestions appreciated, will compensate
- Replies: 37
- Views: 170095
Re: Database latency - all suggestions appreciated, will compensate
Many thanks. Shall try.
- Sun Aug 27, 2023 3:54 pm
- Forum: General discussion and questions about Aware IM
- Topic: Database latency - all suggestions appreciated, will compensate
- Replies: 37
- Views: 170095
Re: Database latency - all suggestions appreciated, will compensate
Here is my question to ChatGPT: "On MySQL database, if I remove the primary key, save the change, and then set it back, does it regenerate the index?" Answer: If you remove the primary key from a MySQL database table, the index is also removed ¹. If you then set the primary key back, it will regener...
- Sat Aug 26, 2023 7:28 pm
- Forum: General discussion and questions about Aware IM
- Topic: Database latency - all suggestions appreciated, will compensate
- Replies: 37
- Views: 170095
Re: Database latency - all suggestions appreciated, will compensate
Good thoughts but I don't really think it's the query since other queries, and even the general query on this table from the administrator object query is very slow. My.ini: # Other default tuning values # MySQL Server Instance Configuration File # ---------------------------------------------------...