Filter on SQL VARCHAR(1)

[Lee Vance]

I've got a secondary datasource that I need to filter based on the value of
one of the fields. It is a VARCHAR(1). When I filter for the specific value
I need, "T", it does not return anything. This is not a Boolean field, it's
just a VARCHAR that accomplishes the same thing. I don't have any control
over the data type for this field.

If I query in SQL for that value, I do get records matching the criteria.
Is there something I'm missing? This seems like it would be an easy thing to
do.

 

[Clay Fox]

Hey Lee.

Have you used the Edit SQL button in the data connection setup?

You should be able to paste in the same query there as what works in SQL.

Also have you tried just dumping all of the data into a view in your form
and verifying the data you are getting and what the format of your field is?
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com