Hi,
I'm not a programmer, but I have a lot of Pdox (and some PAL) experience. I'm trying to restructure a table with PAL so that the look up table changes. My code so far (taken mostly from PAL help) looks like this:
var
tbl Table
tcFlds TCursor
dynNewStru DynArray[] Anytype
test Array[] String
endvar
tbl.attach("roject:09 Hardware Product.db")
tbl.enumFieldStruct( "field_struct.db" )
tcFlds.open("field_struct.db" )
tcFlds.edit()
scan tcFlds :
if tcFlds."Field Name" = "MFGC" then
tcFlds."_Table Lookup" = "K:\\Net Test\\ProjMgt\\Rolodex.db"
;**this works to this point.
quitLoop
endif
endscan
tcFlds.endEdit()
tcFlds.close()
dynNewStru["FIELDSTRUCT"] = "field_struct.db"
tbl.restructure( dynNewStru )
The "field_struct" table is enumerated correctly, but I cannot get my original table to restructure. I do get the following error message:
"Invalid array of validity check descriptors. Table "K:\Net Test\Project Folders\26116\09 Hardware Product.db" which is the "hard" path of my original table.
Any help is appreciated. I looked at other messages but didn't see anyone with this error. Like I said, I'm not a programmer, so dumb it down if you can.
Thanks,
brodlang
I'm not a programmer, but I have a lot of Pdox (and some PAL) experience. I'm trying to restructure a table with PAL so that the look up table changes. My code so far (taken mostly from PAL help) looks like this:
var
tbl Table
tcFlds TCursor
dynNewStru DynArray[] Anytype
test Array[] String
endvar
tbl.attach("roject:09 Hardware Product.db")
tbl.enumFieldStruct( "field_struct.db" )
tcFlds.open("field_struct.db" )
tcFlds.edit()
scan tcFlds :
if tcFlds."Field Name" = "MFGC" then
tcFlds."_Table Lookup" = "K:\\Net Test\\ProjMgt\\Rolodex.db"
;**this works to this point.
quitLoop
endif
endscan
tcFlds.endEdit()
tcFlds.close()
dynNewStru["FIELDSTRUCT"] = "field_struct.db"
tbl.restructure( dynNewStru )
The "field_struct" table is enumerated correctly, but I cannot get my original table to restructure. I do get the following error message:
"Invalid array of validity check descriptors. Table "K:\Net Test\Project Folders\26116\09 Hardware Product.db" which is the "hard" path of my original table.
Any help is appreciated. I looked at other messages but didn't see anyone with this error. Like I said, I'm not a programmer, so dumb it down if you can.
Thanks,
brodlang