Subject: | Re: Bet way to remove fields from a table?
| Date: | Wed, 12 May 2021 11:21:20 -0400
| From: | "Steven Green" <greens@diamondsg.com>
| Newsgroups: | pnews.paradox-programming
|
if you just query out the fields you want, the query concept itself has the
advantage of being able to rearrange the fields, add fields, make calc
fields, etc.. not an easy option in all situations, but very flexible when
it is an option
--
Steven Green
Myrtle Beach, South Carolina, USA
http://www.OasisTradingPost.com
Collectibles and Memorabilia
Vintage Lego Sets and Parts
- and Paradox support, too
"Jim Short" wrote in message news:609a9535$1@pnews.thedbcommunity.com...
Too many unused fields
OUTLINE
const
tbl1 = ":NABLES:CusPart"
tbl2 = ":NTABLES:CuspartA"
endconst
var
tc1, tc2 tcursor
dyAr dynarray[] Anytype
endvar
tc1.open(tbl1)
tc2.open(tbl2)
tc2.edit()
scan tc1:
tc1.copyToArray(dyAr)
dyAr.removeItem("FieldName")
tc2.insertRecord()
tc2.copyFromArray(dAR)
tc2.unlockRecord()
endscan
tc1.close()
tc2.close()
|