Devart Forums

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

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

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)