ERROR
This error occurs after adding records to previously declared turntable:"Unsorted or corrupt turntable"
The turntable VTab is not sorted.
Code:
'-- This script performs a permanent sort on a VTab.
atable = av.getactivedoc
avtab = atable.getvtab
tempname = av.getproject.makefilename("sorted","dbf")
newFileName = FileDialog.Put (tempname, "*.dbf", "Choose output table name")
if(newFileName = nil) then return nil end
anewvtab = vtab.Makenew(newFileName, dbase)
anewtable = table.make(anewvtab)
anewtable.setname(newFileName.getname)
afieldlist = avtab.getfields
sortfield = msgbox.choiceasstring(afieldlist, "Please select the 'NODE' field:", "Node Field")
atable.sort(sortfield, false)
avalue = nil
anewvtab.seteditable(true)
otherfieldlist = afieldlist.clone
for each f in otherfieldlist
anewvtab.addfields({f.clone})
end
for each rec in avtab
newrec = anewvtab.addrecord
for each x in otherfieldlist
arecordnumber = atable.convertrowtorecord(rec)
z = avtab.returnvalue(x,arecordnumber)
anewvtab.setvalue(anewvtab.findfield(x.getalias),rec,z)
end
end
anewvtab.seteditable(false)
anewtable.getwin.open
Article ID:000003333
Get help from ArcGIS experts
Download the Esri Support App