Search found 1476 matches

by BLOMASKY
Thu Sep 21, 2023 11:54 pm
Forum: General discussion and questions about Aware IM
Topic: INDEX keyword
Replies: 7
Views: 37917

Re: INDEX keyword

Since you have had no answers, I figure I would just spit ball here....

1). Can you enter the name in []. i.e. [index]?

2). Can you create a calculated field in the table that references the "Index" column?

3). Can you create a view where you rename the "index" column?


Bruce
by BLOMASKY
Mon Sep 18, 2023 3:22 pm
Forum: General discussion and questions about Aware IM
Topic: Control what displays when clicking on pin on Google Map
Replies: 1
Views: 32277

Control what displays when clicking on pin on Google Map

When I click on the red pin, I see the following. It is one attribute in the BO used in the query but I do not need the date. How do I control which attribute is displayed in the popup box?

Thanks
Bruce
Screenshot 2023-09-18 at 11.17.28 AM.png
Screenshot 2023-09-18 at 11.17.28 AM.png (224.85 KiB) Viewed 32277 times
by BLOMASKY
Mon Sep 18, 2023 2:17 pm
Forum: General discussion and questions about Aware IM
Topic: Change color of pins on google map
Replies: 1
Views: 32854

Change color of pins on google map

How can I conditionally change the color of the pins when creating a google map? Right now they are all a nice bright red.

Thanks
Bruce
by BLOMASKY
Tue Aug 29, 2023 1:33 am
Forum: General discussion and questions about Aware IM
Topic: Database latency - all suggestions appreciated, will compensate
Replies: 37
Views: 139829

Re: Database latency - all suggestions appreciated, will compensate

1st disclaimer I can't even spell mysql. I only use MSSQL so my suggestions might not make any sense but I would: 1). Open whatever tool you use to access the DB and create and run an INSERT statement and see if it takes more than a second. If it is fast then it is NOT a DB issue with the main table...
by BLOMASKY
Wed Aug 16, 2023 10:20 pm
Forum: General discussion and questions about Aware IM
Topic: How to default Image to computed string
Replies: 1
Views: 11700

How to default Image to computed string

I have an entry form where I want to display an image with the name "PreTrip" + 5 character LoginName. Each user has a 5 character login name. i.e. Bruce When the starts to enter a PreTrip record, I want the image (which is stored in the file system) to default and display on the form. It should def...
by BLOMASKY
Sat Jul 22, 2023 12:09 am
Forum: General discussion and questions about Aware IM
Topic: Mac Apple Silicon (M Chips)
Replies: 4
Views: 7967

Re: Mac Apple Silicon (M Chips)

works for me. Have MSQL running under Docker and AIM connecting to it.

Bruce
by BLOMASKY
Sat Jul 15, 2023 6:08 pm
Forum: General discussion and questions about Aware IM
Topic: Find 1 record, Delete 2???
Replies: 5
Views: 10722

Re: Find 1 record, Delete 2???

I thought it would only delete the LAST find.

Thanks

Bruce
by BLOMASKY
Sat Jul 15, 2023 12:53 am
Forum: General discussion and questions about Aware IM
Topic: Find 1 record, Delete 2???
Replies: 5
Views: 10722

Find 1 record, Delete 2???

This is version 8.8 build 3127. The screen shot shows it all. I have a FIND that returns 1 record, then next line is a DELETE and if there are only 2 records in the BO it deletes them both. If I have more then it usually works OK.

Any suggestions?
Screenshot 2023-07-14 at 8.11.40 PM.png
Screenshot 2023-07-14 at 8.11.40 PM.png (420.91 KiB) Viewed 10722 times
by BLOMASKY
Fri Jun 30, 2023 7:41 pm
Forum: General discussion and questions about Aware IM
Topic: Stored Procedure EXEC_SP: Internal error. Error converting data type nvarchar to int.
Replies: 4
Views: 5696

Re: Stored Procedure EXEC_SP: Internal error. Error converting data type nvarchar to int.

Umm, you did NOT declare your @INCREMENT as OUT. Thats they only way SQL server knows which variable(s) to return. Also, since this is a stored procedure, there are NO delare statements for the params. just the variable names after the procedure name and before the AS. i.e. CREATE PROCEDURE Foobar @...
by BLOMASKY
Fri Jun 30, 2023 7:38 pm
Forum: General discussion and questions about Aware IM
Topic: Why does this schedule not run
Replies: 6
Views: 16142

Re: Why does this schedule not run

I always thought dates had to be in ''. Learn something new each day. T

hanks Mark
by BLOMASKY
Tue Jun 27, 2023 8:58 pm
Forum: General discussion and questions about Aware IM
Topic: Why does this schedule not run
Replies: 6
Views: 16142

Re: Why does this schedule not run

Still does not work:

if CURRENT_HOUR = 8 AND CURRENT_MINUTE = 0
AND CURRENT_DATE > '01/01/2022'

then EmailUnitAdjustmentReport
by BLOMASKY
Tue Jun 27, 2023 12:16 am
Forum: General discussion and questions about Aware IM
Topic: Why does this schedule not run
Replies: 6
Views: 16142

Re: Why does this schedule not run

Will add the CURRENT_DATE and see if that fixes it. This is the ONLY scheduled rule I have so not a timing issue.

Bruce
by BLOMASKY
Thu Jun 22, 2023 9:24 pm
Forum: General discussion and questions about Aware IM
Topic: Why does this schedule not run
Replies: 6
Views: 16142

Why does this schedule not run

if CURRENT_HOUR = 8 AND CURRENT_MINUTE = 0 then EmailUnitAdjustmentReport I also tried: if CURRENT_TIME='08:00' then EmailUnitAdjustmentReport This is in the Scheduling section. If I run the process from the menu it works fine! (and no, I am not using Aware's email setup so that is not the problem)....
by BLOMASKY
Tue May 23, 2023 10:07 pm
Forum: General discussion and questions about Aware IM
Topic: how can I access an attribute in LoggedInRegularUser in Javascript
Replies: 2
Views: 2623

how can I access an attribute in LoggedInRegularUser in Javascript

Need to get the access level in a querys render script.

thanks

bruce