Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Retrieve records from remote table into local table
Sun, Sep 2 2007 5:12 PMPermanent Link

=?iso-8859-1?Q?Luis_Concepci=F3n?=
Hi!

I have two equal tables, with the same structure, on both client and server
machines.
Users can modify, add or delete records on both machines, but I need an
option to make them equal at a given time, just to retrieve the records from
the 'server' table, overwritting the client table.

Which is the best method? May I use LoadFromStream? Is it better to use a
simple "select into..." sql query?

Thanks!
Tue, Sep 4 2007 9:18 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Luis,

<< Which is the best method? May I use LoadFromStream? Is it better to use a
simple "select into..." sql query? >>

You can't use a query, so LoadFromStream is the best solution provided that
the table isn't extremely large.  Just be sure to empty the local
destination table using EmptyTable prior to using the LoadFromStream method.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image