I frequently use code like this in the BEFORE START eep of forms:
PROJECT TEMP ttblMyTable FROM MyTable USING ALL WHERE LIMIT = 0ALTER TABLE
ttblMyTable ADD COLUMN MyColumn1 TEXT(10)ALTER TABLE ttblMyTable ADD COLUMN
MyColumn2 DATETIME
. . .ALTER TABLE ttblMyTable ADD COLUMN MyColumn25 INTEGER
There can be a lot of the ALTER TABLE commands.
In R:Base 7.6 this seems fairly fast. But in R:Base XE each alter table
command takes nearly a second to execute. This is with STATICDB ON, so there
shouldn't be any need to go to disk to check column definitions.
I know I can work around this using one large CREATE TEMP TABLE command in
place of the the PROJECT / ALTER sequence and that's what I've started to do.
But I like the convenience of always getting all columns from MyTable in the
provided code.
Is there any thing I can SET or do to get back to the R:Base 7.6 speed for
ALTER TABLE?--Larry
#yiv9521818804 -- filtered {panose-1:2 4 5 3 5 4 6 3 2 4;}#yiv9521818804
filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv9521818804
filtered {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv9521818804
filtered {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv9521818804
p.yiv9521818804MsoNormal, #yiv9521818804 li.yiv9521818804MsoNormal,
#yiv9521818804 div.yiv9521818804MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv9521818804 a:link,
#yiv9521818804 span.yiv9521818804MsoHyperlink
{color:black;text-decoration:underline;}#yiv9521818804 a:visited,
#yiv9521818804 span.yiv9521818804MsoHyperlinkFollowed
{color:black;text-decoration:underline;}#yiv9521818804 p
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv9521818804
p.yiv9521818804MsoAcetate, #yiv9521818804 li.yiv9521818804MsoAcetate,
#yiv9521818804 div.yiv9521818804MsoAcetate
{margin:0in;margin-bottom:.0001pt;font-size:8.0pt;}#yiv9521818804
span.yiv9521818804BalloonTextChar {}#yiv9521818804
p.yiv9521818804msochpdefault, #yiv9521818804 li.yiv9521818804msochpdefault,
#yiv9521818804 div.yiv9521818804msochpdefault
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv9521818804
span.yiv9521818804emailstyle18 {}#yiv9521818804 span.yiv9521818804EmailStyle22
{color:#1F497D;}#yiv9521818804 span.yiv9521818804EmailStyle23
{color:#1F497D;}#yiv9521818804 span.yiv9521818804EmailStyle24
{color:#1F497D;}#yiv9521818804 span.yiv9521818804EmailStyle25
{color:#1F497D;}#yiv9521818804 span.yiv9521818804EmailStyle26
{color:black;}#yiv9521818804 .yiv9521818804MsoChpDefault
{font-size:10.0pt;}#yiv9521818804 filtered {margin:1.0in 1.0in 1.0in
1.0in;}#yiv9521818804 div.yiv9521818804WordSection1 {}#yiv9521818804
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
