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