I don't know what to do! I'm just trying to add one new field to the end of the table but when i get to the table.restructure command, it gives me that error. Any suggestions? HEre's the code.
-Alex
method run(var eventInfo Event)
addpassword("peterpiper"
tbl.attach( ":CLIENT:CLIENT.DB" )
tbl.unlock("Full"
tbl.enumFieldStruct( "RIV:field_struct.db" )
tcFlds.open("RIV:field_struct.db" )
tcFlds.edit()
;//add a field Test2 at the end of table
tcFlds.end()
tcFlds.insertAfterRecord()
tcFlds.(1) = "URL" ;field name
tcFlds.(2) = "ALPHA" ;field type
tcFlds.(3) = 30 ;size
tcFlds.(4) = 0
tcFlds.endEdit()
tcFlds.close()
dynNewStru["FIELDSTRUCT"] = "RIV:field_struct.db"
if tbl.restructure(dynNewStru) then
msginfo("Yay", 1)
endif
endMethod
-Alex
method run(var eventInfo Event)
addpassword("peterpiper"
tbl.attach( ":CLIENT:CLIENT.DB" )
tbl.unlock("Full"
tbl.enumFieldStruct( "RIV:field_struct.db" )
tcFlds.open("RIV:field_struct.db" )
tcFlds.edit()
;//add a field Test2 at the end of table
tcFlds.end()
tcFlds.insertAfterRecord()
tcFlds.(1) = "URL" ;field name
tcFlds.(2) = "ALPHA" ;field type
tcFlds.(3) = 30 ;size
tcFlds.(4) = 0
tcFlds.endEdit()
tcFlds.close()
dynNewStru["FIELDSTRUCT"] = "RIV:field_struct.db"
if tbl.restructure(dynNewStru) then
msginfo("Yay", 1)
endif
endMethod