Well Dennis, if you think its a bug good luck trying to convince RBTI: Dear Mr. Grimshaw;
As a user and/or developer of your applications, it is your responsibility to pre-define any required global variables used in forms, reports and queries (views). This functionality and the requirement has been there since the first release of R:BASE version 6.5. As a developer designing applications, you should always create a startup file to pre-define all variables as NULL value with appropriate data type. Then, you can use ON CONNECT RUN cmdfile to automatically run that startup file. Also, F3 (Data Dictionary) key is used to display database structure, not to browse the table. We thank you for your feedback. Regards, R:DCC Staff At 10:18 PM 11/10/2002 +1100, you wrote: G'day, There now seems to be a more stringent requirement regarding variables needing to be set prior to editing or using objects. I don't know if this is deliberate or not but it is definitely counter productive. For instance I have various views based on variables that are set in the application immediately prior to using the view. Formerly I could browse the structure using F3 without these var needing to be set. Now if I use F3 to browse the tables without those var being set I cannot even go past an affected table without get the message -ERROR- unrecognized variable in expression. (2161) If I try to edit a form that has a lookup in a field to a view that relies on a variable I get an error message. Warmest regards, Tom Grimshaw At 19:01 21/11/02 -0600, you wrote:
Warmest regards,Sounds like a bug to me. Never used to work that way and the method is documented, so my opinion is this issue needs to be addressed. Why not send a report to the RDCC? --Dennis -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tom Grimshaw Sent: Thursday, November 21, 2002 5:49 PM To: [EMAIL PROTECTED] Subject: RE: Labels Careful of this one Dennis! This works brilliantly in R:BASE on TEMP views but I had a few dozen permanent views that were created with variables and came across two Gotchas. 1. In version 6.5++ build 1.851 one could browse the structure with [F3] without the variables being set. With the latest patch the variables need to be declared in order for you not to get thrown out of the [F3] function when passing a schema object based on a non-declared variable. Also in the latest patch one cannot do things in forms one is used to without the variables being set. 2. One comes to a fairly solid brick wall if one is porting one's application to another database and keeping the R:BASE front end as the variables are not known to the other database. So we are in the process of removing all variables from view definitions and moving them to the where clauses. Likewise computed columns are not universally supported so we are having to move them to views. At 06:11 21/11/02 -0800, you wrote: >True. The view should probably be created with a variable where >clause. > >WHERE AddressID = (.vAddressID) and NumberID <= (.vNumber) > >if the variables are parenthesized, the view will retain the above >syntax and all you have to do is create the two variables and say >LBLPRINT MultiLable > >--Dennis McGrath > > >--- Bill Downall <[EMAIL PROTECTED]> wrote: > > The Cartesian join is a great approach, but there is one thing to be > > careful of: > > > > Be sure users don't have the opportunity to browse such a view. If > > you > > have 1000 copies of every row in the address table, and you have 5000 > > > > addresses, this works great where your application limits retrieval > > to a > > single address and a finite number of copies of that address. But if > > a > > user opens the view for browsing without a WHERE cluase like the > > one Dennis illustrated, the view has 5,000,000 rows in it, and that > > could tie up some resources! > > > > Bill > > > > > > On Thu, 21 Nov 2002 05:14:32 -0500, J.M. GRATIAS wrote: > > > > >Create a view which does a Cartesian join of your address table with > > > > >the Numbers table. > > >CREATE VIEW ManyLabels AS SELECT colame1, colname2, .... + > > >FROM Addresses, Numbers > > >Notice there is no join clause. This view returns 1000 copies of > > every > > >row in your address table. > > >Create a label definition on that view. > > >Then you can say > > >LBLPRINT MultiLabels WHERE AddressID = .vAddressID AND > > NumberID between 1 and 30 > > > > >Congratulations for this very simple and very clever idea !!! > > >This list is definitively GREAT .... > > > > > > > > > > > > > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: INTRO rbase-l > > ================================================ > > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: UNSUBSCRIBE rbase-l > > ================================================ > > TO SEARCH ARCHIVES: > > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ Warmest regards, Tom Grimshaw coy: Just For You Software tel: 612 9552 3311 fax: 612 9566 2164 mobile: 0414 675 903 post: PO Box 470 Glebe NSW 2037 Australia street: 3/66 Wentworth Park Rd Glebe NSW 2037 email: [EMAIL PROTECTED] web: www.just4usoftware.com.au "... the control of impulse -- is the first principle of civilization."-- Will Durant, Pulitzer Prize winning philosopher, writer and historian the most needed product in the world can be found at www.thewaytohappiness.org This email and any files transmitted with it are confidential to the intended recipient and may be privileged. If you have received this email inadvertently or you are not the intended recipient, you may not disseminate, distribute, copy or in any way rely on it. Further, you should notify the sender immediately and delete the email from your computer. Whilst we have taken precautions to alert us to the presence of computer viruses, we cannot guarantee that this email and any files transmitted with it are free from such viruses. ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
Tom Grimshaw
coy: Just For You Software
tel: 612 9552 3311
fax: 612 9566 2164
mobile: 0414 675 903
post: PO Box 470 Glebe NSW 2037 Australia
street: 3/66 Wentworth Park Rd Glebe NSW 2037
email: [EMAIL PROTECTED]
web: www.just4usoftware.com.au
"... the control of impulse -- is the first principle of civilization."-- Will Durant,
Pulitzer Prize winning philosopher, writer and historian
the most needed product in the world can be found at
www.thewaytohappiness.org
This email and any files transmitted with it are confidential to the intended recipient and may be privileged. If you have received this email inadvertently or you are not the intended recipient, you may not disseminate, distribute, copy or in any way rely on it. Further, you should notify the sender immediately and delete the email from your computer. Whilst we have taken precautions to alert us to the presence of computer viruses, we cannot guarantee that this email and any files transmitted with it are free from such viruses.
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
