Visual Studio Query Builder filter

From: Patrick Donelan <pdonelan(at)optusnet(dot)com(dot)au>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Visual Studio Query Builder filter
Date: 2006-03-03 04:20:03
Message-ID: 4407C3F3.4050204@optusnet.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Apologies if this is largely a Visual Studio 2005 question. I'm posting
it here because I assume my problem is caused by the interaction between
psqlODBC and Visual Studio. I'm using psqlODBC 8.01.02.00.

When using the graphical Query Builder tool, you can specify a filter
for your query. For example, if you specify the filter for table column
x as " = sometext' then you get:
WHERE x = 'sometext'
in your query.

All well and good if the column is of type text, but if the column is of
type Boolean I can't figure out how to get the damn thing to accept my
filter. For example:
" = 't'"
" = t"
" = true"
etc...
all don't work, saying that the data is of the wrong type.

Ok, so you're wondering why I don't just write my query the good old
fashioned way? The problem is if the Query Builder doesn't like your
query, it spits the dummy when it tries to generate the FillBy and GetBy
queries needed to use VS 2005 TableAdaptors.

The only workaround I've found so far is to create a dummy function that
always returns true and use that in the filter, eg.
" = alwaysTrue(12345)"

Any ideas on how to get it to accept my filter as boolean so I don't
have to use this workaround?

Regards,

Patrick

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Patrick Donelan 2006-03-03 10:56:01 Re: Visual Studio Query Builder filter
Previous Message Daniel Holm 2006-03-02 19:36:18 Re: pgsql ODBC 8.1.200 MSSQL Migration Errors