CREATE TABLE mytablet (c1 I, c2 c(1), c3 c(10), c4 blob) CURSORSETPROP("MapBinary",.T.,0) APPEND BLANK REPLACE c1 WITH 4, c2 WITH 'A', c3 WITH 'Anderson', c4 WITH lcfile TEXT TO lcSQL NOSHOW PRETEXT 15 TEXTMERGE INSERT INTO mytable (myKey, Status, LastName, cphoto) VALUES (<<c1>>,<<c2>>, <<c3>>,<<CREATEBINARY(c4)>>) ENDTEXT ? SQLEXEC(6,lcsql)and:
CREATE TABLE mytablet (c1 I, c2 c(1), c3 c(10), c4 blob) CURSORSETPROP("MapBinary",.T.,0) APPEND BLANK REPLACE c1 WITH 4, c2 WITH 'A', c3 WITH 'Anderson', c4 WITH lcfile TEXT TO lcSQL NOSHOW PRETEXT 15 TEXTMERGE INSERT INTO mytable (myKey, Status, LastName, cphoto) VALUES (<<c1>>,<<c2>>, <<c3>>,<<c4>>) ENDTEXT ? SQLEXEC(6,lcsql)and:
CREATE TABLE mytablet (c1 I, c2 c(1), c3 c(10), c4 blob) CURSORSETPROP("MapBinary",.T.,0) APPEND BLANK REPLACE c1 WITH 4, c2 WITH 'A', c3 WITH 'Anderson', c4 WITH createbinary(lcfile) TEXT TO lcSQL NOSHOW PRETEXT 15 TEXTMERGE INSERT INTO mytable (myKey, Status, LastName, cphoto) VALUES (<<c1>>,<<c2>>, <<c3>>,<<c4>>) ENDTEXT ? SQLEXEC(6,lcsql)and
CREATE TABLE mytablet (c1 I, c2 c(1), c3 c(10), c4 M) CURSORSETPROP("MapBinary",.T.,0) APPEND BLANK REPLACE c1 WITH 4, c2 WITH 'A', c3 WITH 'Anderson', c4 WITH lcfile TEXT TO lcSQL NOSHOW PRETEXT 15 TEXTMERGE INSERT INTO mytable (myKey, Status, LastName, cphoto) VALUES (<<c1>>,<<c2>>, <<c3>>,<<c4>>) ENDTEXT ? SQLEXEC(6,lcsql)This is not in code, it is just from a command line for testing. For some reason, I cannot get any to work. Obviously it is Friday. It always bombs on the first character of the c4 field (the .jpg)