I get an Error message.........

My database is SQL SERVER.
I have set "lookup field" (I make a field with lookup type) at TADOQuery.
When I append data, so I always get an error "....EOleException Class,...An
unknown error has occurred". But if I edit data, I don't get its error. Is
it true, that was caused I have set "lookup field" at TADOQuery? If yes,
does it mean that "lookup field" cann't work properly? and how to solve its
problem so efficien?

Can TADOQuery input data to database? Mention, object that can input data to
database like as TADOTable?



.

Relevant Pages

  • Re: I get an Error message.........
    ... >I have set "lookup field" at TADOQuery. ... >unknown error has occurred". ... But if I edit data, ...
    (borland.public.delphi.database.ado)
  • RE: Error message form is locked
    ... strange as that would limit the values to something that is in another table. ... OK it's not a Lookup field. ... there's always the chance of corruption. ... I have a white paper in a Word document named Fix Corrupt Access Database ...
    (microsoft.public.access.gettingstarted)
  • RE: Error message form is locked
    ... OK it's not a Lookup field. ... there's always the chance of corruption. ... I have a white paper in a Word document named Fix Corrupt Access Database ... Jerry Whittle, Microsoft Access MVP ...
    (microsoft.public.access.gettingstarted)
  • Re: Beginners DB Design Question
    ... enforced relationships are an integral part of the database ... relational model and are crucial to protecting the integrity of the data, ... described it while having used the lookup field wizard. ... Ken Sheridan ...
    (microsoft.public.access.gettingstarted)
  • Re: Losing the value of a field
    ... but unfortunately I cant change the database. ... I'd like to know if I use the TADOQuery with 'locktype' property set to ... 'batchoptimistc' (what means that the chages will ramain local and are not ...
    (borland.public.delphi.database.ado)