Aware IM User Forums

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...

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...

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

Bruce

I thought it would only delete the LAST find.

Thanks

Bruce

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?

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 @...

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

hanks Mark

Still does not work:

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

then EmailUnitAdjustmentReport

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

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)....

You are da'man Jaymer. Muchas Gracious...

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

thanks

bruce

Perhaps this is what you want?

IF COUNT YourBO WHERE (HOUR(YourBO.datetimefield) * 60 + MINUTES (YourBO.datetimefield) = HOUR(inputdatetimefield) * 60 + MINUTES(inputDateTimeField) > 0 THEN REPORT ERROR 'dup time'

IF HOURS(timestamp) * 60 + MINUTES(timestamp) = HOURS(input timestamp) * 60 + MINUTES (input timestamp) THEN
DISPLAY MESSAGE 'this is a dup!'

Spending a couple of days up North with Roger Ross and he mentioned someone is using other font groups besides fontawesome. Wonder what other ones are being used and the pluses of them.

Thanks

Bruce