Page 1 of 1

Firebird - Type mismatch for field

Posted: 29.04.2009, 18:42
by tcmdvm
Delphi 2009
Firebird 2.1
Zeoslib7-svn 628

I have a project that I am testing that was migrated from Delphi 2007 and the stable version of Zeoslib.

I am getting the following error: EDatabase Error with message MyQuery: Type mismatch for field 'Myfield; expecting: String, actual WideString.

Is there anyway to fix this??

Posted: 29.04.2009, 18:48
by seawolf
Can you specify SQL fields of that table?

Posted: 29.04.2009, 21:02
by tcmdvm
Could you be more specific in your question? I am not sure what you are asking.

I have a form with all of my datamodules on it. It is where all of the queries are located. When I need to use one in the program I open it, use it, and then close it. The queries are created using SQL in the TZQuery.

It not limited to one query but several.

Posted: 29.04.2009, 21:30
by seawolf
Which kind of type is "Myfield"? A string? VarChar?

Or can you provide an example of a query which gives you this error?

Posted: 29.04.2009, 22:12
by tcmdvm
Myfield is defined in the database as Char(8). It is a string field. It is also the primary key field for the table.

The query's SQL: select * from invhead