Clay - Good timing - I was just about to log off for the evening ... Glad you made some progress the last time!
See my replies below. Sami ____________________________ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Clay Eisenbrand Sent: Friday, September 05, 2008 8:07 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Clay's rbase conversion Hey Sami- Thanks so much - I can edit my fields in my forms now! Your suggestions worked perfectly. A few more beginner questions: 1) In a form, is there a way to add and duplicate a row? --There are a couple of ways - the easiest is to place a Push Button on the form, and under properties, EEPs, choose Predefined, Duplicate Row. 2) In a form is there also a way for a blank to show up instead of a -0- when the field is null (as we can in a report)? --If you can do it on a field-by-field basis in a form, I don't know how to do that. But you can SET NULL ' ' in your command file just before running the form, then set it back afterwards, like this: SET NULL ' ' EDIT USING MyFavoriteForm WHERE something happens SET NULL -0- 3) For syntax, = is a substitute for "eq". What is a substitute for ge (greater or equal to), le (less than or equal to), gt (greater than), lt (less than). How do I look it up in Help? --Search for "Obsolete Commands" 4) In a report, dbcalc is used to add up totals. Let's say we have a column pay and we create a dbcalc for pay. Then let's say we want to create a variable that is .5 of this total. How do we do this? Is there a way to build a variable upon a dbcalc, or do we need to create a variable in the expression builder. I tried to start by creating a variable sumpay = sum of pay, but I couldn't get it to work. I tried sumpay = (sum of pay), but was told "column or variable sum of pay not found" - so that obviously isn't right. Is it true also that the variable needs to be calculated in the same section as it appears on the form? --this follows the basics of the form variables from our earlier emails. Download the sample database under "Capturing DB Calc Results as Variables in Reports" in Razzak's Sample Applications site at http://www.razzak.com/sampleapplications/. Post back here if you need more help. Go into design mode on the report SalesAnalysis and go to Report / Document Custom EEPs / Clipboard (or PDF) and see where the variables are situated in the different EEPS in the Report Bands. To place an EEP in the report, just right-click in the gray report section band and you'll see a Before Generate and an After Generate EEP. 5) How can we get the default font at the prompt to be bigger? I tried increasing the size of the font in settings/Rprompt/default prompt but that didn't seem to do anything. --in the R> Prompt Settings, click on the Font button just below the list of fonts and select Courier New and change the font size there. Be sure to click the "Default" font in the list at the top. Thanks again. Clayton
