Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Thanks both anyway for the thoughts. And especially Mark for the time spent on this.
I guess the bottom line is that views are just damned slow. Unless I want to radically re-write what I've done so far, I suppose I'm just kind of stuck with the situation.
I suppose I'll have to spend a little pondering this anyway. Who knows, I might come to the conclusion that time spent re-writing is actually worth it in the long run.
Again, thanks guys.
Alan
>Oh well.
>
>I assume the enhancement request is being written as we speak < s >.
>
>Cheers
>
>>Nope. Tried that also. What a PITA to be forced to use a SQL View or do it yourself with straight code. All 7 does is eliminate the need to do the following:
>>
>>USE (dbf('MyCursor')) again in 0 alias crsNewCursor
>>use in MyCursor
>>select crsNewCursor
>>
>>This will be an Enhancement Request for 8.
>>
>>>Hi Mark,
>>>
>>>I wonder if the new undateable CURSORs in VFP7 provide relief with this?
>>>
>>>Just a thought.
>>>
>>>Cheers
>>>
>>>
>>>>I guess you can only do it for SPT cursors which, BTW, is where I have only done this because almost all my work is in Oracle. IMO, this is a really stupid restriction. I guess you could create a DSN-less connection to that table using SQLStringConnect(). This is sooo convoluted. IF you decide to go this way, get my ODBC_DSN class from UT Downloads.
>>>>
>>>SNIP
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement