Visual Studio Query Builder filter
От | Patrick Donelan |
---|---|
Тема | Visual Studio Query Builder filter |
Дата | |
Msg-id | 4407C3F3.4050204@optusnet.com.au обсуждение исходный текст |
Ответ на | Re: pgsql ODBC 8.1.200 MSSQL Migration Errors ("Daniel Holm" <Daniel.Holm@interworksinc.com>) |
Ответы |
Re: Visual Studio Query Builder filter
|
Список | 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
В списке pgsql-odbc по дате отправления: