>lcFile = FILETOSTR(GETFILE()) && I just grab any smallsize bmp >clear >CREATE TABLE mytable1 (c1 I, c2 c(1), c3 c(10), c4 M NOCPTRANS) >CURSORSETPROP("MapBinary",.T.,0) >APPEND BLANK >REPLACE c1 WITH 4, c2 WITH '', c3 WITH 'Anderson', c4 WITH lcfile >TEXT TO lcSQL NOSHOW PRETEXT 15 TEXTMERGE > INSERT INTO TestImportCase (TestKey, Status, LastName, cImage) VALUES (<<mytable1.c1>>,<<mytable1.c2>>, <<mytable1.c3>>,CONVERT(varbinary(max),mytable1.c4)) >ENDTEXT >IF SQLEXEC(6,lcsql) < 0 > AERROR(laERROR) > MESSAGEBOX(laError(1,2)) >ENDIF >>Returns: " Incorrect syntax near ',' "
TEXT TO lcSQL NOSHOW PRETEXT 15 TEXTMERGE INSERT INTO TestImportCase (TestKey, Status, LastName, cImage) VALUES (<<mytable1.c1>>,'<<mytable1.c2>>', '<mytable1.c3>>', CONVERT(varbinary(max),?mytable1.c4)) ENDTEXT