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 >What's mycursor_one, a table? If it's a table, you need to have it open exclusive - which then doesn't make much sense within a transaction. Transaction is all about writing into tables in non-exclusive environment.
lcTmp=forcepath(forceext(sys(2015),"cdx"), getenv("temp")) index on chassis_no tag chassis_no of (lcTmp) ... your code here... ...and when you close the cursor, kill the file: erase (lcTmp)Haven't tried this inside a transaction, though.