yes , of course id , but he struggles
cmdSql.Parameters.Add("field2", vrcbotext )
I cannot get to put the parameter after the cmdSql. i can't see the
parameteroption in the list who's available fo the sqlcmd. and in the
errorsection is written that parameter is not a member of the string.
Also i get error on the last line said he is not a member of a string.
"Cor Ligthert[MVP]" <notmyfirstname@xxxxxx> schreef in bericht
> Hi Rob,
> Did you look at the code I made?
> "Rob" <ROb@xxxxxx> schreef in bericht
>> hi Cord
>> The database is an access database.
>> I give it a try in the newgroup you propose.
>> If you get the answer anyway, don't hasitate to replay.
>> Kindley regards, Rob
>> "Cor Ligthert[MVP]" <notmyfirstname@xxxxxx> schreef in bericht
>>> I do this in this message so be aware of errors.
>>> 'vrTxtfield1 and vrcbotext are two variabels which containes the new
>>> data i need to store.
>>> dim newsql as string = "INSERT INTO tbltest(field1, field2)VALUES
>>> (@Param1, @Param2)"
>>> Dim cmdsql As New OleDb.OleDbCommand(newsql , cn)
>>> cmdSql.Parameters.Add("@Param2",vrcbotext )
>>> I cannot see what database you use, as that is a version of SQL server
>>> then you can use better SQLClient instead of OleDB, in a real version
>>> you should also add error trapping by a try catch block.
>>> Better newsgroups for you are probably
>>> or maybe the very inactive newsgroup