Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 2 of 2 total |
Retrieve records from remote table into local table |
Sun, Sep 2 2007 5:12 PM | Permanent 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Friday, March 29, 2024 at 03:30 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |