Questions about aware im

[karima]

Hi!
I have some questions to finish the evalution of Aware Im.

1) I begin to realize some queries, and i've seen that Aware im is very sensitive with the "casse "(Uppercase and lowercase). How can i force the user to write lowercase?

2) How can i download, open and save file with aware im?
My files are not stored in the database, but on my server.

3) Can I use Spotlight through SQL queries in Aware Im?
If somebody has already use Spotlight with Aware Im, can u give me an example.

Thanks for all the details you can give me!

[christopherb]

1)
TO_LOWER_CASE(ob.attribute) CONTAINS TO_LOWER_CASE(?'Form Field)

2)
Not really sure what you are asking

3)
Though I have not used it, there should be no reason why you couldn't use Spotlight to monitor Sql performance and such.


Good luck,
Chris

[karima]

Thank you for answering so quickly.
Regarding documents (attachments), it's files that I would like to open or save through Aware im.
Is it possible, can I create input area to retrieve my files or shall we have our files register in Derby database?

[christopherb]

Sorry for sounding like a dunce but what exactly are you trying to save?

[karima]

just files like word, excel or pdf files

[greg]

1. Case sensitivity. It is a feature of Derby database. You can run Aware on MySQL which is nit case sensitive. Or use the default Derby with the low case conversion solution as per Christopher's note.

2. Saving files. Easy. You need to create an attribute of Document type. You can store files in this attribute, delete them, replace with new version, download from the database to your workstation, etc.

greg

[tford]

Re: #2 - Saving Files -- one other neat feature is that you can easily email stored documents. In one application I allow the LoggedIn user to click a button to email a document to themself.

Tom