[Qt-interest] Pb to insert date with value 01.01.9999

[Mourad HEDFI]

Thanks for your quick reply.

 you can change the query to return the date as text. --> I've tried to
insert the date as a test but always the same problem.

 Are you using data bound controls, QSqlQuery and its model, a home grown
model, direct calls to Firebird….. --> I'm using the bind data to the query.

What error are you getting and when (insert or select)? --> When executing
query I've no error. But when I do a select to view inserted records,
nothing appears.

Best regards

2011/10/10 Tony Rietwyk <tony.rietwyk at rightsoft.com.au>

> Hi Hedfi, ****
>
> ** **
>
> Depending on what the app does, you can change the query to return the date
> as text.  ****
>
> ** **
>
> Please provide more information.  Are you using data bound controls,
> QSqlQuery and its model, a home grown model, direct calls to Firebird…..**
> **
>
> ** **
>
> What error are you getting and when (insert or select)? ****
>
> ** **
>
> What version of Firebird?  What data type is the column? ****
>
> ** **
>
> Regards, ****
>
> ** **
>
> Tony****
>
> ** **
>
> ** **
>
> *Sent:* Monday, 10 October 2011 10:26 PM****
>
> ** **
>
> Hello everyone,
> I've an application which inserts records into a Firebird database. But
> when I want to insert the value "01.01.9999" to a Date column, this date is
> returned invalid by Qt and I won't retreive the record in my database.
> Does anyone have an idea about this problem and can help me to resolve it.
> Best regards****
>
> ** **
>
> _______________________________________________
> Qt-interest mailing list
> Qt-interest at qt.nokia.com
> http://lists.qt.nokia.com/mailman/listinfo/qt-interest
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.qt-project.org/pipermail/qt-interest-old/attachments/20111010/e618b4c7/attachment.html