Hi Barbara,
I wasn't gong to send another email on this thread again tonight -
but.since this one just arrived.
I read over your earlier message, with the numbered issues a couple of
times, and had a few more comments. Mostly dealing with some of the
features for data exchange between Base / Writer and Calc that perhaps
you are not familiar with yet.
Also, with some ideas about setting up this type of distributed data
entry system, with a centralized roll up database, you are describing.
I've had a little experience with that type of thing in the past, as it
sounds like you have also. I would be interested in why you are
considering using Writer or Calc files for the data entry and not
separate Base files.
I am not really sure if the dev mailing list is the correct place for
that discussion. Perhaps the users list or the user forum would make
more sense, it would be up to you.
For now though it is getting late here, so that will wait till the
morrow. ( or I should say - later today )
Barbara Duprey wrote:
andrew wrote:
Barbara Duprey wrote:
(Comments in message)
Yes, that was the specific question (let's call it Issue 1). In this
case, it would be complicated by the fact that Base did not define
the PK it generated for the original .dbf import as auto-increment.
This one has a work around.
If you drag and drop onto Base, then when the copy table wizard
opens, instead of defining the table and copying the data in, in one
step you simply create the table structure. Then when the field type
INTEGER or BIGINT is marked as the PK it is created as AUTO_INCREMENT.
After this drag and drop again, but this time only append the data to
an existing table - then the data comes in, either include the PK
value from the old table - this works as long as the values are
unique, or simply leave that field out and new keys are made. This
later approach has a down side if there are FK relationships in your
schema of course.
Yes, if I'd known how Base would handle it that's what I'd have done,
but I didn't. The redefinition process is doable, but cumbersome.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
