On Wednesday, June 25, 1997 11:26 AM, Friedrich Harasleben
[SMTP:[log in to unmask]] wrote:
> Hi there,
>
> for those of you how might be interested. Sometimes ago there was a
> mail
> on this list by Herbert Baumgartner, how wanted to know if somebody
> has
> done successful updates on an IMAGE/SQL database from EXCEL.
>
> Yes, it works. Altough it is not very fast it does what one expects
> it to
> do (even with the standard HP ODBC driver).
>
> Cheers,
>
> Friedrich
Friedrich,
No matter where the data source comes from (an Excel spreadsheet, a
Visual "x" program - "x" can be "Basic", "C++", etc. etc. etc...) -
the one key to updating an Image/SQL dataset is a Unique, Primary
Key.
The Unique Primary Key ensures that one and only one row can be
retrieved for subsequent update, or a unique key exists for a new
entry to the datasets. For multi-row updates or inserts, especially
if a CURSOR is used, again, it ensures that one row in the cursor can
be discerned from others. BULK UPDATEs and BULK INSERTs rely on this
primary key as well.
The Unique Primary Key is absolutely essential if using Linked Tables
within MS Access or MS Excel - updates will not work correctly
without it and in most case, will produce a runtime error.
Lastly - even if a Unique Primary Key is used - the use of PCAPI for
the ODBC driver for updates can be iffy. PCAPI is good at reading
the data and writing new entries, but for updates, again, you have a
better chance of success if the Unique Primary Key is defined (and
declared) in the database.
Best Regards,
Joe
---------------------------------------------------------------------
Joe Geiser
CSI Business Solutions
140 Bristol-Oxford Valley Road
Suite 102
Langhorne, PA 19047-3083, USA
Phone: +1 (215) 945-8100/Fax: +1 (215) 943-8408
E-Mail: [log in to unmask] WWW: http://www.csillc.com
---------------------------------------------------------------------
|