Buddy, Interestingly, I just reloaded the database last night and this still occurs.
Claudine From: [email protected] [mailto:[email protected]] On Behalf Of Buddy Walker Sent: Saturday, April 21, 2018 2:19 PM To: [email protected] Subject: RE: [RBASE-L] - RBase 101 Claudine It could be index corruption. Any time that has happened to me a reload or pack would fix it. If company_name is indexed you could just try packing the indexes. Buddy From: [email protected] <[email protected]> On Behalf Of Claudine Robbins Sent: Saturday, April 21, 2018 3:16 PM To: [email protected] Subject: RE: [RBASE-L] - RBase 101 And a physical look at the table confirms that there are no rows with a null company_name… Citing my ignorance, I tried set eqnull on and zero off with no effect. Claudine From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Albert Berry Sent: Saturday, April 21, 2018 1:53 PM To: [email protected]<mailto:[email protected]> Subject: Re: [RBASE-L] - RBase 101 That is interesting, indeed. I have no idea why the where clause in the second fails. I’m such a log of help! Albert On Apr 21, 2018, at 12:45 PM, Claudine Robbins <[email protected]<mailto:[email protected]>> wrote: I’m stumped and probably because I fail to remember some basic rule in RBase. Why does: sel count(*) fro i_companies whe company_name is null count (*) ---------- 2 But: R>sel * fro i_companies whe company_name is null <WARNING> No rows exist or satisfy the specified clause. (2059) Can someone set me straight? TIA, Claudine -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
