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

[Guest]

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

[Ikar]

You create fields at design-time and then change type of "say" field at the server. Re-create this field in fields editor.

[ramajana]

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)