|
-
Nov 24th, 2003, 04:02 PM
#1
Thread Starter
Frenzied Member
Record changes to NULL??
I am running this query to a SQL Server database using ADO 2.5
SELECT * FROM SkillValues WHERE ApplicationID=9 AND SkillID=3
Which gives me this record
mCertification = rs.Fields("Certification")
mYearsExp = rs.Fields("YearsExp")
mMonthsExp = rs.Fields("MonthsExp")
The problem is when mCertification takes the value from rs.Fields("Certification") it changes to NULL. If I put a break point on mCertification = rs.Fields("Certification") and hover my mouse over rs.Fields("Certification"), it tells me the value is "any" which is the string value in the database, so far everything is good. But when I hit F8 to actually give that value to mCertification, I get an error saying "Invalid use of NULL". When I click debug and hover over rs.Fields("Certification") is now says the value is NULL. Any ideas?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|