User Shum, Garry (garry.shum@rbc.com.nospam) posted:

------_=_NextPart_001_01C1BE4F.4DBA3FB0
Content-Type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

I currently have some table files automatically updated by reading,
processing and copying the necessary changes into a new table file that
replaces the original. This involves adding new rows into the table file i=
n
many places. I do this by reading every row of the original table file,
making the changes, adding the new rows, then going to the next row until
the last row. This takes too long so I'm going to try optimizing things to
cut the time below half an hour. The way I can see this being speeded up
greatly is by "inserting" rows into those areas where a new row is required=
.
However, I don't know how to insert a row into the middle of table. There
doesn't seem to be any functions to do this. I'm not sure this is even
possible. Any ideas?
=20
=20
=20

---------------------------------------------------------------------------=
---------------------------------------------------------------------------=
----------------------------------------------------------------
This e-mail may be privileged and/or confidential, and the sender does not =
waive any related rights and obligations. Any distribution, use or copying =
of this e-mail or the information it contains by other than an intended rec=
ipient is unauthorized. If you received this e-mail in error, please advise=
me (by return e-mail or otherwise) immediately.=20

Ce courriel est confidentiel et prot=E9g=E9. L'exp=E9diteur ne renonce pas =
aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation =
ou copie de ce message ou des renseignements qu'il contient par une personn=
e autre que le (les) destinataire(s) d=E9sign=E9(s) est interdite. Si vous =
recevez ce courriel par erreur, veuillez m'en aviser imm=E9diatement, par r=
etour de courriel ou par un autre moyen.=20


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3 D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3 D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3 D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

------_=_NextPart_001_01C1BE4F.4DBA3FB0
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

< !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Diso-8859-=


<META content=3D"MSHTML 5.50.4807.2300" name=3DGENERATOR></HEAD>


ently have=20
some table files automatically updated by reading, processing and copying t=
he=20
necessary changes into a new table file that replaces the original. T=
his=20
involves adding new rows into the table file in many places.I do this=
by=20
reading every row of the original table file, making the changes, adding th=
e new=20
rows, then going to the next row until the last row. This takes too l=
ong=20
so I'm going to try optimizing things to cut the time below half an hour.&n=
bsp;=20
Theway I can see this being speeded up greatly is by "inserting"=20
rowsinto those areas where a new row is required. However, I do=
n't=20
know how to insert a row into the middle of table. There doesn't seem=
to=20
be any functions to do this. I'm not sure this is even possible.&nbsp=
; Any=20
=20

IMPORTANT EMAIL ADDRESSES:

Post message: winrunner@yahoogroups.com

Subscribe: winrunner-subscribe@yahoogroups.com

Unsubscribe: winrunner-unsubscribe@yahoogroups.com

***To unsubscribe via email: From your email program, send a blank message =
to winrunner-unsubscribe@yahoogroups.com.

*To reply to the entire list, use the Reply button in your email program<BR=
*To respond offline to an individual, locate the sender's email address in =
the email message

*To view archives go to groups.yahoo.com

Direct any questions, comments, or issues about this list to...

Eric Marx

---------------------------------------------------------------------------=
This e-mail may be privileged and/or confidential, and the sender does not =
waive any related rights and obligations. Any distribution, use or copying =
of this e-mail or the information it contains by other than an intended rec=
ipient is unauthorized. If you received this e-mail in error, please advise=
me (by return e-mail or otherwise) immediately.

Ce courriel est confidentiel et prot=E9g=E9. L'exp=E9diteur ne renonce pas =
aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation =
ou copie de ce message ou des renseignements qu'il contient par une personn=
e autre que le (les) destinataire(s) d=E9sign=E9(s) est interdite. Si vous =
recevez ce courriel par erreur, veuillez m'en aviser imm=E9diatement, par r=
etour de courriel ou par un autre moyen.

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3 D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3 D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3 D=3D=3D=3D=3D=3D=3D=3D=3D=

------_=_NextPart_001_01C1BE4F.4DBA3FB0--