Aware IM User Forums

Never mind. Apparently those functions are only supported in Cloudscape or Derby.

I have a name attribute that is being entered as FIRST NAME and then LASTNAME. I want to pull out the first name as a calculated column on a query. So I have the expression entered as: WORDS_FROM_LEFT (CaseMaster.CaseAssistant.FullName,1) When I run the query I get the following: Internal error. Inv...

The following CSS and HTML gives a two column output on a HTML page: /* Create two equal columns that floats next to each other */ .awarecolumn { float: left; width: 50%; padding: 10px; height: 300px; /* Should be removed. Only for demonstration */ } /* Clear floats after the columns */ .awarerow:af...

No. These are just stored in the File System.

I did and ran into an issue when I tried to update each record in my BO with the size of the media file. I keep running into a max packet size limit in MySql. Some of these files are big, really big, as in 3 to 4gig and Aware seems to have a problem somewhere in dealing with them. Which actually bri...

I want to show the sizes for files that have been uploaded to an app, so I put a Calculated Column on a Query with the following for the Calculation: FILE_SIZE(MediaFiles.MediaDocument) Should be pretty straight forward shouldn't it? All it shows though is '0' for the value on every single record. W...

This is probably a dumb question, but I was wondering if it is possible to reset a value to null once an attribute has had a value. Specifically I have a Picture field in a BO that was assigned a value. I want to keep the instance of the BO, but I want to clear out the value in the Picture attribute...

I have a need to take media files that are referenced in a BO and download them to a folder. I am using the following: EXPORT DOCUMENT MediaFiles.MediaDocument TO FOLDER 'c:\temp\' This works except for one small problem. It is copying them to drive 'C' on the server not on the local computer where ...

In the app I am working on there is a Media BO that can contain either images or videos. When we click on the image name to view them they come up zoomed in about 200% and we have to scroll to see more of the image (up and down). Is there a way to set what sizing I want to see the image at when I vi...

How do you pass data from the current context into the BO in that case?

I have a process I am calling from a Query. That process creates an instance of a Non Persistent BO called Prompt. With this: CREATE Prompt WITH Prompt.Date=CURRENT_TIMESTAMP,Prompt.UserID=LoggedInRegularUser,Prompt.Purpose='Test Non-Persistent BO Creation' Then I have the process run an EDIT on tha...

I have tried putting a shortcut point to the Case BO from the Client but Aware doesn't seem to like that. What I may do is just put a CaseCount attribute in the Client BO and count how many there are and use that.

I have a Client Query. On it I have a button in the Operations with Records that will go to a Case Query for the Client; No problem so far. I want that button though to only show up if there are actually Cases for the Client. I tried putting the following in the "Applicable when" property... ClientM...

I am moving a text file into a BO and am getting some errors on certain characters from a note type field. If I just do an import through MySQL the error says: Invalid utf-8 character string. This seems to be happening when someone has entered a contraction: e.g. instead of entering "it is" they ent...

That is an interesting thought.

But, is Vimeo HIPAA compliant? Also, most of these are highly confidential Body Cam and Case Investigation videos. Does Vimeo allow for the security requirements that would go with that?