G'day Tom. Must be getting nice and toasty down there, it's a bit nippy here, and even colder at home (except last week, the Rockies were warmer than Chicago - go figure)
Could you perhaps create a script, and add it to the ON CONNECT function in the newer R:Base's? ON [FIRST] CONNECT RUN startup.cmd Tom Grimshaw <[EMAIL PROTECTED]> wrote: >G'day Albert, > >At 09:33 22/11/02 -0500, you wrote: >>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. > >I do something similar to that when unloading or loading >but with the number of views and the fact that I need a >CONNECT to get around the bug in dropping temporary tables >it makes it a non-viable workaround to create all var and >views on every CONNECT. > >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/
