Aware IM User Forums

Jaymer, if you're referring to a setting within SQL Server, this is not something we can change. Is there a way to implement case-insensitive SQL Server searching from within AwareIM?

Thanks again.

Jaymer, I'm sorry - are you referring to a setting within AwareIM or SQL Server?

Music to my ears. Thanks so much, Jaymer!

When searching for matches for user-entered AwareIM form fields in an external SQL Server 2012 db, what's the best way to make the query case-insensitive? The following statements (using SQL Server functions and AwareIM functions respectively) generate the error "Internal error. Unable to convert qu...

Thanks very much, PointsWell! Greatly appreciated!

How do I capture the results of PICK ONE OR MORE FROM to a single comma-delimited string? Let's say we're picking 10 state abbreviations out of 50 and want to store the result as "TX,CA,KY,NY,MO,..." etc. I've defined a string to hold the result (LoggedInRegularUser.tmp_States). Immediately followin...

Thank you, Jaymer! Perfect! That's the piece I was missing. Really appreciate it!

Looking for high level direction. I have a PICK FROM query. I have a 10-parameter (SQL Server) stored procedure called by EXEC_SP. The 10 parameters are to hold (up to) 10 instances of column 1 of the PICK FROM query results. How do I reference the picked rows (instance prefixes?) in order to use th...

Thanks, Jaymer. My apologies, you're exactly right. I finally got it working and what I did was define the numeric field as datatype float rather than decimal in SQL Server. I generated an Aware table and seeing as it defined the numeric field as float, I put that into my external table def and the ...

It works for me as well, if I make the table internal. Importing business object STATEMENT 37 Record for row 1 imported successfully 37 Record for row 2 imported successfully 37 Record for row 3 imported successfully 37 Record for row 4 imported successfully 37 Record for row 5 imported successfully...

Thanks, Jaymer. It must have something to do with my table being external. It doesn't reside in the Aware db (though it is on the same db server). I have an external stored procedure that uses it, and the table is in the same db as the sproc. It's such a simple thing though, you'd think Aware could ...

I just realized that numeric values ending literally in '.00' DO get loaded, so it's not necessarily the decimal point character that seems to be causing the issue. For example, record two in the following file loads successfully. So do the integers. Just not the non-'.00' decimals: Input CSV: 10685...

Hi, Jaymer. Thanks. Version 8.3, build 2621.

No luck adding the format to the csv header. Loading this file: Invoice,Amount #.00 1068511166,1295.12 1068511167,2380.00 1068511168,1190.1 1068511170,1190 2003595372,-1190 1068511171,2380 I get this output: Importing business object STATEMENT Failure for row 1: 1068511166,1295.12 Internal error. Er...

Thank you. The file being imported is a user-provided file and cannot have a header (though I will try your header suggestion to see the result). I'm importing using a template and specifying a Type of Number and a Format of #.00 in the 'Column Names and Formatting' dialog of the AwareIM import temp...