ah cheers


I used this anyway

SQL = "UPDATE FILE_ID Set ID1 = 32 WHERE ID1=23"
CN.execute SQL
SQL = "UPDATE FILE_ID Set ID1 = 32 WHERE ID2=32"
CN.execute SQL