updating field extents


New Member
hello guys

i need to update a field extent using JDBC. Here is the code that works in progress editor but gives an error through JDBC
UPDATE dbSchemePrice SET price[1]=24000,billPerSqM[1]=NO WHERE scheme=1.

the same code through JDBC would give this error
java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Syntax error in SQL statement at or about "[1]=24000.0, billPerSqM[1]=0" (10713)

is there a way to get around this.