Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Andrzejek on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting error in passing numeric value from vb.net(2005) to visual foxpro(9) table.

Status
Not open for further replies.
Sehaj

Sehaj

Programmer
Apr 21, 2014
1
Getting an error "Data Type Mismatch" when passing numeric value from vb.net to visual foxpro table.

The structure for field "pack price" is numeric(15,6) in visual foxpro.

The vb.net line which is showing error is :

cmd36.Parameters.AddWithValue("pack_price", CDec(txttotalprice.Text).ToString("N6")).

Kindly advice.
 
Sort by date Sort by votes
Perhaps FoxPro doesn't like you converting the value to a string?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
scraping table in web page 3
2
Replies
24
Views
3K
strongm
strongm
2009luca
  • Locked
  • Question
GET splitted value from node and sub node in treeview
Replies
1
Views
229
Andrzejek
Andrzejek
marty1944
  • Locked
  • Question
error code 380 when trying to run the visual basic v6 deployment wizard
Replies
1
Views
494
marty1944
marty1944
sal21
  • Locked
  • Question
GET VALUE FROM HREF IN WEB PAGE
Replies
3
Views
269
strongm
strongm
sal21
  • Locked
  • Question
how to read the coordinates in from this file
Replies
3
Views
268
Ken01
Ken01

Part and Inventory Search

Sponsor

Back
Top