MySQL Forums
Forum List  »  Delphi

Different Declarations
Posted by: Alberto Lombardo
Date: January 12, 2011 10:46AM

I am using Delphi 2006 with ZEOS 6.6 to connect to MySQL 5.1.

I have two different queries with similar selects, that is producing two different declaration types

The 1st query
select
...
datediff(curdate(), date_received) as "DaysInLab"
from
...
The 2nd query
select
...
datediff(date_closed, date_received) as "num_days"
from
...
Delphi delcares
DaysInLab as a TLargeintField
and
num_days as TIntegerField

Every so often, I get an error on the 2nd query saying that my query expects an integer field in num_days, but is receiving a Largeint. I simply delete num_days from the fields editor, add it again, and the query magically works again, only to happen again weeks later.

Any idea why the different declarations for what seems to be similar selects?

Options: ReplyQuote


Subject
Written By
Posted
Different Declarations
January 12, 2011 10:46AM
January 17, 2011 09:43PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.