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?
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)?
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?
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?
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.
Thanks again.
Clayton
Sami Aaron wrote:
Clay -
In case Karen's not available now, I'll take up the baton ...
See my replies below,
Sami Aaron
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Clay
Eisenbrand
Sent: Friday, August 22, 2008 8:34 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Clay's rbase conversion
Hey Karen:
Thanks for getting back. Your input was very helpful. A couple of more
follow up questions:
I created a rbase.dat file so that rbase would automatically connect to
my database "clay", and the file says:
connect clay
but when I get into Rbase an alert immediately comes up and says "unable
to connect database"
I also tried connect clay.rb1 but that didn't work either.
Do I need to add something at the end of "connect clay"
A: In your desktop shortcut, change the "Start In" to point to the
drive/folder where your database files are. Put the RBASE.dat file in that
same folder too.
Secondly, in one of my forms I have a variable for tax defined (tot *
.0825). We have created a field in the form for tax,
but I can't edit it. How can I make the field editable?
Lastly, in the same form, I have a variable "bdft" that is defined (th *
w * l / 144). We input the th and the w and l and it computes the
variable "bdft" automatically. It works, but we'd like to have the
option to not input the th, w, and l and just plug in a value for "bdft"
- or we'd like to be able to edit it after we've input the th, w, and
l. As it is we can't change it.
A: To answer both of your last questions together since they are the same
scenario:
This is different from the way variables used to work in older versions of
R:BASE. Once a form variable is defined in the variable list, it is NOT
editable. It's a little more complicated to get this working, so here's
what you do.
1. Create your form variable just like you did above; let's call it "vtax"
and the expression is
(tot * .0825)
2. Place a dbEdit object on the form for the actual field you want the end
result to be saved in - let's say it's the field called "tax"
3. Open the Properties for this dbEdit and set the ComponentID to "tax"
(without the quotes!)
4. In the dbEdit property settings, go to the EEPs tab and click on the
"Edit Custom EEP" in the On Entry into EEP section (it's the top one on the
right) and type in:
PROPERTY tax TEXTVALUE .vtax
As the cursor moves through the form, when it lands into the tax field, the
value will be set to the computed value of the vtax variable into the tax
dbEdit field where you can now edit it.
How do we do that?
Thanks again,
Clayton
Thanks,
Clayton
[EMAIL PROTECTED] wrote:
I have provided answers to a couple of your questions below:
Karen
Hey Buddy:
Thanks for the info. A few more questions...
1) Instead of...change column to value in table where column eq value
I used.........update column to value in table where column eq value
and software said "syntax is incorrect for the command UPDATE.
What is the correct syntax for update?
A: The correct UPDATE syntax (you need the periods in front of
variable names)
UPDATE tablename SET column = .value WHERE anothercolumn =
.anothervalue
2) How can I instruct Rbase to automatically connect to a specific
database?
A: In your startup directory, create a program called RBASE.DAT and
have it contain all the commands you want at startup. For example,
CONNECT databasename
LIST
RBase will always automatically run an RBASE.DAT file if it finds one
in your startup directory
3) In a form we would like to divide a currency variable (as yet
defined) by a numeric variable (as yet defined). How do we do that
specifically in the expression builder?
You suggested that we set the variable before printer your report.
Again make sure what
band the variables are calculated in.
But... the problem we're having isn't in a report but in a form, so
nothing is being printed and I don't think there is a band that the
variables are calculated in.
A: In the form, go into the variables, type your variable name in
there, then choose its data type, then click the "global" button. You
won't see anything happens, but what that does is put the form "in
memory". Now you can create another expression that uses that
variable. What you should get in the habit of doing is also going
into Layout, On Before Design Action, and type a SET VAR command in
there. Otherwise the next time you bring up the form in design, that
variable would have to be redefined again.
4) In a form, how do we set a default value for a field, and how can
we make a field editable? In the same way, if a variable
is determined by multiplying three numbers together and dividing by
another (field for every number in form), how can we make it so we can
input any value for the variable even if there we have not input any
fields for multiplying and dividing.
A: I don't follow your last question. But for the first, bring up
the field's properties, Effects tab, Default Value is where you type
in the default. However, defaults only show up if you are ENTERING
data. If you are EDITING data and the field is empty, it will NOT
show a default.
Hope this helps you out a little!
Karen
