BorlandTalk.com

Brigitte · Guest

Bonjour,

I use Delphi 7, the database is MSAccess, and ADO components (new user with
ADO, I quit BDE because having many troubles with MSAccess).

At the beginning of the appliaction, when I open the table (table.Active :=
True), I have the following message error: "Project XXX.exe raised
exception class EVariantTypeCastError with message 'Could not convert
variant of type (Null) into type (String)'. etc..."

I don't know what it's because the code is opening the table, the log does
not show any apparent mistake and the record can be saved anyway in the
table. Later on, there is another mistake when saving some particularly
fields which could be related with the first one (like row with fields
having changed)? (need to confirm for that one).

Somebody can help me?

Thank you

Brigitte

Del M · Guest

do you have a field that does not allow nulls and you have not put data into
the field?

Brigitte · Guest

I checked this as well. In the DB I have no required fields except keys. And
to avoid the problem, I unchecked the DBcheckboxes (finally, I did not allow
grayed for checkboxes because I thought maybe is the problem) and give
values to DBComboboxes when opening the dataset.

Brigitte
"Del M" <Del.Murray (AT) CreditHawk (DOT) Net> wrote