Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 To: fahim aamir
  Where is fahim aamir?
 karachi
 Nebraska - Pakistan
 fahim aamir
 Tags
Subject: RE: how i use start with in vfp such as oracle plsql
Thread ID: 78623 Message ID: 78639 # Views: 1 # Ratings: 0
Version: Visual FoxPro 8 Category: Databases, Tables and SQL Server
Date: Thursday, October 06, 2005 1:29:06 PM         
   


> hi,
> please give my idea can i use this oracle query in vfp8 or any other query i want result from code to code or i need record from between such as i have record form 1 to 100 but i need only from 201 to 251 and with tree,
>
> this query i tested in oracle it's success
> please
> select * from aamir start with parent is null connect by prior child = parent and parent not in (1, 71);
>
> result
> code 1
> 6
> 61
> 63
> 65
> 653
> 69
> 7
> 71
> 74
> 744
> 746
> 748
> 7481
> 7483
> 7487
> please give my idea



Please post only once.
Ken

ENTIRE THREAD

how i use start with in vfp such as oracle plsql Posted by fahim aamir @ 10/6/2005 11:28:41 AM
RE: how i use start with in vfp such as oracle plsql Posted by Ken Murphy @ 10/6/2005 1:29:06 PM