Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Registros isolados
Message
From
21/04/2004 21:37:41
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Registros isolados
Miscellaneous
Thread ID:
00897084
Message ID:
00897084
Views:
62
Gostaria de depurar uma tabela child onde ficaram registros sem o correspondente registro na tabela parent.

O que estou fazendo errado?

Select tableparent.campo1 from tableparent ;
left outer join child.campo1 = parent.campo1 ;
group by parent.campo1 ;
into cursor Qperdidos

Scan
perdido = qperdidos.campo1
Select child
Locate for child.campo1 = perdido
If found()
Delete
EndIF
select Qperdidos
EndScan


Obrigado pela atençao.
Next
Reply
Map
View

Click here to load this message in the networking platform