how get account tree through query from vfp table


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 1 of 1

Thread: how get account tree through query from vfp table

  1. #1
    Join Date
    Oct 2005
    Posts
    7

    Exclamation how get account tree through query from vfp table

    hi,
    i have table with to field father and child

    father child
    ================
    null | 1
    1 | 11
    11 | 111
    111 | 1111
    null | 2
    2 | 21
    21 | 211
    1 | 12
    12 | 121
    12 | 122
    null | 3
    3 | 31
    31 | 311
    211 | 2111
    311 | 3111

    and i need result in this form

    child
    =====
    1
    11
    111
    1111
    11111
    12
    121
    1211
    12111
    3
    31
    311
    3111
    31111

    i complete in oracel by using connect by function
    but in foxpro i can not

    please send me query in foxpro
    Last edited by mfa; 10-15-2005 at 03:25 AM.

Similar Threads

  1. Empty Table Ruins Query
    By justravis in forum Database
    Replies: 10
    Last Post: 12-18-2002, 10:20 AM
  2. reg....count distinct query
    By Mohan Ekambaram in forum Database
    Replies: 0
    Last Post: 12-08-2001, 11:21 PM
  3. SQL query performance
    By Daniel in forum Database
    Replies: 5
    Last Post: 08-20-2001, 04:00 PM
  4. Replies: 5
    Last Post: 08-20-2001, 08:04 AM
  5. How to use a VFP dbf table in VB
    By Alaster in forum VB Classic
    Replies: 0
    Last Post: 03-18-2001, 02:46 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center