Printable View
Wandering if anyone can advise me, I am a bit stuck. I have been working on
a project using JDBC
to connect to an access Database. This is all fine except when I enforce
referential Integrity! It will
not allow me to enter data into one table at a time as all the primary keys
need to be updated at
the same time. I thought that the Commit and Rollback methods would do the
job but this is also
sequential. Does anyone know how to get around this.
whe retreiving or updating remember to not use the
select * from table1
and when updating the fields update them as field1, field 2 etc..
if you are updating in a batch pre-select the batch first.--ae
"Claire" <rvzec_claire@yahoo.co.uk> wrote:
>
>Wandering if anyone can advise me, I am a bit stuck. I have been working
on
>a project using JDBC
>to connect to an access Database. This is all fine except when I enforce
>referential Integrity! It will
>not allow me to enter data into one table at a time as all the primary keys
>need to be updated at
>the same time. I thought that the Commit and Rollback methods would do the
>job but this is also
>sequential. Does anyone know how to get around this.
