[Qt-interest] Variants and Binds

[Tony Rietwyk]

Hi Bill, 

Are you saying that the Oracle driver doesn't support date/time natively?
That it internally modifies the query to to use strings?  That seems very
strange to me! 

I've used the Oracle OCI interface from Delphi without any such problems.
In my Qt project, it only uses the IBase driver, which handles date/time
using the existing variants.  The driver goes through some hoops to convert
to the format used by the ISC routines, but that is to be expected.  I would
have thought the OCI driver would be the same.  

Regards, 

Tony


> -----Original Message-----
> From: Bill King [mailto:bill.king at nokia.com] 
> Sent: Thursday, 24 September 2009 13:06
> To: ext Jason H
> Cc: Tony Rietwyk; qt-interest at trolltech.com
> Subject: Re: [Qt-interest] Variants and Binds
> 
> 
> Actually, I think qRegisterMetaTypeStreamOperators<> () may be more
> along the lines of what you're looking for.
> 
> On 09/24/2009 11:15 AM, ext Jason H wrote:
> > Right, but something somewhere Qt is serializing my date to 
> be to_char('2001-01-01', 'YYYY-MM-DD'). I'd like to do the 
> same for my data type, except my serialization  is just not 
> quoting the string value. I would have hoped that the 
> registering with QVariant would have allowed me to do that... 
> Where QDate is  to_char '%1', 'YYYY-MM-DD'), I'd just have it 
> output %1 (no quotes) and my problem would be solved.
> >
> > But thanks for your help.