Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Restructure

Status
Not open for further replies.

brodlang

Technical User
Joined
Feb 27, 2006
Messages
1
Location
US
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(":project: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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top