it is odd that mssql cannot compare a varchar with a text. How does your dal query look like?
On Feb 25, 4:22 pm, Stef Mientki <[email protected]> wrote: > hello, > > How should I test a text-type field in a mssql database > > Query = DB_Mod.Field_Ex.Tabel == '%s' % ( Name ) > > where the field "Tabel" is a text-type field, > gives the following error. > > ProgrammingError: ('42000', '[42000] [Microsoft][ODBC SQL Server Driver][SQL > Server] > The data types text and varchar are incompatible in the equal to operator. > (402) (SQLExecDirectW)') > > Changing the type to "string" seems to work ok. > > thanks, > Stef Mientki
