Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexs on temporary cursors
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00324974
Message ID:
00325023
Views:
19
>Hi Ed,
>
>Sorry to disagree, but i have the same code at another application and it works OK! I have many indexs for a IDX file, on a temporary cursor, which is not updatable.

The issue is not if it is updatable, but if it is writable. The results of a SQL Select to a cursor are not writable, unless you force it to write a temporary file, and reopen the temporary file with the USE statement. Views are generally writable - even if you can't write the changes back to the base tables, you can append and modify data in the view.

The index rules:

Any cursor can have a single tag in a structural CDX
Any writable cursor can have as many tags in a structural CDX as you want
You can have an unlimited number of IDXs on a cursor
Structural CDXs on cursors are deleted automatically when the cursor is closed
IDX files on cursors are not deleted when the cursor closes

The result of a SQL SELECT (not a View) is not writable as created. It can be made writable if it is a real temporary file rather than a filtered view, and opened via USE...AGAIN

>The only difference is: for this case, this cursor can be removed and created with new information at the same form. "Why don't you delete the records, instead of removing the cursor?" you may asking yourself. The reason is that cursor can have new fields, depending of some choices of the user (choosen at the form).
>

I think you're being presumptuous and pompous here; I have some clue about how file access works, and even about how to offer my users a flexible user interface, but you needn't believe that if you'd rather not. I'm certain thatsomeone here might benefit from your approach. Visual AccountMate has had a similar feature in their data browser for a while.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform