General information
Category:
Coding, syntax & commands
Title:
Field Names, Field Values
I am trying to do a replace statement inside of a loop that replaces information in another table
MY loop
Starts at record 1 takes the first field name and takes its value and replaces a value in another table.
Whenever I try to do this i keep getting the actual field name and not the values that are stored in that field?
heres my loop
for fld_val=1 to fcount()
?fld_val
goto 1
select c_statement
append blank
do while !eof()
select audit
X=recno()
select c_statement
field ="c_statement.account" + alltrim(str(X))
select audit
FLD_NAM=field(fld_val)
replace &field with fld_nam
select audit
if !eof()
skip
select c_statement
go top
endif
enddo
endfor
The replace statement takes the actual field name can I get what is stored in that field for the record i am on?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only