drumsticks
Programmer
Hello,
I'm attempting to insert an image from a memo (binary) field to a SQL Server image field using SQLEXEC()
I can't figure out why the record will not insert.
When I take out the binary fields 'itpic' and '?mtpic' from the insert statement, the code works.
I'm sure I'm missing something.
SELECT curNEW
SCAN
SCATTER MEMVAR
*SQLPREPARE(lnConnHandle, 'INSERT INTO testtable ' + ;
'(cfiles, cfolders, itpic) VALUES (?cfiles, ?cfolders, ?mtpic)')
SQLEXEC(lnConnHandle)
ENDSCAN
Regards,
Drumsticks
I'm attempting to insert an image from a memo (binary) field to a SQL Server image field using SQLEXEC()
I can't figure out why the record will not insert.
When I take out the binary fields 'itpic' and '?mtpic' from the insert statement, the code works.
I'm sure I'm missing something.
SELECT curNEW
SCAN
SCATTER MEMVAR
*SQLPREPARE(lnConnHandle, 'INSERT INTO testtable ' + ;
'(cfiles, cfolders, itpic) VALUES (?cfiles, ?cfolders, ?mtpic)')
SQLEXEC(lnConnHandle)
ENDSCAN
Regards,
Drumsticks