Friday afternoon toughie - tree endless loop

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Friday afternoon toughie - tree endless loop

Message

From

01/02/2019 20:24:28

01/02/2019 14:23:13

General information

Forum:

Visual FoxPro

Category:

Coding, syntax & commands

Title:

Environment versions

Visual FoxPro:

VFP 9 SP2

OS:

Windows Server 2012 R2

Network:

Windows Server 2012 R2

Database:

Visual FoxPro

Application:

Desktop

Virtual environment:

VMWare

Miscellaneous

Thread ID:

01665871

Message ID:

01665876

Views:

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)