Hi!

First of all thx for the .net Firebird provider.

I have a question regarding the parameter length and the error code 335544321

I'm using the provider with NHibernate and getting the above error
when issuing the following query:

SELECT count(*) as y0_ FROM Drzava this_ WHERE this_.Aktivan = @p0 and
lower(this_.Oznaka) like @p1; @p0 = 'True', @p1 = '%a%'

my Drzava table has the following structure:
CREATE TABLE DRZAVA (
   ID NUMERIC (18, 0) NOT NULL,
   NAZIV VARCHAR (60) CHARACTER SET WIN1250 COLLATE WIN1250,
   OZNAKA VARCHAR (2) CHARACTER SET WIN1250 COLLATE WIN1250,
   AKTIVAN SMALLINT);

ALTER TABLE DRZAVA ADD PRIMARY KEY (ID);

I know that I'm getting this error becouse the OZNAKA field is
Varchar(2) and my parameter is 3 character long, but is there a way to
run this query
succefully? This query is running in isql.

Thx

PS: sorry if I double posted but for me seams that my first message
isn't delivered
Zoltan

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to