Dennis,
There is no "bit" which can be filipped in the ".RB1" file to convert a table
to a view. In 6.5+ for Dos if you try to create a view with the same name as a
table you get an error mesage.
I would echo previous comments that you need to thorough review code in command
files and/or determine if commands were issued from "R>".
Step wise if the table exists you would first need to delete the table with a
"DROP tABLE" command. You would then need to issue a "CREATE VIEW" command.
If you wish to call me I can discuss the mechanism of how a view is recorded in
the ".RB1" file and why you must issue a command to create a table not just
some how magically turn a table into a view.
--
sincerely,
Jim Bentley
American Celiac Society
266 Midway Dr
River Ridge LA 70123
email: [EMAIL PROTECTED]
Phone: 504-738-6165
-----Original Message-----
From: Kenny Camp <[EMAIL PROTECTED]>
Sent: Thu, 7 Apr 2005 10:06:48 -0500
To: [email protected] (RBASE-L Mailing List)
Subject: [RBASE-L] - Re: table >>> view?
Years ago, back in 2.11, I had that happen maybe 3 or 4 times. It occurred when
I did deleted all the rows where count > 0. It has not happened since 2.11.
Kenny
----- Original Message -----
From: Dennis Fleming
To: RBASE-L Mailing List
Sent: Wednesday, April 06, 2005 7:54 PM
Subject: [RBASE-L] - Re: table >>> view?
OK.
This table name is never used as a view name and this is a first for me in
Rbase.
I didn't check the RB1 table to see if there is a switch (bit) which means
table or view and somehow got corrupted.
Dennis
*****
At 10:48 PM 4/5/2005, you wrote:
At 10:37 PM 4/5/2005, Dennis Fleming wrote:
It wasn't hard to fix but a customer sent me their data base
and a table had become a view. Same name. They lost about 400
rows of data but we were able to recreate them.
This is in 6.5, but I was wondering if anyone has seen this or
how it might happen.
Dennis,
I would check the code which maintains the database maintenance
routines, if any.
It might be possible to type CREATE VIEW instead of CREATE TABLE,
etc.
Very Best R:egards,
Razzak.
Dennis Fleming
IISCO
http://www.TheBestCMMS.com
Phone: 570 775-7593
Mobile: 570 351-5290
��< ! D O C T Y P E H T M L P U B L I C " - / / W 3 C / / D T D H T M L 4 . 0 T r a n s i t i o n a l / / E N " >
< H T M L > < H E A D >
< M E T A h t t p - e q u i v = C o n t e n t - T y p e c o n t e n t = " t e x t / h t m l ; c h a r s e t = i s o - 8 8 5 9 - 1 " >
< M E T A c o n t e n t = " M S H T M L 6 . 0 0 . 2 9 0 0 . 2 6 0 4 " n a m e = G E N E R A T O R >
< S T Y L E > < / S T Y L E >
< / H E A D >
< B O D Y b g C o l o r = # f f f f f f >
< D I V > < F O N T f a c e = A r i a l s i z e = 2 > Y e a r s a g o , b a c k i n 2 . 1 1 , I h a d t h a t h a p p e n m a y b e 3
o r 4 t i m e s . I t o c c u r r e d w h e n I d i d d e l e t e d a l l t h e r o w s w h e r e c o u n t & g t ;
0 . & n b s p ; I t h a s n o t h a p p e n e d s i n c e 2 . 1 1 . & n b s p ; < / F O N T > < / D I V >
< D I V > < F O N T f a c e = A r i a l s i z e = 2 > < / F O N T > & n b s p ; < / D I V >
< D I V > < F O N T f a c e = A r i a l s i z e = 2 > K e n n y < / F O N T > < / D I V >
< B L O C K Q U O T E
s t y l e = " P A D D I N G - R I G H T : 0 p x ; P A D D I N G - L E F T : 5 p x ; M A R G I N - L E F T : 5 p x ; B O R D E R - L E F T : # 0 0 0 0 0 0 2 p x s o l i d ; M A R G I N - R I G H T : 0 p x " >
< D I V s t y l e = " F O N T : 1 0 p t a r i a l " > - - - - - O r i g i n a l M e s s a g e - - - - - < / D I V >
< D I V
s t y l e = " B A C K G R O U N D : # e 4 e 4 e 4 ; F O N T : 1 0 p t a r i a l ; f o n t - c o l o r : b l a c k " > < B > F r o m : < / B >
< A [EMAIL PROTECTED] h r e f = " m a i l t o :[EMAIL PROTECTED]" > D e n n i s F l e m i n g < / A > < / D I V >
< D I V s t y l e = " F O N T : 1 0 p t a r i a l " > < B > T o : < / B > < A [EMAIL PROTECTED]
h r e f = " m a i l t o :[EMAIL PROTECTED]" > R B A S E - L M a i l i n g L i s t < / A > < / D I V >
< D I V s t y l e = " F O N T : 1 0 p t a r i a l " > < B > S e n t : < / B > W e d n e s d a y , A p r i l 0 6 , 2 0 0 5 7 : 5 4
P M < / D I V >
< D I V s t y l e = " F O N T : 1 0 p t a r i a l " > < B > S u b j e c t : < / B > [ R B A S E - L ] - R e : t a b l e
& g t ; & g t ; & g t ; v i e w ? < / D I V >
< D I V > < B R > < / D I V > < F O N T s i z e = 3 > O K . < B R > T h i s t a b l e n a m e i s n e v e r u s e d a s a v i e w
n a m e a n d t h i s i s a f i r s t f o r m e i n R b a s e . < B R > I d i d n ' t c h e c k t h e R B 1 t a b l e t o
s e e i f t h e r e i s a s w i t c h ( b i t ) w h i c h m e a n s t a b l e o r v i e w a n d s o m e h o w g o t
c o r r u p t e d . < B R > < B R > D e n n i s < B R > * * * * * < B R > < B R > < B R > A t 1 0 : 4 8 P M 4 / 5 / 2 0 0 5 , y o u
w r o t e : < B R > < B R >
< B L O C K Q U O T E c l a s s = c i t e c i t e = " " t y p e = " c i t e " > A t 1 0 : 3 7 P M 4 / 5 / 2 0 0 5 , D e n n i s
F l e m i n g w r o t e : < B R > < B R >
< B L O C K Q U O T E c l a s s = c i t e c i t e = " " t y p e = " c i t e " > I t w a s n ' t h a r d t o f i x b u t a
c u s t o m e r s e n t m e t h e i r d a t a b a s e < B R > a n d a t a b l e h a d b e c o m e a v i e w . S a m e
n a m e . T h e y l o s t a b o u t 4 0 0 < B R > r o w s o f d a t a b u t w e w e r e a b l e t o r e c r e a t e
t h e m . < B R > < B R > T h i s i s i n 6 . 5 , b u t I w a s w o n d e r i n g i f a n y o n e h a s s e e n t h i s
o r < B R > h o w i t m i g h t h a p p e n . < / B L O C K Q U O T E > < B R > D e n n i s , < B R > < B R > I w o u l d c h e c k t h e
c o d e w h i c h m a i n t a i n s t h e d a t a b a s e m a i n t e n a n c e < B R > r o u t i n e s , i f a n y . < B R > < B R > I t
m i g h t b e p o s s i b l e t o t y p e C R E A T E V I E W i n s t e a d o f C R E A T E
T A B L E , < B R > e t c . < B R > < B R > V e r y B e s t
R : e g a r d s , < B R > < B R > R a z z a k . < B R > < B R > < / F O N T > < / B L O C K Q U O T E > < B R >
< D I V > D e n n i s F l e m i n g < / D I V >
< D I V > I I S C O < / D I V >
< D I V > < A h r e f = " h t t p : / / w w w . t h e b e s t c m m s . c o m / "
E U D O R A = " A U T O U R L " > h t t p : / / w w w . T h e B e s t C M M S . c o m < / A > < / D I V >
< D I V > P h o n e : 5 7 0 7 7 5 - 7 5 9 3 < / D I V > M o b i l e : 5 7 0 3 5 1 - 5 2 9 0 < / B L O C K Q U O T E > < / B O D Y > < / H T M L >
