how do you save images from vfp form to sql and retrieve the image back
> > i followed the approach as requested the wait window returned a numeric variable type, however i had the same error operator/operand type mismatch
> >
> > i have attached the program segment for your perusal
> >
> >
> >
> > ***************************************************
> > ***************************************************
> >
> > LOCAL strSQL,mprod_px,mprod_qty,mprod_no,mprod_name
> >
> >
> > mprod_px = 0.00
> > mprod_qty = 0.00
> >
> >
> > mprod_px = thisform.prod_px1.value
> > mprod_qty = thisform.prod_qty1.value
> > mprod_no = thisform.prod_qty1.value
> >
> > wait window [mprod_px is type] + vartype(mprod_px)
> >
> >
> >
> >
> > STORE SQLCONNECT('admin', '', '') TO nHandle
> >
> > strSQL = ""
> strSQL = strSQL + "UPDATE product SET " + ;
> " prod_px = '" + mprod_px + "' " + "," + ;
> " prod_qty = '" + mprod_qty + "' " + ;
> " WHERE prod_no = '" + mprod_no + "' "
> >
> > nResult=SQLEXEC(nHandle, strSQL)
> >
> > IF nResult > 0
> > MESSAGEBOX('Record Updated.', 64, 'Update')
> > ELSE
> > MESSAGEBOX('Error Occured!', 64, 'Update')
> > ENDIF
> >
> > nReturn = SQLEXEC(nHandle, 'SELECT * FROM product', 'vproduct')
> >
> > SELECT vPRODUCT
> > THISFORM.REFRESH()
>
> I see now where is the error, you didn't covert Numeric to string where you concatenate the string, also you can't update numeric fields in SQL Server when you pass them as a chars:
>
> strSQL = strSQL + "UPDATE product SET " + ;
> " prod_px = " + STR(mprod_px,12,2) + "," + ;
> " prod_qty = " + STR(mprod_qty,12,2) + ;
> " WHERE prod_no = '" + mprod_no + "' "
> ** I am not sure what type mprod_no is, so I didn't chage WHERE clause, but if it is numeric
> ** you must change it as other values
>
> ** I prefer this:
> TEXT TO strSQL TEXTMERGE NOSHOW PRETEXT 7
> UPDATE product SET prod_px = <<mprod_px>>,
> prod_qty = <<mprod_qty>>
> WHERE prod_no = '<<mprod_no>>'
>
>
>
>
> Borislav Borissovggggggggggg