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 strongm 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
Feb 27, 2006
1
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