Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
End of file encountered
Message
De
05/07/2004 08:14:11
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
05/07/2004 01:43:56
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00920531
Message ID:
00920692
Vues:
20
>hello,
>
>thank you very much,
>
>it works verey well...

OK.

> ...,and i see create cursor at help,

Well, I can give a small example here, too.

Let's say you need a 10-byte character field, and a numeric field, in a temporary table.
create cursor Temp (MyChar C, MyNumeric N(5,2))
...
select Temp
...
use in Temp
The "create cursor" part will create a cursor (a temporary table), with the alias "Temp". However, if another user (with the same working directory) creates a cursor Temp, there will be no conflict. The table is visible only to the user who created it.

The command "use in temp" (or: "select temp", and then "use") will close the cursor - and destroy it. Of course, commands like "close all", "close database all", etc., will also destroy the cursor. That is, any command that closes all open tables.

If you create the cursor in a form with a private datasession, the cursor will automatically be erased as soon as you close the form! This is because these forms also close all tables opened in them, automatically. The same applies to a "Session" object (VFP6-SP3, or later, I think).
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform