I am refactoring my code to replace xBase to SQL commands. In one of my routines a table columns are updated based on the column number (using field(nColumn)). When I try to use field(nColumn) in SQL UPDATE as following:
update mytable set field(nColumn) = 222 where MyField = "SomeValue"
I get error "invalid use of vfp function as an array". Is it possible to use field(x) in SQL Update?
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham