• Developer Zone
• Lists Home
• FAQ

Hi.

Yes - I'be been thinking of this too. I'm doing pretty much the same
thing using Delphi with other tables in the database, but only record
by record. Also I'm trying to avoid using Delphi (read BDE) in this
case. But unless I find a better way, this will probably be the way
I'll go.

Thanks. /Anders

On Tue, 16 Nov 1999 14:56:55 +0100, Dennis Thrysøe wrote:
>Perhaps the best thing would be writing a script that could connecto to bot
>access and mysql?
>Rhis could be done in Delphi with very few hassles.

>> Hi!
>>
>> I'm using mysql-win32 v. 3.22.26a as the main data source for an
>> internet map server.
>> The information in the databases are primarily updated through a bunch
>> of Delphi interfaces - and this works fine.
>>
>> I have one table, though, that i'm having trouble finding a suitable
>> update method for...
>> The table is app. 25.000 records, and when it is to be updated, all the
>> data will have to be replaced.
>> The data originally comes from a local MS Access database.
>> What i have been doing up to now is to take down the map server, move
>> the table to a different name, then importing the data from MS Access
>> using ODBC. After this I alter the table manually by setting indexes,
>> "not-nulling" different fields etc.
>>
>> Now - I'll be leaving this project pretty soon, and the update
>> procedure will be taken over by someone else. I'm trying to make it as
>> easy as possible to update the database, but I'm not sure that the
>> above procedure is the best in this case. I would like it a bit more
>> automated, I guess.
>>
>> Does anyone have any ideas, advices etc. that could help me find the
>> best way to update this table?
>>
>> Best Regards /Anders
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> --
>> Anders Engström
>> GIS-Centrum, Lund
>> 0709-62 07 73
>> =============================
>>    Your mind's like an umbrella.
>>    It doesn't work unless you open it.
>>                          /Frank Zappa
>>
>>
>>
>> ---------------------------------------------------------------------
>> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>> posting. To request this thread, e-mail win32-thread955@stripped
>>
>> To unsubscribe, send a message to the address shown in the
>> List-Unsubscribe header of this message. If you cannot see it,
>> e-mail win32-unsubscribe@stripped instead.
>>
>>
>
>
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail win32-thread956@stripped
>
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail win32-unsubscribe@stripped instead.
>

-- 
Anders Engström
GIS-Centrum, Lund
0709-62 07 73
=============================
   Your mind's like an umbrella.
   It doesn't work unless you open it.
                         /Frank Zappa