I found that the Amount field is conflicting. When being used in SQL passthrough this does not generate any error. When being used from the VFP command prompt or from the Ole Db provider, this generates an error. I renamed the field to Amountx and it works.