Thanks for the help. This will work just fine ----- Original Message ----- From: "Javier Valencia" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Monday, January 10, 2005 2:20 PM Subject: [RBG7-L] - Re: Images
> Joel: > You can have a speed button "Delete Photo" with the following EEP > --Make sure that you declare a variable in your form equal to the columns > identifier > -- for the row, for example: vemp_id = employee_id > -- Here is the code for the eep > Update your_table_name SET picture_col = NULL WHERE employee_id = .vemp_id > PROPERTY TABLE your_table_name 'REFRESH' > PROPERTY FORM your_form_name 'REFRESH' > > Or else you can add a Component ID to the Picture column vci_photo > SET VAR vnull = NULL > PROPERTY TABLE your_table_name 'EDIT' > PROPERTY vci_photo TEXTVALUE .vnull > PROPERTY FORM your_form_name 'REFRESH' > > Any way, you get the idea... > Javier, > > Javier Valencia, PE > President > Valencia Technology Group, L.L.C. > 14315 S. Twilight Ln, Suite #14 > Olathe, Kansas 66062-4578 > Office (913)829-0888 > Fax (913)649-2904 > Cell (913)915-3137 > ================================================ > Attention: > The information contained in this message and or attachments is intended > only for the person or entity to which it is addressed and may contain > confidential and/or privileged material. Any review, retransmission, > dissemination or other use of, or taking of any action in reliance upon, > this information by persons or entities other than the intended recipient > is prohibited. If you received this in error, please contact the sender and > delete the material from all system and destroy all copies. > ====================================================== > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Joel Solomon > Sent: Friday, January 07, 2005 8:38 AM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Re: Images > > Razzak, > > That is all fine, but how can I delete the photo from a form. I need to set > up an EEP that will delete the photo and then refresh the screen so the > field would then be blank > > Joel > ----- Original Message ----- > From: "A. Razzak Memon" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[email protected]> > Sent: Thursday, January 06, 2005 1:52 PM > Subject: [RBG7-L] - Re: Images > > > > At 01:32 PM 1/6/2005, Joel Solomon wrote: > > > > >They are being stored in the database in a field stu_photo. If I want > > >to remove the photo from the field could I just set the field to NULL? > > > > > > Joel, > > > > Here's how: > > > > 01. EDIT * FROM TableName > > 02. Tab over to Stu_Photo column > > 03. Right-Click on that column and select "Clear Data" > > > > That's all there is to it! > > > > And that is your tip of the day ... > > > > Very Best R:egards, > > > > Razzak. > > >
