>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.
lcField = field(nColumn)
update mytable set &lcField = 222 where MyField = "SomeValue"
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.