Replace syntax - help

There is any command to replace the selected / all record to a value

table = book
field = bookname


for example in foxpro we use : replace all bookname with "VB"

whether any similar command is there in vb (other than sql command)


thanks

Rahul 2 kind
:(
----------------

I wanted the replace syntax in VB

What a strait question like an arrow.

It's * or LIKE or something.

You need to take a look at VB, ACCESS, SQL... and all the others.

The only thing here that I can see is the "/" witch could be translatted to an asterix *.

Just wait till the big guys wake up

Code:

---

    Dim strText As String
   
    strText = "apple pear orange apple grape peach apple"
   
    strText = Replace(strText, "apple", "kiwi", 1, -1)
   
    MsgBox strText

---

Martin, I think Rahul's talkin about databases dude :)

Hi !

I wanted to replace the all the data in a table to Zero

Table : Item

fields : itno, qty

VB command to replace all qty with 0 (zero).

Can any one give me a solution

Thankx


Replace :rolleyes:

Any Solution or Suggestion

I dont think there's a command that will do this for you.

What I would do is search through each record on the table and set its .Value property to 0
This is of course assuming the value of the field can be a 0.

Thanks

For sql syntax

update item set qty = 0

But it is not working can anybody tell me the SQL syntax

Can anybody tell me the SQL syntax


Thanks

hi,

SQL syntax you tried is perfectly fine with numeric field. If you are changing value in text field make sure to put quotes.

bye.

The sql statement is not working in MSAccess

update item set qty = 0

qty is numeric field

Giving runtime error : '3219' invalid operation

Any solutions ?????
:confused:

Perhaps try something like this ?

VB Code:

Set RS = DB.OpenRecordset("SELECT * FROM CompanyInfoTable WHERE RecNum = '" & currRecNum & "'", dbOpenDynaset, dbSeeChanges, dbOptimistic)
    With RS
        .Edit
        RS.Fields("SomeField").Value = ""
        'or
        RS.Fields("SomeField").Value = 0
        'or
        RS.Fields("SomeField").Value = "0"
        .Update
    End With
End Sub

But I required the syntax so that in a single command or sets of command all the qty is set to 0

This "Update item set qty = 0 " is working when I use directly in Visdata (Visual data manager in VB) sql statement, but through vb program it is given error when I refresh.


My syntax

f1.strRSname = "update item set qty= 0"
Data2.DatabaseName = f1.strDBname
Data2.RecordSource = f1.strRSname
Data2.Refresh


----------

:confused:

Check for solution

http://www.vbforums.com/showthread.p...hreadid=102741