Claudine
You could also try this
Make sure your null is set to -0-
TALLY company_name FROM i_companies ORDER BY company_name DESC
If there is null it should up as the 1st one
Buddy
From: [email protected] <[email protected]> On Behalf Of Claudine
Robbins
Sent: Saturday, April 21, 2018 6:26 PM
To: [email protected]
Subject: RE: [RBASE-L] - RBase 101
Buddy,
Interestingly, I just reloaded the database last night and this still occurs.
Claudine
From: [email protected] <mailto:[email protected]>
[mailto:[email protected]] On Behalf Of Buddy Walker
Sent: Saturday, April 21, 2018 2:19 PM
To: [email protected] <mailto:[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] <mailto:[email protected]>
<[email protected] <mailto:[email protected]> > On Behalf Of
Claudine Robbins
Sent: Saturday, April 21, 2018 3:16 PM
To: [email protected] <mailto:[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>
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 <mailto:[email protected]>
[email protected].
For more options, visit <https://groups.google.com/d/optout>
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]
<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.
