Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need a select query to determine whats the max no of poi
Message
From
13/05/2005 11:55:01
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
13/05/2005 11:38:23
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01013892
Message ID:
01013910
Views:
10
>I have a table tasks: and the field name is Taskcode:
>
>In the taskcode: i can enter .01 or .01.102 or .01.102.103 like that
>
>So i have to find searching all rows in that table for that field(Taskcode) to see where maximum points are.
>each point represents one level:
>
>if it is .01 only it is 1 only one level
>
>if it is .01.12.14 then it is 3 has three levels, i see there are three points in it.
>
>ones i establish the maximum levels then i can do the other stuff.
>
>Can you please tell me, is it possible to get that info.
>
>Table name is Tasks and field name is Taskcode.
>
>Thank you very much for the information.
select top 1 occurs('.',TaskCode) as Level,* ;
 from myTable ;
 order by 1 descending
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform