Inserting a numeric variable from VB to a SQL table

[herci]

hi..

I am trying to insert a numeric value from visual basic but
i don't know the right way to write the format of the comand text. I can insert a string variable like such:

dim cadena as string
cmdinsrt.comandtext = "Insert publisher" & _
"values ('" & cadena & "')

cmdinsrt.execute

How can I insert a numeric value?

any kind of information will be appreciated

 

[vb5prgrmr]

insert into tablename(fieldname1,fieldname2,etc) values(value1,value2,etc)

 

[reply]

sorry..
I want to insert a Visual Basic numeric variable to a sql table..

Thanks again!

 

[vb5prgrmr]

The Name of the variable???? or its value????

 

[sunaj]

Hi,

In SQL, strings are defined with single quotes ('). In vb it's double quotes(&quot. Simply leave out the single quotes in your SQL statement to insert a numerical value. However, in order to create the VB string that makes up the SQL statement, you'll have to convert the numeric value to a VB string. Get the logic? It looks like this:

MyConnection.Execute "INSERT INTO tblMyTable(MyNumericField) VALUES (" & cstr(MyVBNumericValue) & &quot"


Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'