[RBG7-L] - Re: Form question

[Javier Valencia]

Emmitt: I use the same procedure to make sure that I am in the right table; however, I believe that there is a PROPERTY command that will shift focus to the desired table…I tried something like that a while back (early stages of PROPERTY) but I could not get it to work, maybe someone can chime in with the correct syntax… PROPERTY TABLE my_table_name SETFOCUS ‘TRUE’ Or something like that… 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: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED]On Behalf Of Emmitt Dove Sent: Friday, January 28, 2005 12:03 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Form question   And I wrote it because I could use my own icons on a bit button. The nested IFs below could be distilled into a CASE statement for simplicity, especially if the number of tables is greater. Nice code, Emmitt!   I know we all didn't like it that buttons had to be tied to tables, but there were a few instances where it came in handy, and this was one of them!  Your code is a nice alternative to using a DB navigator when you want these buttons to apply to only one table! Karen Marc, Create one button with an eep that does:         NEXTROW         RETURN Now, create another button that does:         NEXTROW         NEXTROW         NEXTROW         NEXTROW         NEXTROW         NEXTROW         NEXTROW         RETURN The only trick here in a multiple-table form is making sure the table you want to act upon has focus when the button is clicked.  The way I do this with a three-table form, where I want to go to the first row, is:   SET VAR vtabname = .RBTI_FORM_TBLNAME   IF vtabname = 'invallw' THEN     PROPERTY TABLE invallw 'FIRST'   ELSE     NEXTTAB     SET VAR vtabname = .RBTI_FORM_TBLNAME     IF vtabname = 'invallw' THEN       PROPERTY TABLE invallw 'FIRST'     ELSE       NEXTTAB       PROPERTY TABLE invallw 'FIRST'     ENDIF   ENDIF Basically I'm just checking what the current table is before issuing the command, and if it isn't what I want, I do a NEXTTAB and check again.   Emmitt Dove Manager, DairyPak Business Systems Blue Ridge Paper Products, Inc. 40 Lindeman Drive Trumbull, CT  06611 (203) 673-2231 [EMAIL PROTECTED] [EMAIL PROTECTED]