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
Myquery1:Type Mismatch for field 'say',expecting:integer Actual:Largeint
Re: Myquery1:Type Mismatch for field 'say',expecting:integer Actual:Largeint
You create fields at design-time and then change type of "say" field at the server. Re-create this field in fields editor.
Sometimes this will not help
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)
Example:
convert(trim(concat(contacts.first_name,' ',contacts.last_name)),char)