Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to Index a cursor within transaction?
Message
From
13/06/2007 06:35:23
 
 
To
13/06/2007 00:10:27
Aye Mya Thida Kyaw
Ingenuity Microsystems Sdn Bhd.
Kuala Lumpur, Malaysia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01232486
Message ID:
01232524
Views:
17
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform