Thanks for everyone's help. I think the view will help. Thanks again, Kyle.
At 09:24 PM 9/23/2002 -0500, you wrote: >Kyle: >I store expressions in fields but they will not automatically execute as a >calculated field would. You will have to set a variable equal to the >expression and then run it from an application or the R> prompt. >For example, you can set a field on a table to a command such as: > SELECT COUNT your_field INTO temp_var FROM your_file WHERE ... >Then, from your application you set the value of the column to a variable: > SET VAR my_command = your_field IN your_file WHERE ... >Finally, run the command: > &my_command >The stored command will be executed and the selected count will be stored in >the variable temp_var. You can use this approach to store and execute any >command (such as running a form, or printing a report) or executable file, >from within an application. This is particularly helpful when used to store >menu options and their corresponding executable commands. I hope this helps. > >Javier Valencia, PE >President >Valencia Technology Group, L.L.C. >14315 S. Twilight Ln., Suite #14 >Olathe, KS 66062-4571 >(913)829-0888 >(913)649-2904 FAX > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On >Behalf Of Kyle >Sent: Monday, September 23, 2002 3:24 PM >To: [EMAIL PROTECTED] >Subject: Expressions in tables - Win V6.5++ > >Could one of you rbase gurus help me?? > >Can a field in a table be set to an expression based on the following: > >Sum of a field plus sum of another field from another table > >For example: > >Totest.Worder = sum(labest.craft) + sum(matest.craft) > >TIA, Kyle. > > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
