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 > > >
