Hi Ellis,

VFP 9 allows for binary updates via the MapBinary option to CursorSetProp:

	*** Map binary fields to BLOB/VarBinary
	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!