[#NH-123] Use of Case Statement Invalid in OleDb Cmd Str

NHibernate

Use of Case Statement Invalid in OleDb Cmd Str

Created: 17/Sep/04 09:45 AM Updated: 25/Oct/04 12:06 AM

Component/s:

DataProviders / Dialects

Affects Version/s:

prealpha

Fix Version/s:

None

Description

« Hide

When using a OleDb connection to an Access database (using a custom Access2000 Dialect) the command object does not recognize the use of "case" statements. When the case statement is used, the command object fails during the preparation phase.

All

Comments

Change History

Sort Order:

Ascending order - Click to sort in descending order

[ Permlink | « Hide ]

Robert Warriner - 17/Sep/04 09:46 AM

I have fixed this issue with my local copy of NHibernate by specifying that the command object use the IF construct (rather than case). I don't know if this will work with other dialects (other than Access) though.

Robert

[ Permlink | « Hide ]

Mike Doerfler - 25/Oct/04 12:06 AM

duplicate of ~~NH-124~~