on 9/30/02 7:42 PM, Yennie .at. aol .DO.T com at Yennie@aol.com wrote:
> Hi Luca, Ruslan,
>=20
> For step 1) here- any reason you could not make this ObjectPtr that point=
s to
> original table?
>=20
> Then later you can select:
> SELECT * FROM myTmp,myTable
>=20
> That way you can get all the fields w/o copying, and you only have 1 CREA=
TE, 2
> INSERT, 1 SELECT.
> Or will INSERT work with ObjectPtr and duplicates?
ObjectPtr can have duplicates.
May be this is good idea.
> Brian
>=20
>>=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
Best regards,
Ruslan Zasukhin [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan .at. paradigmasoft .DO.T com
web: http://www.paradigmasoft.com
To subscribe to the Valentina mail list
send a letter to valentina-on@lists.macserve.net
-------------------------------------------------------------
©2002 Ruslan Zasukhin |
