Solved

"Unknown Error"

Posted on 2002-05-19
2
267 Views
Last Modified: 2010-04-04
Hi,
I have a database in mssql
I connect to the DB using TADOTables
along with the normal fields I have Lookup fields as well
when I am running my application Delphi gives me many
exceptions with the string : "Unknown Error" - which by delphi help books should never appear. this error accours but the user doesnt see a thing (not normal exception)
altough the code is not in a try except block. when Im trying to debug the problem - I cannot do it it just appear on the create of the datamodule (I dont have any code written in the on create or on any table events).
I noticed that when Im taking of the lookup fields from all the tables I dont recieve the Error (not a specific field but all of them , I tried taking them off one by one - didnt help).
does someone knows what could be the problem?
did anyone ever had this bizzare error?
if you know what to do or you some suggestions please
answer me
thanks,
bagon
0
Comment
Question by:Bagon
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 4

Accepted Solution

by:
nestorua earned 120 total points
ID: 7019796
HI, Bagon,
As for Lookup fields those "Unknown error" occurs because
of NULL field values
(The field Value of your table which references to the lookup Table is NULL).
Sincerely,
Nestorua.
0
 
LVL 1

Expert Comment

by:pnh73
ID: 9006004
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Accept answer from nestorua

Please leave any comments here within the next seven days.
 
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
 
Paul (pnh73)
EE Cleanup Volunteer
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question