Hi, We cannot set A_ID to correct value (as part of insert) because this is an > ID column for the actual value column "A". > For example , column A could be "Customer Name" column. > The A_ID column for this column would be "Customer_ID". >
I would probably try to combine those steps, so that you have the customer id when you insert the data. That's the most logical solution, if you want to have high performance. I don't understand why you can't do that, sorry. Also, I don't know why you need to store both the customer name and the customer id in the same table, for every row. Isn't the customer id enough? Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
