Myquery1:Type Mismatch for field 'say',expecting:integer Actual:Largeint

Myquery1:Type Mismatch for field 'say',expecting:integer Actual:Largeint

Postby Guest » Mon 03 Jan 2005 10:57

hi

I am use mydac 2.00 3.6 with delphi 6.

my query :

SELECT *,count(price) AS mycount FROM rezervation group by stockcode

but to meet error Myquery1:

Type Mismatch for field 'say',expecting:integer Actual:Largeint

this error from where to weld

please help :roll:
Guest
 

Re: Myquery1:Type Mismatch for field 'say',expecting:integer Actual:Largeint

Postby Ikar » Wed 05 Jan 2005 09:57

You create fields at design-time and then change type of "say" field at the server. Re-create this field in fields editor.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Sometimes this will not help

Postby ramajana » Fri 07 Jan 2005 10:35

If you use result of calculation, MySQL changes field size depending on calculation result. You should in cases like that wrap field calculation in SQL with CONVERT or CAST call.

Example:

convert(trim(concat(contacts.first_name,' ',contacts.last_name)),char)
ramajana
 
Posts: 10
Joined: Tue 23 Nov 2004 17:22


Return to MySQL Data Access Components