C
chriske911
how can I update the same record several times while looping thru an import
file?
the file has a few different lines for the same record in one table
each line contains a number of fields, they are grouped within the file but
have no fixed order or number
I cannot use rs.edit and rs.update because then I jump to another record
when reading the next line
right now I use select case left(filedata, 3) and put midstrings into fields
into this 1 record
this happens until left(filedata,3) indicates the start of a new record
then I use rs.addnew to update the previous and open a new record
but because I also have to be able to automatically delete records in a joined
table I used referential integrity for the join
now I get the message saying the record cannot be added since a linked field
is not present in the joined table
this is true since the current record in the main table is not yet updated,
this only takes place when the next record is added
is there a way to code around this?
or do I just disable warnings?
thn
file?
the file has a few different lines for the same record in one table
each line contains a number of fields, they are grouped within the file but
have no fixed order or number
I cannot use rs.edit and rs.update because then I jump to another record
when reading the next line
right now I use select case left(filedata, 3) and put midstrings into fields
into this 1 record
this happens until left(filedata,3) indicates the start of a new record
then I use rs.addnew to update the previous and open a new record
but because I also have to be able to automatically delete records in a joined
table I used referential integrity for the join
now I get the message saying the record cannot be added since a linked field
is not present in the joined table
this is true since the current record in the main table is not yet updated,
this only takes place when the next record is added
is there a way to code around this?
or do I just disable warnings?
thn