> R>edit all from salestrans where plantno+custid+jobno not in (select plantno+custid+jobno
from
> job)
Thinking along your train of thought, maybe this:
R>edit all from salestrans where
(ctxt(plantno)+ctxt(custid)+ctxt(jobno)) not in (select
(ctxt(plantno)+ctxt(custid)+ctxt(jobno)) from job)
Ben Petersen
On 2 Mar 2005 at 15:45, Scott Stanfield wrote:
>
> Maybe someone can help me with this situation. I issued the following command:
>
> R>edit all from salestrans where plantno+custid+jobno not in (select plantno+custid+jobno
from
> job)
>
> The key to the table job is the plant number, customer number, and the job number which
make it
> unique.
>
> Any records in the salestrans must have a corresponding match in the job table (many-to-one
> relationship).
>
> What I wanted to do is check the salestrans to make sure a record in the job table had
not been
> deleted, leaving an unmatched record(s) in the salestrans table. This command has been
> sucessful in finding such strays, but it failed to find a problem this time.
>
> I thought by saying plantno+custid+jobno was a way to use a multi-column key in a command.
> Maybe it is literally adding the values?
>
