Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Possible in one SELECT command?
Message
From
01/11/2005 03:57:48
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01063783
Message ID:
01063924
Views:
18
>Hi Fabio
>Thank you for all the time you tool helping me with this, i really appreciate it.

This is a general problem, and the solution is also useful to me

>1) I think you misunderstood the time issue: it took 4 seconds to run your code **with a 250,000 records** table, which is in this case, very very nice.

It doesn't convince me.
How many are the records of the result?

>2) What i meant is that when running this in my real table, the results are correct, but they are not grouped correctly by time, like in:
>CTime    Sunday    Monday    Tuesday ...
>10:00    Fabio
>10:00              Fabrizio            <-- why not in the upper row?
>10:15    Jaime     Fabio
>
Post the filtered SELECT-SQL, something doesn't certainly work

>What i meant is that for more or less 1% of cases i get like in the 10:15 above ( 2 or more in the same row ), generally they are splitted.
>
>As i also mentioned, this is not a problem. Just woke up, and while drinking a huge ristretto, am writing a SCAN...ENDSCAN that will tighten those rows a little more :-)
>
>Jaime
>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform