Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Checking for existence of cursor
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00033839
Message ID:
00033898
Vues:
52
>>>Whoops! Um...when I try to INSERT INTO mycursor FROM ARRAY myarray, it tells me that the cursor is readonly. I suppose that wouldn't happen if I CREATE CURSOR from the beginning, but what is the most efficient way to make the cursor not be readonly?
>>
>>There's a quite original tip for that on the Tip's section of VFUG.
>>I don't exactly remember now, you'll have to check it there...
>>
>>Renato
>
>You can do a:
>
>use dbf('oldcursor') again in 0 alias newcursor
>
>this will give an editable new cursor...

Tip #8 in VFUG says much the same thing as Mr. T. A. Bureaucrat says:

SELECT 0
lnSelArea=SELECT()
USE DBF("Cursor_Name") in (lnSelArea) again alias New_Alias
select Cursor_Name
USE
select NewAlias

but since I wanted my old cursor back, I went:

SELECT 0
lnSelArea=SELECT()
USE DBF("SkaRange") in (lnSelArea) again alias NewAlias
select SkaRange
USE
SELECT 0
lnSelArea=SELECT()
USE DBF("NewAlias") in (lnSelArea) again alias SkaRange
select NewAlias
USE
SELECT SkaRange

The .RowSource of my list box had to be set to "" before I did this, and then set back to SkaRange afterwards, so I wouldn't get an error saying "cannot access the selected table (1152)."

Thanks, guys.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform