Conversion from type 'DBNull' to type 'String' is not valid. (Oracle10gR2)


Author
Message
Kari Paukku
Kari Paukku
StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)
Group: Forum Members
Posts: 65, Visits: 820
Hi,

when retrieving data from Oracle database a VARCHAR2 field being NULL gives an expections. When there is text in the field then the select works ok.

What might be the problem here and how can it be solved?

TIA,

Kari

ps. I did find some other post related to null values put not quite like this. Also, when can we expect the next release with the DevExpress wrapper among other enhancements :-)

Picture attached

Attachments
nullexception.gif (208 views, 14.00 KB)
Replies
Kari Paukku
Kari Paukku
StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)
Group: Forum Members
Posts: 65, Visits: 820
Hi,

any news relating the Oracle update probkem...?

Cheers,

Kari

StrataFrame Team
S
StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
It's in the works, and I'm running the changes through the unit tests to iron out any other issues.
Kari Paukku
Kari Paukku
StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)
Group: Forum Members
Posts: 65, Visits: 820
Hi,

any news on the fix for Oracle? I today (20-JUL-06) downloaded the SF Installation package for DevEx 6.15 and tested the Oracle update. The " AND AND AND " problem is still open, I quess...?

Cheers,

Kari

StrataFrame Team
S
StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
I have it working, Kari, but I have to get the security hooks to the point that the framework is stable before I can release it.  We finished the security editors yesterday, so I believe I'll have the update posted by the end of the weekend.  Sorry for the delay, but the security and these fixes will be worth it.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Kari Paukku - 19 Years Ago
StrataFrame Team - 19 Years Ago
Kari Paukku - 19 Years Ago
Kari Paukku - 19 Years Ago
StrataFrame Team - 19 Years Ago
                         The next release will be out before I leave the office today (4 hours...
StrataFrame Team - 19 Years Ago
                             Hi, what might be the problem here: with the new relaese I still get...
Kari Paukku - 19 Years Ago
                                 Well, Kari, I'm not sure why the debug isn't working, but I'm building...
StrataFrame Team - 19 Years Ago
StrataFrame Team - 19 Years Ago
Kari Paukku - 19 Years Ago
StrataFrame Team - 19 Years Ago
Kari Paukku - 19 Years Ago
                         Kari, I am answering this from the floor of Tech-Ed and we will be...
Trent L. Taylor - 19 Years Ago
Kari Paukku - 19 Years Ago
StrataFrame Team - 19 Years Ago
Kari Paukku - 19 Years Ago
StrataFrame Team - 19 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search