Our solution to all view problems is to run a command file that drops and recreates all views on connection to the database, including defining the variables required by each view, if any.
Tom Grimshaw <[EMAIL PROTECTED]> wrote: >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: >>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/ > >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/ > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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/
