quickfix-developers

[Quickfix-developers] OBDC - Null values

[Stefano F. <s.f...@kl...>]

I use ODBCStore, ODBCLog and Oracle database, when a quickfix's query is
similar to: 
SELECT ... FROM ... WHERE StringField=''  // '' => Empty string
I have a problem.. the syntax is not correct for my database that want
someting like this:
SELECT ... FOMT ... WHERE StringField IS NULL

My problem is at line 71 of OdbcStore, the query doesn't return result..
even if in the table there are record!!

Thanks..

-- 
View this message in context: http://www.nabble.com/OBDC---Null-values-tf2250875.html#a6242709
Sent from the QuickFIX - Dev forum at Nabble.com.

Re: [Quickfix-developers] OBDC - Null values

[Stefano F. <s.f...@kl...>]

Oren, Is possible to fix the problem..?

Thanks, Stefano.


Stefano Facchetti wrote:
> 
> I use ODBCStore, ODBCLog and Oracle database, when a quickfix's query is
> similar to: 
> SELECT ... FROM ... WHERE StringField=''  // '' => Empty string
> I have a problem.. the syntax is not correct for my database that want
> someting like this:
> SELECT ... FOMT ... WHERE StringField IS NULL
> 
> My problem is at line 71 of OdbcStore, the query doesn't return result..
> even if in the table there are record!!
> 
> Thanks..
> 
> 

-- 
View this message in context: http://www.nabble.com/OBDC---Null-values-tf2250875.html#a6260675
Sent from the QuickFIX - Dev forum at Nabble.com.

Re: [Quickfix-developers] OBDC - Null values

[Oren M. <or...@qu...>]

I'll look into it.

--oren

>=20
> Oren, Is possible to fix the problem..?
>=20
> Thanks, Stefano.
>=20
>=20
> Stefano Facchetti wrote:
> >=20
> > I use ODBCStore, ODBCLog and Oracle database, when a quickfix's
query is
> > similar to:=20
> > SELECT ... FROM ... WHERE StringField=3D''  // '' =3D> Empty string
> > I have a problem.. the syntax is not correct for my database that
want
> > someting like this:
> > SELECT ... FOMT ... WHERE StringField IS NULL