Update problems

[chuck hinkle]

This one seems strange to me.

I'm able to retrieve data from my MANS table with this statement.

    SQL = "Select Man_name from Mans order by Man_name"

But my Update statement gives me an error of Field Not Found. Does it have
anything to do with using Chr(34) to generate quote marks?

      SQL = "Update Mans set Man_name = :1 WHERE Man_name = :2 "
      SQL = SQL + "binded with {" + chr(34) + man_list.cell(row,0) + chr(34)
      SQL = SQL + ",  " + chr(34) + Hold_man_name + chr(34) + "};"



I go the same result with the statement:

    SQL = "Update Mans set Man_name = " + chr(34) + man_list_cell(row,0) +
chr(34)
    SQL = SQL + " where Man_name = " + chr(34) + Hold_man_name + chr(34) +
");"



chuck