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. >
