-
ok..I use one form to show pictures and another to add and delete pictures.
When I delete all the pictures and go back to the view form I still see the last picture that was displayed but I shouldn't see any because I have deleted all the pictures.
After delete I've even gone so far as to do another sql
and then reload another recordset * from pictures so in fact at this point it should have nothing in it if I've
deleted the last picture.
When I use this code
frmOne.visible=false
frmTwo.visible = true
does this code not trigger the activate and load events of
frmTwo???
Since in activate and load I have a Select * from pictures and a if eof and bof go...bla bla it should not show a picture...
when I shut the app down and restart it does what it should and not show a picture.
What is the scoop on this crap..I've wasted a week on this stupid go round and round
-
Do you refresh recordset after delete?
-
yes...first I refreshed the recordset and then as
an alternataive I used a new sql selection * form the table and that should only give what is left...
surprise...it still shows a picture when nothing is in the
image file or in the database.
-
You also need to clear the picture box as the application makes a copy of the picture in memory rather than loading it from it's source each time.
use
[pictureboxname].cls
Regards
