Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Ado and Lookup Fields

194 views
Skip to first unread message

Penny

unread,
Jul 29, 2004, 5:46:43 AM7/29/04
to
Hi,

I have a AdoDataset where I have created a lookup field which looks to a
AdoTable.
When I insert a row to AdoDataset the Keyfield of the lookup is null at the
beginning, and
appears the message

"Project test.exe raised exception Class EOleException with message 'An
unknown error has occured'. Process stopped. Use step or run to continue."

But this only happens if I run the program from Delphi, and not when I
execute the exe from disk.

Insteed when on AfterInsert I initialized the Keyfield it works fine.

Does it means that null is not allowed to keyfield, or there is something
else?


Thanks.
Any


Penny

unread,
Jul 29, 2004, 5:59:24 AM7/29/04
to
I was wrong it doesn't work on AfterPost, and the problem is that I don't
know where to initialize this, if this is the only way which I hope not.

"Penny" <pennya...@hotmail.com> wrote in message
news:4108c786$1...@newsgroups.borland.com...

Kevin Frevert

unread,
Jul 30, 2004, 6:23:04 AM7/30/04
to
Penny,

It's a handled exception inside Delphi's ADO components (ADODB.pas?). Try
setting the lookup field's LookupCache = True and/or for more information
search on the error at
http://www.fulltextsearch.com/

Good luck,
krf

"Penny" <pennya...@hotmail.com> wrote in message
news:4108c786$1...@newsgroups.borland.com...

0 new messages