General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Not sure sure I follow this...
Say I have formJobs that has a Customers CursorAdapter with an alias of Customers. Now, if I launch 2 instances of this form, wouldn't I I be trying to create an index for each form instance, each being an index for the alias Customers?
>You're creating structural indexes, so they inherit the physical name of the cursor. Multiple instances then will become non-issue.
>
>>Wow. I'm suprised to see that it works this way. I thought about doing it this way, but it sure seemed like a silly thing to do, so I dismissed it as not a reasonable technique. Is this a common practice?
>>
>>Also, since my app allows users to run mutiple instances of the same form, how can I prevent the indexes from one form instance from overwriting the indexes of another form instances?
>>
>>I need some mechanism to generate a random index name?
>>
>>
>>
>>
>>>You need to create your indexes for your cursors after you get them with CursorFill. Consider these cursors the same way as regular cursors or as local views. Once you get them, you need to index them. If you get them again with cursorfill, you need to re-create indexes again.
>>>
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