Friday afternoon toughie - tree endless loop

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Friday afternoon toughie - tree endless loop

Message

01/02/2019 20:24:28

01/02/2019 14:23:13

Information générale

Forum:

Visual FoxPro

Catégorie:

Codage, syntaxe et commandes

Titre:

Versions des environnements

Visual FoxPro:

VFP 9 SP2

OS:

Windows Server 2012 R2

Network:

Windows Server 2012 R2

Database:

Visual FoxPro

Application:

Desktop

Virtual environment:

VMWare

Divers

Thread ID:

01665871

Message ID:

01665876

Vues:

Can't you simply check for such cases with an SQL like:

select * from myTable t1 ;
where exists (select * from myTable t2 ;
  where t1.Company_id = t2.ParentColId and t1.ParentColId = t2.Company_Id)