Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How will I ever get my app ported to SQL Server?
Message
From
20/08/2008 23:09:50
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01338696
Message ID:
01340675
Views:
15
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
Map
View

Click here to load this message in the networking platform