Type mismatch for field...error...please advise

[stiaan]

HI

We are testing the latest evaluation ODAC VCL component to replace our current BDE solution. So far it was a simple process, but we seem to get the following error:
Type mismatch for field NOTES, expecting: Memo actual: string

The Delphi code looks like:
Query := TOraQuery.Create( Nil );
Query.SQL.Add( );
Query.Open; = sysdate) or e.STATUS = 'K' )) ) and ( e.event_class_id = 1 or e.event_class_id = 2 or e.event_class_id = 4 or e.event_class_id = 5 or e.event_class_id = 6 ) and (e.performance_status 'C' or e.performance_status is null) and e.event_class_id = c.event_class_id order by e.Event_id Desc

Please advise.

Regards
Stiaan Pretorius
Arivia.Kom
South Africa

[/img]

[Plash]

If your TOraQuery component is placed on a form, right click the component at design time and select Fields Editor from the context menu. Remove all fields created for the TOraQuery component in the Field Editor.

If you set the SQL property at design time, you can create new fields in the Fields Editor after you remove old fields.