Information générale
Catégorie:
Visual FoxPro et .NET
>I've been stuck trying to figure this one out. In an ASP VB web page, I am doing an insert into a VFP table and 1 field is numeric. One insert parameter that has its parameter source bound to a textbox is to be inserted into this table whose field is the numeric one called RECID.Command is this:
>
>SqlDataSourceDash6.InsertCommand = "insert into dash6 (docid,routid,fscm,part_nbr,u_I,quantity,requisiton,jon,recid) values (?,?,?,?,?,?,?,?,?)"
>if I make the RECID field of type char, I do not get "Data type mismatch" at all
Let's see. You're writing to a Fox table so you know the table structure, and the field in question is definitely numeric. Does the insert statement work if you hard code some values instead of the parameters? (That would check your Insert statement.)
You're getting the parameter value from input to your web page. What exactly is the value you're sending? Can you check it before your insert occurs? Any chance something in the web page isn't working as expected and you're getting a character value assigned to your parameter?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement