>Hi, does anyone know how can I insert a blob record in an oracle database?
>
>I've tried this but it doesn't work:
>
>cFile=FILETOSTR('c:\background1.jpg') * this file is 2k in size
>cQuery = "insert into prueba_blob (blob_id,blob_1) values (1,"+cFile+")"
>nReg=SQLEXEC(nHnd,cQuery,'curResult')
>
>the message from oracle is:
>missin comma
>or
>invalid caracter
>
>Any ideas?
>Thanks in advance

VFP version ?

You can try:

cFile=FILETOSTR('c:\background1.jpg') * this file is 2k in size
cQuery = "insert into prueba_blob (blob_id,blob_1) values (1,?m.cFile)"
* or
cQuery = "insert into prueba_blob (blob_id,blob_1) values (1,0h"+STRCONV(m.cFile,15)+")"
* or
cQuery = "insert into prueba_blob (blob_id,blob_1) values (1,0x"+STRCONV(m.cFile,15)+")"

nReg=SQLEXEC(nHnd,cQuery,'curResult')