Search found 4238 matches

by tford
Wed Mar 23, 2022 9:26 pm
Forum: Tips and Tricks
Topic: COUNT UNIQUE VALUES
Replies: 14
Views: 88726

Re: COUNT UNIQUE VALUES

Thank you!
by tford
Tue Mar 08, 2022 3:37 am
Forum: General discussion and questions about Aware IM
Topic: Poor calendar in Aware. Why?
Replies: 17
Views: 14086

Re: Poor calendar in Aware. Why?

Code: Select all

If you are running 8.7 there is a way to prevent protection rules from being evaluated when running a query.
Is that by a setting in the query?
by tford
Mon Mar 07, 2022 2:57 am
Forum: General discussion and questions about Aware IM
Topic: Experience with heavy data processing nightly?
Replies: 4
Views: 4415

Re: Experience with heavy data processing nightly?

Always a good idea to follow Pete's advice. He taught me SO much early on during my Aware journey. In addition to his log suggestion, I've also fired off an email to system admin (myself) at the end of regularly scheduled update processing. I include key totals & time/date stamps (beginning and endi...
by tford
Sat Feb 19, 2022 1:24 am
Forum: General discussion and questions about Aware IM
Topic: Accessing MS Access Tables
Replies: 3
Views: 3228

Re: Accessing MS Access Tables

Yes, via ODBC as Roger mentioned. Back when I started using Aware in 2007, our company had an Access DB that I needed to expose to the web for our customer to see. Aware worked well. Sorry I can't begin to give you specifics as that's been a LONG time ago.
by tford
Sat Feb 12, 2022 4:00 pm
Forum: Tips and Tricks
Topic: COUNT UNIQUE VALUES
Replies: 14
Views: 88726

Re: COUNT UNIQUE VALUES

@Ddumas USE EXEC_SP, or the EXEC_SPF() function to return the value. I call stored procedures throughout my application, especially for queries. Also to set flags or calculated columns that are best left to SQL code Know them, love them ,use them Could you provide a couple examples of your use cases...
by tford
Fri Feb 04, 2022 3:55 am
Forum: General discussion and questions about Aware IM
Topic: Version 8.7 beta
Replies: 14
Views: 6037

Re: Version 8.7 beta

Rules Debugger, Performance Profiler, and interaction with Preview are huge improvements!

What is CREATE BUCKET.

I've been our of Aware development mode for over a year and not familiar with "bucket".
by tford
Thu Jan 27, 2022 1:32 am
Forum: General discussion and questions about Aware IM
Topic: Using Aware rule engine
Replies: 2
Views: 1412

Re: Using Aware rule engine

Thanks Henrik
by tford
Thu Jan 13, 2022 2:13 am
Forum: General discussion and questions about Aware IM
Topic: Using Aware rule engine
Replies: 2
Views: 1412

Using Aware rule engine

Is there anyone using AwareIM rules engine to make external database updates when Aware is called from another program?

Considering this as a use case where we have existing front end UI's and might leverage the simplicity of the Aware rules engine.
by tford
Thu Jan 28, 2021 6:15 pm
Forum: General discussion and questions about Aware IM
Topic: custom query template examples
Replies: 6
Views: 7524

Re: custom query template examples

Nice share, Jaymer!!
by tford
Mon Jan 18, 2021 7:51 pm
Forum: Wish List
Topic: FR - phpBB improvements
Replies: 6
Views: 24812

Re: FR - phpBB improvements

I would consider posting more tricks if I knew that they did in fact come in handy for other users. I've posted a lot of tips over my years in Aware IM land. While some posts didn't get much comment traction early on, over time comments were made either on the forums or by PM that confirmed people ...
by tford
Tue Jan 05, 2021 3:19 pm
Forum: General discussion and questions about Aware IM
Topic: Displaying Updated totals after inline editing
Replies: 10
Views: 6104

Re: Displaying Updated totals after inline editing

The solution here is to use COUNT instead to establish if OrderLines exist
One other option is to add an OrderLines_Count attribute to OrderHeader and use a rule to keep the new attribute current.
by tford
Thu Dec 10, 2020 2:11 am
Forum: Tips and Tricks
Topic: MySQL profiler tools
Replies: 2
Views: 17922

Re: MySQL profiler tools

Would you mind sharing some examples of how you would use these?
by tford
Wed Nov 25, 2020 5:41 pm
Forum: General discussion and questions about Aware IM
Topic: Refresh the form via rule script
Replies: 2
Views: 3427

Re: Refresh the form via rule script

EDIT or VIEW the form again ?
by tford
Tue Nov 24, 2020 2:47 pm
Forum: General discussion and questions about Aware IM
Topic: Feature request: a TimeOut URL - set in BSV
Replies: 16
Views: 17890

Re: Feature request: a TimeOut URL - set in BSV

Is part of this request to also have the user's screen IMMEDIATELY be sent to the specified URL when the timeout occurs (like what happens when you are on a banking site)?