Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Integer/date compound index
Message
From
28/06/2007 12:04:55
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01236371
Message ID:
01236442
Views:
14
>>>>>Not? I got record Id something like an emp_id.
>>>>>Cetin
>>>>
>>>>I meant that date has nothing to do with relation.
>>>
>>>You want to relate two tables by ID and show child table in the descending date order.
>>
>>I don't want to use SET RELATION for that, and nobody should. If you want to do it then do it as you always do: get a recordset.
>
>Me neither, actually :) I don't think I use SET RELATION command in my code, only in the quick tries in the command window.
>
>But if we consider the theoretical question... :)

Come on. Not in theory. I do use SET RELATION in my code and will continue to use until something better is invented (and VFP not having another version unlikely).
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
Next
Reply
Map
View

Click here to load this message in the networking platform