Mike, It depends what you like to achieve. If only the value of the selection criteria changes there is no need for dropping the table. Make sure that your variable is surrounded by brackets like (.V_variable) and then you can change the content of the variable dynamically.
If the where clause changes you can try using an ampersand variable, like &V_where. It looks as this: Select * from <table> where &V_where. Pay attention to use quotes in this situation. Tony -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Michael Sinclair Sent: zondag 2 september 2012 21:08 To: RBASE-L Mailing List Subject: [RBASE-L] - OnKeyPress eep methods Hi all, Is it ok to create and drop and recreate a temporary table using the project command within an EEP? Many versions ago someone on this list shared a great OnKeyPress example using that technique. Recent versions show the same idea using a Variable Lookup List View where you modify the where clause variable, which works great. Is the original way still ok to use? My newer apps using the older code seem to be flakey giving an occasional I/O Error. TIA Mike --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
