Paradox Community

Items in pnews.paradox-programming

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() 


Copyright © 2004 thedbcommunity.com