Filter on SQL VARCHAR(1)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lee Vance - 14 Jan 2008 14:48 GMT

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.

Reply to this Message

Clay Fox - 14 Jan 2008 17:48 GMT

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?

Signature

Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

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

> 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
[quoted text clipped - 5 lines]
> Is there something I'm missing? This seems like it would be an easy thing to
> do.

Reply to this Message