Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to Index a cursor within transaction?
Message
 
 
À
13/06/2007 00:10:27
Aye Mya Thida Kyaw
Ingenuity Microsystems Sdn Bhd.
Kuala Lumpur, Malaisie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Divers
Thread ID:
01232486
Message ID:
01232523
Vues:
13
>Dear all,
>
> I need to index a cursor which is within begin-end transaction. But I'm having error message "command cannot be issued within a transaction" on "index" line. My coding syntax goes as follow :
>      Select myCursor_one
>      lcmdbf=dbf()
>      select 0
>      use (lcmdbf) again alias cursor_one
>      index on chassis_no tag chassis_no
>      set order to chassis_no
>
>      select myTable
>      set relation to myTable.chassis_no into cursor_one
>
>Hope to get any help.
>Thanks in advance.
>
>Regards,
>Mya.

Structural indexes within transactions are not supported. It is documented in the Help file.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform