Re: Quicker to USE AGAIN instead of SELECT * ?

2012-08-29 Thread MB Software Solutions, LLC
On 8/10/2012 6:47 PM, Rafael Copquin wrote: What I do in these cases is convert the cursor to xml using the xmladapter and send it back as a variable to the calling form. The calling form then receives it back as xml and using xmladapter turns it back into a cursor What you're describing is

Quicker to USE AGAIN instead of SELECT * ?

2012-08-10 Thread MB Software Solutions, LLC
VFP9SP2 I've got a temporary cursor that I manipulate and then need to return a cursor to the calling routine named what was requested (via parameter). Would it be quicker to do USE MyTempCursor AGAIN IN 0 ALIAS MyDesiredCursorName or do a SELECT * FROM MyTempCursor INTO CURSOR

Re: Quicker to USE AGAIN instead of SELECT * ?

2012-08-10 Thread Fred Taylor
Not sure about the speed, but you need to use a syntax like this: USE (DBF(query)) AGAIN IN 0 ALIAS test Fred On Fri, Aug 10, 2012 at 9:33 AM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: VFP9SP2 I've got a temporary cursor that I manipulate and then need

Re: Quicker to USE AGAIN instead of SELECT * ?

2012-08-10 Thread M Jarvis
On Fri, Aug 10, 2012 at 9:33 AM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: VFP9SP2 I've got a temporary cursor that I manipulate and then need to return a cursor to the calling routine named what was requested (via parameter). Would it be quicker to do

Re: Quicker to USE AGAIN instead of SELECT * ?

2012-08-10 Thread Peter Cushing
M Jarvis wrote: Well, to quote our good friend Ed, it depends... Sorry but it depends is © Ted Roche :-) Peter Rajan Imports has changed - we are now Whispering Smith Ltd. For more information see our website at

Re: Quicker to USE AGAIN instead of SELECT * ?

2012-08-10 Thread Ed Leafe
On Aug 10, 2012, at 12:01 PM, Peter Cushing wrote: Well, to quote our good friend Ed, it depends... Sorry but it depends is © Ted Roche It's easy to remember - Ted is the one who wears Depends. ducks! -- Ed Leafe ___ Post

Re: Quicker to USE AGAIN instead of SELECT * ?

2012-08-10 Thread Paul McNett
On 8/10/12 9:33 AM, MB Software Solutions, LLC wrote: VFP9SP2 I've got a temporary cursor that I manipulate and then need to return a cursor to the calling routine named what was requested (via parameter). Would it be quicker to do USE MyTempCursor AGAIN IN 0 ALIAS MyDesiredCursorName

Re: Quicker to USE AGAIN instead of SELECT * ?

2012-08-10 Thread Rafael Copquin
What I do in these cases is convert the cursor to xml using the xmladapter and send it back as a variable to the calling form. The calling form then receives it back as xml and using xmladapter turns it back into a cursor Both forms have private data sessions ** calling form Local oXML,cXML