General information
Category:
Coding, syntax & commands
>>>Here's the problem: I have an SQL statement for which I must index the results.
>>>
>>>If I just SELECT INTO CURSOR mycursor, and attempt to index, I get a 'mytable is readonly' error. (Mytable is the underlying table from which the SELECT was querying).
>>>
>>>I don't want to make the cursor update changes to the base table, so the old USE DBF('mycursor') AGAIN ALIAS whatever doesn't fit the bill.
>>>
>>>I have attempted to SELECT into an array, and then append the results to a cursor, and then index. This works until the query returns a large number of records and then I get 'Too many variables'
>>>
>>>In other situations, I have just used a view and indexed the results of the view, but this statement is too dynamic to use a view.
>>>
>>>How do I handle this?
>>
>>If you call this from a form why not just use radio buttons or combobox or whatever to insert the set order to clause of the query. This way it is dynamic.
>
>My question was how to get the indexes on the results in the first place, not how to arrange the SET ORDER TO statements on the form. By dynamic I meant that the statement is issued with macro expansion, using the results of user chosen query criteria.
Erik,
Again I say why not use radio buttons. How are you getting the User criteria? This is the form I was talking about. You can use the results of the criteria form very easily to create a set order to Cursor. I was not implying that you sort the DATA form.
Sorry for the misunderstanding. Anyway I was out of the country last week and you probably have found your solution.
Previous
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