Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
File returned by DBF() does not exist!!!
Message
De
07/02/2000 03:26:21
Ilie Tomac
Eagle Investment Systems LLC
Boston, Massachusetts, États-Unis
 
 
À
07/02/2000 02:55:31
Juan Kh
Dataprop Technologies
Sungai Petani, Malaisie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00328150
Message ID:
00328165
Vues:
30
Hi, Juan...

It seems to me that this info will be interesting for you.
My russian college Alexander Korolev have found very coll way
to make cursor updatable and I consider that he understood how
the cursor is really created.
He guesses that cursors can be created in two ways:
- in memory
- physically on disk.
Second possibility can be reached if someome uses NOFILTER
clause in SELECT SQL statement. In this case you can use
following code

select ..... from ..... into cursor myCursor NOFILTER
=ReUse('myCursor')

function reUse
lparameters _alias_
local _dbf_
_dbf_ = dbf(_alias_)
use (_dbf_) again alias ReUsedDB in 0
use in (_alias_)
use (_dbf_) again alias (_alias_) in 0
use in ReUsedDB
select (_alias_)
return

Cursor may even be indexed by structural tag, with first tag
being created before ReUse() function. For instance:

select ..... from ..... into cursor myCursor NOFILTER
index on Field1 tag TAG1
=ReUse('myCursor')
index on Field2 tag TAG2
index on Field3 tag TAG3

But you should take into account that NOFILTER can reduce
performance.

Hope this helps,
Ilie.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform