Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to Index a cursor within transaction?
Message
De
13/06/2007 06:35:23
 
 
À
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:
01232524
Vues:
16
>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.

If you look at the Help for transactions you'll see a list of commands that are not allowed within xactions, like the error message told you. Besides, I see no reason why these actions would need to be within a xaction; it's not as if you're bulk-updating a load of data.

HTH
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform