General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2008 Server
>>>Please help my elderly brain
>>>
>>>SET ORDER to field1 > 0 AND field2 = 3
>>>
>>>I need to accomplish this, but haven't been successful. Any help appreciated
>>
>>SET FILTER, mentioned in the other reply, is used to show only specific records. You can also SELECT FROM ... WHERE [condition].
>>
>>SET ORDER is used to activate a specific, already existing, index. These are used mainly for ordering.
>
>Thanks Hilmar - The table must be accessed but not seen so, SELECT FROM is not the answer. I am having some success SETting the ORDER and using SKIP to gather information from each field, but need to index on 9 fields. Maybe one index for each field is the answer. What do you think?
Grady-what are you trying to do? If you need info from each field, SQL SELECT may well be the right answer. The results only show up in a browse if you fail to include the INTO clause.
Tamar
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only