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?
2) How can I instruct Rbase to automatically connect to a specific
database?
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.
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.
Thanks again,
Clayton
Walker, Buddy wrote:
Clayton
See answers below questions.
Hope this helps.
Buddy
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Clay
Eisenbrand
Sent: Thursday, August 21, 2008 8:43 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Clay's rbase conversion
To Anyone Who may be of help:
We have just converted rbase 5.5 to rbase 7.6 for windows, and we're
stuck in a number of places.
1) What is the alternative (new command word) to the old "change"
command?
Update
2) How do we automatically connect to a certain database and start at
the R:prompt automatically?
Settings > Startup Options
3) Is it possible to print multiple reports on one piece of paper on a
laser printer?
Not really since windows sends a form feed after each print job.
Take a look at sub-reports
4) How can we set an overall default for font size/type in reports/forms
and at the R:prompt?
Settings > Forms Designer then set the default settings
Settings > Reports/Label Designer > default settings
5) In many of the tables, data that had a "&" was corrupted in that "&"
became "$quot." for instance. Anyway of doing an overall
edit/correction without having to go through each one?
You could try unloading all to a file and then do a search and
replace on the data.
6) In a report every so often I will notice a "not defined" shows up
where a variable normally prints a city, state and zip. Why is that?
Check on what band the variable is being defined. For example if you
have a variable located in the report page heard then the variable
should be calculated in the PH.
7) 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?
Set the variable before printer your report. Again make sure what
band the variables are calculated in.
8) In a report, 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.
Reports are not editable.
9) When we use the dbcalc to create a variable that adds up currency,
how can we get it to show as currency?
Format the results by right clicking on field and clicking on
Display/Format
Thank you in advance
Clayton
