Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need a select query to determine whats the max no of points
Message
From
13/05/2005 11:38:23
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Need a select query to determine whats the max no of points
Miscellaneous
Thread ID:
01013892
Message ID:
01013892
Views:
56
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.
Next
Reply
Map
View

Click here to load this message in the networking platform