Replace syntax - help

[Rahul2kind]

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

[Medicus]

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

[MartinLiss]

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

[wossname]

Martin, I think Rahul's talkin about databases dude

[Rahul2kind]

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

[Rahul2kind]

Any Solution or Suggestion

[plenderj]

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.

[Rahul2kind]

Thanks

For sql syntax

update item set qty = 0

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

[Rahul2kind]

Can anybody tell me the SQL syntax


Thanks

[flavorjatin]

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.

[Rahul2kind]

The sql statement is not working in MSAccess

update item set qty = 0

qty is numeric field

Giving runtime error : '3219' invalid operation

[Rahul2kind]

Any solutions ?????

[plenderj]

Perhaps try something like this ?

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

[Rahul2kind]

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


----------

[Rahul2kind]

Check for solution

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