Aware IM User Forums

I have the same question. Are there any examples of how to do this?

But apparently they only work with Derby. I use this extensively in MySql That's interesting. This is what it says in Appendix B of the User Guide: 4. The following functions are supported only in Cloudscape/Derby database: - WORD_NUMBER - WORDS_FROM_LEFT - WORDS_FROM_RIGHT I also tried this and it...

intra wrote:Maybe something along the lines of this.

FullString = John Smith

Firstname = SUBSTRING(FullString, 0,INDEX_OF(' ',FullString))
Surname = SUBSTRING(FullString, INDEX_OF(' ',FullString),LENGTH(FullString))

Thanks, that works.

ACDC wrote:

But apparently they only work with Derby.

I use this extensively in MySql

That's interesting. This is what it says in Appendix B of the User Guide:

4. The following functions are supported only in Cloudscape/Derby database:
- WORD_NUMBER
- WORDS_FROM_LEFT
- WORDS_FROM_RIGHT

I have a Full Name attribute that I want to split into FirstName and LastName attributes. I thought I could use the WORDS_FROM_LEFT or WORDS_FROM_RIGHT functions to do this. But apparently they only work with Derby.

So, I am wondering what is the easiest way to do this in Aware?

Jaymer,

That would certainly make the process more efficient.

But, is that really going to impact the ability to Cancel a running process?

Jim

In this particular case the process does the following: FIND CaseNotes WHERE CaseNotes.Note='requested discovery' AND CaseNotes.NoteType IS UNDEFINED IN BATCHES OF 1 FIND mfNoteTypes WHERE mfNoteTypes.NoteType='REQUEST FOR DISCOVERY' INSERT mfNoteTypes IN CaseNotes.NoteType Pretty basic stuff really...

In my opinion, this issue is subject to each individual application. Rennur, see below... Things to check: 1) Incorrect/faulty design/use of Business object groups. No Business Object groups defined 2) Ensure all SHOW SECTION_START, SECTION_END in document templates are properly enclosed. This does...

Is there some trick to Cancelling an Active Process? For example: I have a process that updates a certain attribute in a BO. I start the process and have it run in background after 5 seconds (Which is another topic in itself, because I don't know whose clock that 5 seconds runs on but it is more lik...

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