Hi List,
I have a simple (I hope) MB-Oracle question.... I have a MB application which connects to a remote Oracle database, links to the required tables, saves them in MapInfo format on the local machine, and closes the connection (the amount of data is not so great). The idea being that the user only has to connect to the Oracle database when they want to update the locally stored tables. At the moment, if the user chooses to access data from the Oracle database, the local MapInfo tables are overwritten. My question is, if changes have been made in the database (new/altered records) does anyone have suggestions as to the best (quickest) way to update the local tables without rewriting the entire tables? I realise I can use the Server Refresh statement to update the tables, but my understanding is that this command erases the files and recreates them. Is the alternative to first execute a SQL query on the database for records created/modified after a certain date (the last connection to the database), then add to/alter the local tables accordingly through a series of queries and updates, or is there an easier method? Cheers, Steven Kalma Integrated Data Solutions _______________________ URS Dames & Moore Treubstraat 33, 2288EH, Rijswijk. The Netherlands +31 (0)70 336 90 89 (direct) +31 (0)70 319 21 12 (switch) +31 (0)6 53 42 89 76 (mobile) +31 (0)70 319 11 25 (fax) [EMAIL PROTECTED] www.urscorp.com/europe _______________________ _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
