ADODC recordsource: changing the case of my strings!?

[Edd]

I'm using the ADO data control. I build a string for my SELECT statement to look up a user name, such as:

pc_select="SELECT * FROM user WHERE username='" & UCASE(username) & "'"

I then assign pc_select to .recordsource:

pc_select=.recordsource

When running the program with a breakpoint in that area, my "immediate window" shows my pc_select correctly displaying the string, for example:

"SELECT * FROM user WHERE username='MIKE'

But... after assigning pc_select to the .recordsource,
.recordsource shows:

"SELECT * FROM user WHERE username='mike'

Of course, my query never finds "mike" since it is in lower case.

Why the change of case, and how can I fix that?

 

[shmiller]

Did you mean .recordsource = pc_select?
Can you post more complete code?

 

[MikeBronner]

try this before the select statement:

username = ucase(username)

Then do this as the query:

pc_select="SELECT * FROM user WHERE username='" & username & "'"

Let me know if that works. Take Care,
Mike

 

[Edd]

I Yeah - I did mean:

.RecordSource = pc_select[\code]

I will try using Ucase to make sure the field entry gets capitalized, but it still doesn't make sense to me why the string in pc_select didn't match what was in .RecordSource.

Thanks for the tips!