Jim, here is a snippet of code from one of my apps that creates a temp table, adds a column and updates the data in the column. You may be able to use this example to get you started.
Set error message 2038 off drop table tCHECK_REG Set error message 2038 on project temp tCHECK_REG from checks using * + whe ckdate between .vFROM_DATE and .vTO_DATE + ORD BY CKDATE,CHECK#,TM SET ERROR MESSAGE 2059 OFF ALTER TABLE tCHECK_REG ADD COLUMN DBGRID_ROW_COLOR TEXT 20 update tCHECK_REG set DBGRID_ROW_COLOR = "RED" whe CK_DEP = "D" SET ERROR MESSAGE 2059 ON John From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Tuesday, March 10, 2009 6:58 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: FORM CALCULATION IN DBGRID John, If I understand you correctly, instead of using the actual table that has the BOM in my form, I would use the temp table with the added two columns. I have used temp tables with update commands when running command files at the R promt but have not used them much in forms. I do have a form with temp tables I use always for our quotes. I will have to play with your suggestions. Sometimes getting the right syntax is my biggest problem. Thanks. Jim _____ From: [email protected] [mailto:[email protected]] On Behalf Of John Engwer Sent: Tuesday, March 10, 2009 5:08 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: FORM CALCULATION IN DBGRID Jim, I am certain that there are many ways to produce the result that you describe. I am fond of using temp tables to format the data and then create a report based on the temp table. #1 Create a temp table using the BOM for the assembly, listing every required part for the assembly. A project command will create the table or.. a project whe limit = 0, followed be an insert. Add two columns to the temp table using the alter table command. (Qty in stock and Qty on order) Use two update commands to populate the added columns. Create a report based on the newly created temp table. There are many ways that you can print the report using the EEPs in the DBGrid. I use the on-click EEP most often. In your case you would use the on-click EEP in the DBGrid that listed the assembly number. In your form, set a VAR based on the assembly number (vASSY_NO = ASSY_NO). When you click on the assembly number in the DBGrid, the report would print based on the assembly number you click on. (Print report_name whe ASSY_NO = .vASSY_NO) #2 Display the temp table that you created in a DBGrid John From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Tuesday, March 10, 2009 5:15 PM To: RBASE-L Mailing List Subject: [RBASE-L] - FORM CALCULATION IN DBGRID I have a form that I use showing how many parts or assemblies in stock. I use this to bring up a specific assembly we want to make so we can see what parts are available. What I want to do now is show the number of parts or assemblies on order. The form is set up with three dbgrids based on three tables. I do have a view I use in a report that gives this same information. I have two questions. 1) How could I run the report from an EEP in one of the DBGRIDS? 2) How would I run an EEP doing the same thing as the report only in variables I set up on the form? Any suggestions on the best way to show this on the form would be appreciated. Jim I have the latest update of 7.6
