Hi Ellis,
VFP 9 allows for binary updates via the MapBinary option to CursorSetProp:
CURSORSETPROP("MapBinary",.T.,0)
You can then use named parameters to set the value and VFP will do the binary translation.
update table where id=?lcId set binField=?lvBinValue
One of the nicest features in VFP 9 IMHO along with automatic Unicode mapping support for ODBC data.
+++ Rick ---
>Hi,
>
>I have a SQL query that selects PersonID, which is a Binary - 10. I need to build a SQLQuery string to update a different table with various values, including the PersonID. How do I convert the PersonID to a string, suitable to include in my "Update Table2 set PersonID = ????"
>
>Thanks!