Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
'set relation to' on sql cursor
Message
De
18/02/2003 10:13:52
 
 
À
18/02/2003 10:01:04
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:
00754465
Vues:
26
SWEEEEEEET!!! That was it!!! I love UT. Thanks, Jim

>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
Répondre
Fil
Voir

Click here to load this message in the networking platform