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

Click here to load this message in the networking platform