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
Search found 1476 matches
- Thu Sep 21, 2023 11:54 pm
- Forum: General discussion and questions about Aware IM
- Topic: INDEX keyword
- Replies: 7
- Views: 37917
- 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
Thanks
Bruce
- 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
Thanks
Bruce
- 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...
- 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...
- 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
Bruce
- 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
Thanks
Bruce
- 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?
Any suggestions?
- 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 @...
- 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
hanks Mark
- 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
if CURRENT_HOUR = 8 AND CURRENT_MINUTE = 0
AND CURRENT_DATE > '01/01/2022'
then EmailUnitAdjustmentReport
- 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
Bruce
- 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)....
- Wed May 24, 2023 2:23 pm
- Forum: General discussion and questions about Aware IM
- Topic: how can I access an attribute in LoggedInRegularUser in Javascript
- Replies: 2
- Views: 2623
Re: how can I access an attribute in LoggedInRegularUser in Javascript
You are da'man Jaymer. Muchas Gracious...
- 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
thanks
bruce