• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 446
  • Last Modified:

Error on ADO Table

I'm using Delphi 7 and I'm trying to connect to MSSQL 7 using ADO components

ado conection
and ado table

when I run the application it sends the following exception
 EVariantTypeCastError 'Could not convert variant of type(null) into type(string)

How Can I avoid this?

Thanks
0
mavi740218
Asked:
mavi740218
2 Solutions
 
GummiStoriCommented:
What are you trying to do? (open, etc...)
0
 
mavi740218Author Commented:
I just set Active property to True, I just have a dbgrid and a dbnavigator I can see the information but the error raises every time
0
 
kretzschmarCommented:
if this does only happen within the ide
-> then ignore

if this also happens outside the ide
(close the ide and run your exe)
-> then try to create persistent fields
( doubleclick on tadotable
, rightclick on the poped-up field editor
, select "Add All Fields" from the popup-menu)

then you may evaluate which field causes this error
(maybe its a large Varchar-field) and try different fieldtypes of tfield-property)

hope thats it

meikl ;-)
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
khalil_moghaddamCommented:
what about your DataSet? do u have Calculated field?
did you use field editor or set field type manually?
0
 
CleanupPingCommented:
mavi740218:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
 
kacorretiredCommented:
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 for this question:
       to split points between kretzschmar and khalil_moghaddam
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Some days and here is the Christmas Time. I wish good luck and good health for you all and for your loved ones

kacor
EE Cleanup Volunteer
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now