Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
'set relation to' on sql cursor
Message
De
18/02/2003 10:01:04
 
 
À
18/02/2003 09:39:22
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00753966
Message ID:
00754456
Vues:
22
Just a SWAG, but have you tried with the READWRITE clause of Select-SQL?

good luck


>Okay... This works,... ONCE!!. I am wanting the Headers of a grid to re-index the data in the grid. The data is from a SQL cursor. With you suggestion, I can click a certain header to sort by QTY, and it work. But then if I click another column to sort by PRICE, it says "\xxx\yyy.tmp" is read only. It must be talking about the temporary index file it built from the first header click. I tried SET SAFETY OFF, but that did not help. It's seems you would need to release the index file, before trying to create another one, so I tried SET ORDER TO, but that did not help either. I am sooo close.
>
>
>
>>
>>Create structural index. It has the same name as cursor's temp. table, so you don't have to worry about it's name.
SELECT ... INTO CURSOR mycursor NOFILTER
>>INDEX ON myfield TAG myfield
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform