Sami Aaron wrote:
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.
*** Right Click the field, and select NULL Format in the drop down menu,
press the space bar and [Enter]
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?
= EQ
>= GE
<= LE
> GT
< LT
--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
