When I use

x = 'ole biscuit'
z=99

s = "update wibble set ftang=?x where pk=?z"

in ODBC it works fine, but if I try this in VFP, via &s or as a direct statement, I get a syntax error. In SELECT it works correctly. Can I NOT do this in VFP but only in ODBC?

Many thanks