Using the LOAD_FULE() Function

[Abin Saydah]

Hi

I am having a strange problem.

On my development PC, a P4 desktop computer, my SQl statement looks like this (developing using Delphi 7):

'Insert into imagedb (ImgPatNum, ImgDate, ImgTime, ImgComment,
ImgImage, ImgCommitStat) Values ('+
QuotedStr(PrimaryBCode)+','+QuotedStr(DStr)+','+
QuotedStr(TStr)+','+QuotedStr(CBar)+
', LOAD_FILE('+QuotedStr(FName1)+'),"N");');

where FName1 = 'C:\\TEMP\\TMPIMG.JPG'

This works fine and the image is put into the correct column.

The problem comes when I copy the application to my laptop (which has
the same version of MySQl installed).

The SQL statement fails with 'ImgImage cannot be Null'.

Any ideas on what the problem can be ? I even tried changing the '\\'
to '/' ... same problema nd error ...

Thanx in advance,
Abin