Case Change Blank Title 93466

Use VB.NET on the form text box itself, capture the KeyPress event,
if Chr(97) lower case "a", send Chr(65) upper case "A" instead.

This way you aren't even touching any of the application's logic, you're just
altering what data is on the form, leaving the app to process your pre-scrubbed
data.





________________________________
From: Aaron <aaronmclements@...>
To: vantage@yahoogroups.com
Sent: Tue, September 14, 2010 3:30:50 PM
Subject: [Vantage] Re: Case Change


Of these choices, I'm most comfortable with BPMs. However when I tried this
with a BPM I can't seem to get the new values to "write" to the database. I'm
missing something fundamental here.

--- In vantage@yahoogroups.com, "Sean McDaniel" <smcdaniel@...> wrote:
>
> I would think that you could do any of the following, assuming that the serial
># is not case sensitive:
> customization using the BO objects -- safe but slow
> service connect -- safe but slow
> BPM that does this -- like if you update the company information or something
>to then go off and loop through the serial # table
> create a .r program to update the database directly
>
> ________________________________
>
> From: vantage@yahoogroups.com on behalf of Aaron
> Sent: Tue 9/14/2010 9:48 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Case Change
>
>
>
>
> I'm looking for ideas on how to comb our SerialNo table and convert all lower
>case serial numbers to uppercase. Anyone have any tips or tricks?
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>







[Non-text portions of this message have been removed]
I'm looking for ideas on how to comb our SerialNo table and convert all lower case serial numbers to uppercase. Anyone have any tips or tricks?
I would think that you could do any of the following, assuming that the serial # is not case sensitive:
customization using the BO objects -- safe but slow
service connect -- safe but slow
BPM that does this -- like if you update the company information or something to then go off and loop through the serial # table
create a .r program to update the database directly

________________________________

From: vantage@yahoogroups.com on behalf of Aaron
Sent: Tue 9/14/2010 9:48 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Case Change




I'm looking for ideas on how to comb our SerialNo table and convert all lower case serial numbers to uppercase. Anyone have any tips or tricks?






[Non-text portions of this message have been removed]
We use the following code to convert all but a few fields in Customer Contact Entry to upper:

Private Sub CustCnt_BeforeFieldChange(ByVal sender As object, ByVal args As DataColumnChangeEventArgs) Handles CustCnt_Column.ColumnChanging
'// ** Argument Properties and Uses **
'// args.Row("[FieldName]")
'// args.Column, args.ProposedValue, args.Row
'
'Add Event Handler Code
'
Select Case args.Column.ColumnName

Case "EMailAddress"

Case "Character04"

Case "Character02"

Case Else

args.ProposedValue = Convert.ToString(args.ProposedValue).ToUpper()

End Select

End Sub

Ken Williams
Vice President, Administrative Services
Intermountain Electronics, Inc.
O: 877-544-2291
M: 801-918-7318
F: 435-637-9601
www.ie-corp.com

Creating customer confidence through extraordinary service and experienced industry experts.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Aaron
Sent: Tuesday, September 14, 2010 7:49 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Case Change - Email found in subject



I'm looking for ideas on how to comb our SerialNo table and convert all lower case serial numbers to uppercase. Anyone have any tips or tricks?



[Non-text portions of this message have been removed]
Of these choices, I'm most comfortable with BPMs. However when I tried this with a BPM I can't seem to get the new values to "write" to the database. I'm missing something fundamental here.

--- In vantage@yahoogroups.com, "Sean McDaniel" <smcdaniel@...> wrote:
>
> I would think that you could do any of the following, assuming that the serial # is not case sensitive:
> customization using the BO objects -- safe but slow
> service connect -- safe but slow
> BPM that does this -- like if you update the company information or something to then go off and loop through the serial # table
> create a .r program to update the database directly
>
> ________________________________
>
> From: vantage@yahoogroups.com on behalf of Aaron
> Sent: Tue 9/14/2010 9:48 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Case Change
>
>
>
>
> I'm looking for ideas on how to comb our SerialNo table and convert all lower case serial numbers to uppercase. Anyone have any tips or tricks?
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>