--part1_163.14c6201c.2ac9d8f3_boundary
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi Luca, Ruslan,
For step 1) here- any reason you could not make this ObjectPtr that points t=
o=20
original table?
Then later you can select:
SELECT * FROM myTmp,myTable
That way you can get all the fields w/o copying, and you only have 1 CREATE,=
=20
2 INSERT, 1 SELECT.
Or will INSERT work with ObjectPtr and duplicates?
Brian
>=20
> 1) Create TMP table.
> =A0 =A0 you can use as V4WS API or use SQL Command CREATE TABLE.
> =A0 =A0 I hope you know how to do this.
> =A0 =A0 I recommend to use CREATE TABLE because it is faster.
>=20
> EXMAPLE: one ID field in table
> =A0 =A0=20
> =A0 =A0 db.SqlExecute( "CREATE TABLE myTMP (ID ulong)")
>=20
--part1_163.14c6201c.2ac9d8f3_boundary
Content-Type: text/html; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
<HTML><FONT FACE=3Darial,helvetica><FONT COLOR=3D"#000000" FACE=3D"Geneva" F=
AMILY=3D"SANSSERIF" SIZE=3D"2" STYLE=3D"BACKGROUND-COLOR: #FFFFFF">Hi Luca,=20=
Ruslan,<BR>
<BR>
For step 1) here- any reason you could not make this ObjectPtr that points t=
o original table?<BR>
<BR>
Then later you can select:<BR>
SELECT * FROM myTmp,myTable<BR>
<BR>
That way you can get all the fields w/o copying, and you only have 1 CREATE,=
2 INSERT, 1 SELECT.<BR>
Or will INSERT work with ObjectPtr and duplicates?<BR>
<BR>
Brian<BR>
<BR>
<BLOCKQUOTE CITE STYLE=3D"BORDER-LEFT: #0000ff 2px solid; MARGIN-LEFT: 5px;=20=
MARGIN-RIGHT: 0px; PADDING-LEFT: 5px" TYPE=3D"CITE"></FONT><FONT COLOR=3D"#0=
00000" FACE=3D"Geneva" FAMILY=3D"SANSSERIF" SIZE=3D"2" STYLE=3D"BACKGROUND-C=
OLOR: #FFFFFF"><BR>
1) Create TMP table.<BR>
=A0 =A0 you can use as V4WS API or use SQL Command CREATE TABLE.<BR>
=A0 =A0 I hope you know how to do this.<BR>
=A0 =A0 I recommend to use CREATE TABLE because it is faster.<BR>
<BR>
EXMAPLE: one ID field in table<BR>
=A0 =A0 <BR>
=A0 =A0 db.SqlExecute( "CREATE TABLE myTMP (ID ulong)")<BR>
</BLOCKQUOTE></FONT><FONT COLOR=3D"#000000" FACE=3D"Geneva" FAMILY=3D"SANSSE=
RIF" SIZE=3D"2" STYLE=3D"BACKGROUND-COLOR: #FFFFFF"><BR>
<BR>
</FONT><FONT COLOR=3D"#000000" FACE=3D"Geneva" FAMILY=3D"SANSSERIF" SIZE=3D"=
2" STYLE=3D"BACKGROUND-COLOR: #FFFFFF"></FONT></HTML>
--part1_163.14c6201c.2ac9d8f3_boundary--
--part1_163.14c6201c.2ac9d8f3_boundary
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
©2002 Yennie at aol D.O.T com |
