Hi all,
It's me again.
Here is another problem I have.
I have a "Person" table with a blob field for the picture of the person.
I created a form to enter the name of the person, and there is an Image field.
I added a contextual menu on this image to allow the user to load the image from a file.
So, in the code, I use a OpenDialog window (so that the user can select a picture file)
Here is the code :
The problem is that I have an error message :
"The process cannot access the file '<__name_of_file_here__>' because it is being used by another process"
I tried to close the file (as you can see with the command FileClose), but it does not work.
And another extra question :
How do I remove a picture in the table ?
Is it :
or
or
or
Thanks a lot in advance.
It's me again.
Here is another problem I have.
I have a "Person" table with a blob field for the picture of the person.
I created a form to enter the name of the person, and there is an Image field.
I added a contextual menu on this image to allow the user to load the image from a file.
So, in the code, I use a OpenDialog window (so that the user can select a picture file)
Here is the code :
B4X:
If ODPImage.Show <> cCancel Then
Fichier = ODPImage.File
ImgPBlob.Image = ODPImage.File
FileClose (Fichier)
strSQL = "Update personnes set P_Image = " & cmd.FileToBLOB(Fichier) & " Where P_ID = " & TBPID.Text
cmd.CommandText = strSQL
cmd.ExecuteNonQuery
End IfThe problem is that I have an error message :
"The process cannot access the file '<__name_of_file_here__>' because it is being used by another process"
I tried to close the file (as you can see with the command FileClose), but it does not work.
And another extra question :
How do I remove a picture in the table ?
Is it :
B4X:
Update personnes set P_Image = NULL where . . .
B4X:
Update personnes set P_Image = '' where . . .
B4X:
Update personnes set P_Image = "" where . . .
B4X:
something else ??Thanks a lot in advance.