Hello Dmitry,
Thanks for the quick response, however it still isn't working for me. I have not made any changes to the example. I just added a picture to John over and over again and it is still the same. I have attached a screenshot.
Thanks,
Sonny
Please check the script
procedure frmAbonent_bOK_OnAfterClick (Sender: string);
var
dbFileName, sFileName, sNewFileName: string;
begin
if frmAbonent.dbPhoto.dbImageIsChanged then
begin
sFileName := frmAbonent.dbPhoto.dbFileName;
sFileName := ExtractFileDir(Application.ExeName)+sFileName;
sNewFileName := ExtractFilePath(Application.ExeName) + frmAbonent.dbPhoto.dbCopyTo + '\'+ frmAbonent.EditCounter.Text + '_' + DateToStr(frmAbonent.dtDate.Date) + ExtractFileExt(sFileName);
dbFileName := '"\'+frmAbonent.dbPhoto.dbCopyTo + '\'+ frmAbonent.EditCounter.Text + '_' + DateToStr(frmAbonent.dtDate.Date) + ExtractFileExt(sFileName)+'"';
if FileExists(sNewFileName) then
begin
if IDYES = MessageBox('File exists.' + #13+ sNewFileName+#13+ 'Overwrite?', 'Warning', MB_YESNO+MB_ICONQUESTION) then
begin
DeleteFile(sNewFileName);
if RenameFile(sFileName, sNewFileName) then SQLExecute('UPDATE person SET photo_filename = '+dbFileName + ' WHERE id='+IntToStr(frmAbonent.bOK.dbGeneralTableId));
end;
end else if RenameFile(sFileName, sNewFileName) then SQLExecute('UPDATE person SET photo_filename = '+dbFileName + ' WHERE id='+IntToStr(frmAbonent.bOK.dbGeneralTableId));
end;
end;
Pay attention to this line
end else if RenameFile(sFileName, sNewFileName) then SQLExecute('UPDATE person SET photo_filename = '+dbFileName + ' WHERE id='+IntToStr(frmAbonent.bOK.dbGeneralTableId));