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 >
