Tom Dover 17.Mar.09 06:37 AM a Web browser LC LSX All Releases Windows
Wondering if some of you might be able to give me some much needed direction with regards to updating an SQL db view the LCLSX using an ODBC connection.
I've written code using LCLSX before to update oracle tables. No problem as our servers have the Oracle client installed. I've setup an odbc data source on my client and on one of our servers and have tested and confirmed that I can connect to the sql db. So no worries there.
My questions are based around the approach to updating the sql db. When writing to Oracle I found it quicker to delete the contents of a table and then repopulate by creating LCField & LCFieldList objects containing upto 30k records and throwing them across rather than updating table records.
So - the questions:-
1. Is this approach workable via odbc or do I need a different mindset
2. Is this approach acceptable or are there further connotations to 'rip-and-replace' over updating
3. If I wanted to test to see if a record exists or needs updating, and then insert or update accordingly how do I achieve that?
I don't need any assistence from the 'LotusScript' perspective - it's just a case of trying to find out which approach is best.