"Unknown Error"

Posted on 2002-05-19
Last Modified: 2010-04-04
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
Question by:Bagon

Accepted Solution

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).

Expert Comment

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.
Paul (pnh73)
EE Cleanup Volunteer

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
loading dll from external path 1 212
Machine not responding during CopyFile() 3 89
Convert a string into a TDateTime 5 52
creating threads in delphi 1 84
A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

863 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

Need Help in Real-Time?

Connect with top rated Experts

28 Experts available now in Live!

Get 1:1 Help Now