Addnew fails when

[harbans]

This problem is about recordset functionality.
Actually, When using RFX_Int, value 32484 is being treated as null and
can't be entered.
So converting RFX_Int into RFX_Long and type casting the variable to
long can solve this problem.
Look at the link:
http://support.microsoft.com/kb/170257/en-us

But again, value 1246576928 is being treated as null in case of
RFX_Long.
And when tried to type cast the variable to double, it shows the
fractional truncation error and numeric out of range error.
So wouid anyone please let me know:
1)How to resolve the issue?
2) How value can be entered in database without using recordset?


Thanks in advance
Harbans

 

[mlimber]

This problem is about recordset functionality.

[snip]

And as such, it is a Microsoft-specific question and is off-topic here.
See this FAQ for what is on-topic in this newsgroup and for a list of
some better places to try posting:

http://www.parashift.com/c++-faq-lite/how-to-post.html#faq-5.9

Cheers! --M