Hi Claudine,
A question and a few suggestions ...
Is i_companies a table or a view?
If i_companies is an actual table, then, how about ...
01. PACK INDEX FOR i_companies
OR
02. Re-building the database using UNLOAD ALL routine, and NOT the
RELOAD approach.
CONNECT dbname
OUTPUT abc.all
UNLOAD ALL
OUTPUT SCREEN
DISCONNECT
RENAME dbname.rx? dbname_backup.rx?
SET FEEDBACK ON
CLS
RUN abc.all
-- Closely watch the entire process of re-building the database
for any -ERROR-s
SET FEEDBACK OFF
CLS
Now try the same commands and see what you get :)
Hope that helps!
Very Best R:egards,
Razzak
At 02:45 PM 4/21/2018, Claudine Robbins 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?
--
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.
