Firebird - Type mismatch for field

tcmdvm · Post by **tcmdvm** » 29.04.2009, 18:42

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??

Post by **seawolf** » 29.04.2009, 18:48

Can you specify SQL fields of that table?

tcmdvm · Post by **tcmdvm** » 29.04.2009, 21:02

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.

Post by **seawolf** » 29.04.2009, 21:30

Which kind of type is "Myfield"? A string? VarChar?

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

tcmdvm · Post by **tcmdvm** » 29.04.2009, 22:12

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