24 Feb 2015 00:44

Joined:	11/05/2007
Level:	Gold
Points:	547

Points:	2

Getting Data Type Conversion Error

In classic vb code, I am trying to get 8 digit value from textbox and assign it to recordset variable but I am Getting Data Type Conversion Error. Any ideas how can it be fixed? Make sure its classic VB6 .
If Val(txtPOINT5) > 0 Then
rstArHist("DiagP") = Val(txtPOINT5)
End If

#756696

24 Feb 2015 01:03

Joined:	29/05/2009
Level:	Gold
Points:	10380

Points:	0

hi
change your datatype int to long or bigint

Name : Dotnet Developer-2015
Email Id : kumaraspcode2009@gmail.com

'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

#756698

24 Feb 2015 01:17

Joined:	11/05/2007
Level:	Gold
Points:	547

Points:	1

Not working, same error after changing data type

#756699

24 Feb 2015 01:23

Joined:	28/04/2006
Level:	Gold
Points:	29773

Points:	3

Hai Sameer,
Do you think you can assign the value to the record-set. Record-set is used to read the data and not to modify inside the record-set.
So i think it will not work.
If you want to set the data from the Record-Set, you can do this as:


If Val(txtPOINT5) > 0 Then
rstArHist.Fields("DiagP") = Val(txtPOINT5.Value)
End If

Hope it will be helpful to you.

Regards,
Pawan Awasthi(DNS MVM)
+91 8123489140 (whatsApp), +60 14365 1476(Malaysia)
pawansoftit@gmail.com

Getting Data Type Conversion Error

About dotnetspider.com

Quick Links

General

Services