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"
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.
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
