Replace Function Parameters

[rjstephan]

How do you make a collection reference to all fields in a table as the first argument in the Replace function of A2K? I want to replace ABC with XYZ in all fields in a table.
Thanks.

 

[WayneRyan]

rj,

The Replace function only takes strings as arguments. You
will have to iterate through each of the fields and pass
their values to the Replace function. Also, you will have
to interate through each record in the table.

Wayne

 

[CajunCenturion]

You can also include a call to the Replace function, or I've seen in some cases where you need a wrapper around the Replace, in an SQL Update statement.

UPDATE <tablename>
SET <fieldname> = Relace(<fieldname>, <from>, <to>)


Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein