Re: Why?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Richard Stecenko <Stecenko@xxxxxxxxxxxxxx>
Date: Fri, 27 Feb 2009 12:54:16 -0600

The temporary cursor is, sort of, a permanent dbf. It's permanent
until VFP closes the cursor.

When you retrieve the data from the SQL server into your local cursor,
you gave the local cursor an alias.

If you display dbf('the alias') that's where the cursor is written on
your hard drive.

However, that doesn't help you. Because I don't think there's anyway
you can tell VFP to not remove the temporary cursor.

I think your best bet is to hope that there is a date added and a date
modified field in the tables you are trying to preserver and only pull
from the SQL server the records that are new or changed. That might
reduce the amount of time required.

Richard Stecenko
Interactive Computer Services Inc.
Winnipeg, Canada
204.453.2052
.

Follow-Ups:
- Re: Why?
  - From: Richard Stecenko

References:
- Why?
  - From: Brit89
- Re: Why?
  - From: Craig Berntson
- Re: Why?
  - From: Brit89

Prev by Date: Re: csv files with incompatible field names
Next by Date: Re: Why?
Previous by thread: Re: Why?
Next by thread: Re: Why?
Index(es):
- Date
- Thread

Relevant Pages

Re: Error adding command properties for stored procedure call
... I see you are using the SQL Native Client for SQL Server ... A server cursor is not allowed on a remote stored procedure or stored ... The stored procedure called is a test one that simply SELECTs the name field ... int InitializeAndConnect; ...
(microsoft.public.data.oledb)
Row by Row Operations Help req
... Create temp table 1 ... Nigel,The cursor question is the SQL equivalent of the GOTOs / NO GOTOs ... question about whether the familiarity of procedural code is worth the ... leverages the strengths of SQL Server and is usually faster since it uses ...
(microsoft.public.sqlserver.programming)
Re: C5 woes. How stable is VFP really?
... After that I close the SQL server cursor and work with my manual cursor instead. ... a VFP9 app on a really old machine ... app was under more "pressure", VFP showed ...
(microsoft.public.fox.programmer.exchange)
Re: SQL HELP PLEASE!! Cursor only returns part of the data
... First of all, it's not the cursor as such that is bad, it is the looping. ... and re-writing it to handle set-based data will cost you more ... set-based solution do not perform well, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
(comp.databases.ms-sqlserver)
Re: Using Cursors
... it seems I've stirred up a hornet's nest with my cursor question. ... finding the discussion valuable in my circumstances (moving from Oracle to ... SQL Server). ... > DECLARE curEpisode SCROLL CURSOR FOR ...
(microsoft.public.sqlserver.programming)