update

[ekin]

hello...please help me..does anybode have vb6 coding of updating records?

[rory]

Hi, is this VB6 code or VBscript?
And records being a Database?

[ekin]

its vb6..yeah,the record is database..hope u can help me..

[rory]

Hi, this is the incorrect forum, but is generally the same anyway ..

Make your connection, and if the connection is called objConn then something like this ..... variables in bold would be your table and field names etc ...

Notice the Text field has a ' around the value .. while the Number field doesnt.

objConn.Execute("Update myTable Set TxtField = '" & SomeVar1 & "', IntField = " & SomeInt & " Where id = 1")

[ekin]

Thanks Rory..the Problem Settled..