Good idea Dennis- I'll give that a whirl.
Thanks! Lee Bailey & Associates E-Mail: [EMAIL PROTECTED] Phone: 772-597-0040 Fax: 772-597-0043 ----- Original Message ----- From: "Dennis McGrath" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, January 09, 2003 6:26 PM Subject: [RBASE-L] - RE: What's up with this? > Use the > CREATE VIEW viewname (columnlist) AS SELECT ....... > syntax. You will never get burned that way. > > I have a command file for each view or group of related views which I > can run to create or modify them. > > Also, When I want to create a view I ask myself "Does this view need > to remain in the database definition?" If not, I use a TEMPORARY view > which I can create on the fly in my command file. Saves a lot of > maintenance. > > Dennis McGrath > > > --- "Walker, Buddy" <[EMAIL PROTECTED]> wrote: > > Lee > > I've seen this happen when you create a view using the * indicating > > you want to use all the columns in the table. I don't use the * I > > specify all the columns by name. > > > > Buddy > > > > -----Original Message----- > > From: Lee Bailey [mailto:[EMAIL PROTECTED]] > > Sent: Thu 1/9/2003 4:41 PM > > To: [EMAIL PROTECTED] > > Cc: > > Subject: [RBASE-L] - What's up with this? > > > > > > > > Hello everyone- > > > > When I use my latest Windows 6.5++ single user RBase version with the > > latest build, whenever I add a column to a table that is used in a > > multi-table view, double clicking the corresponding view causes the > > view > > to not open. This has been my indication that the view needs to be > > "updated" so as to now reflect the enlarged table used within the > > view. > > > > Once I edit the view, the view works once again, and is available and > > can be used outright, or with the related forms and programming. > > > > I recently bought the 6.5++ multi user pack, and re-installed the > > system > > from scratch, as instructed with the package. > > > > What's interesting, is that when adding a column to the same table as > > before, the respective view works just fine (by double clicking it), > > but > > a form associated with the view now does not work until the view is > > again updated via the same method as before. > > > > This scenario causes a command file to bomb out when trying to use > > the > > form until the view is updated. Unfortunately, if I happen to miss a > > view to be updated-- we are done. > > > > Is this what everyone else is experiencing? > > > > I like the old way better, as it is a cleaner way to see if your > > views > > are up to date. Double clicking a view either works or it doesn't. > > > > Lee Bailey > > > > Bailey & Associates > > E-Mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > Phone: 772-597-0040 > > Fax: 772-597-0043 > > > > > > >
