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
