MySQL Forums
Forum List  »  Delphi

Using the LOAD_FULE() Function
Posted by: Abin Saydah
Date: June 19, 2006 02:06AM

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

Options: ReplyQuote


Subject
Written By
Posted
Using the LOAD_FULE() Function
June 19, 2006 02:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.