General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
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